Splitting a string into new rows in R
- by user3703195
I have a data set like below:
Country Region  Molecule        Item Code
IND     NA       PB102      FR206985511
THAI    AP       PB103      BA-107603 / F000113361 / 107603
LUXE    NA       PB105      1012701 / SGP-1012701 / F041701000
IND     AP       PB106      AU206985211 / CA-F206985211
THAI    HP       PB107      F034702000 / 1010701 / SGP-1010701
BANG    NA       PB108      F000007970/25781/20009021
I want to split based the string values in ITEMCODE column on / and create a new row for each entry.
For instance, the desired output will be:
Country Region  Molecule    Item Code                            New row
IND      NA      PB102     FR206985511                           FR206985511
THAI     AP      PB103     BA-107603 / F000113361 / 107603       F000113361 
                                                                 107603
                                                                 BA-107603 
LUXE    NA       PB105     1012701 / SP-1012701 / F041701000     1012701
                                                                 SP-1012701 
                                                                 F041701000
IND     AP       PB106     AU206985211 / CA-F206985211           AU206985211
                                                                 CA-F206985211
THAI    HP       PB107     F034702000 / 1010701 / SP-1010701     F034702000
                                                                 1010701
                                                                 SP-1010701
BANG    NA       PB108     F000007970/25781/20009021             F000007970
                                                             25781
                                                             20009021
I tried the below code 
library(splitstackshape)
df2=concat.split.multiple(df1,"Plant.Item.Code","/", direction="long")
but got the Error
"Error: memory exhausted (limit reached?)"
When i tried strsplit() i got the below error message.
Error in strsplit(df1$Plant.Item.Code, "/") : non-character argument
Any help from you will be appreciated.