Splitting a string into new rows in R [duplicate]

by

Try the cSplit function (as you already using @Anandas package). Note that is will return a data.table object, so make sure you have this package installed. You can revert back to data.frame (if you want to) by doing something like setDF(df2)

library(splitstackshape)
df2 <- cSplit(df1, "Item.Code", sep = "https://stackoverflow.com/", direction = "long")
df2
#     Country Region Molecule      Item.Code
#  1:     IND     NA    PB102    FR206985511
#  2:    THAI     AP    PB103      BA-107603 
#  3:    THAI     AP    PB103     F000113361 
#  4:    THAI     AP    PB103         107603
#  5:    LUXE     NA    PB105        1012701 
#  6:    LUXE     NA    PB105    SGP-1012701 
#  7:    LUXE     NA    PB105     F041701000
#  8:     IND     AP    PB106    AU206985211 
#  9:     IND     AP    PB106  CA-F206985211
# 10:    THAI     HP    PB107     F034702000 
# 11:    THAI     HP    PB107        1010701 
# 12:    THAI     HP    PB107    SGP-1010701
# 13:    BANG     NA    PB108     F000007970
# 14:    BANG     NA    PB108          25781
# 15:    BANG     NA    PB108       20009021

More Related Contents:

  1. Split data frame string column into multiple columns
  2. Split delimited strings in a column and insert as new rows [duplicate]
  3. How to split a data frame?
  4. Split a large dataframe into a list of data frames based on common value in column
  5. Calculate the mean of every 13 rows in data frame
  6. Splitting a dataframe string column into multiple different columns [duplicate]
  7. Split dataframe into multiple output files
  8. Split data.frame by value
  9. Splitting a large data frame into smaller segments
  10. Split Data Frame into Rows of Fixed Size
  11. Split up a dataframe by number of rows
  12. Split dataframe using two columns of data and apply common transformation on list of resulting dataframes
  13. Split a column by group [duplicate]
  14. Reshaping data.frame from wide to long format
  15. Combine two data frames by rows (rbind) when they have different sets of columns
  16. How to combine multiple conditions to subset a data-frame using “OR”?
  17. Changing Column Names in a List of Data Frames in R
  18. dplyr filter with condition on multiple columns
  19. Create categories by comparing a numeric column with a fixed value
  20. Add empty columns to a dataframe with specified names from a vector
  21. How to sort a data frame in R
  22. How to use the strsplit function with a period
  23. dplyr – filter by group size
  24. How to save a data.frame in R?
  25. How to append rows to an R data frame
  26. Create dataframe from a matrix
  27. How to append a whole dataframe to a CSV in R
  28. Count unique values for every column
  29. What you can do with a data.frame that you can’t with a data.table?
  30. Override column types when importing data using readr::read_csv() when there are many columns

Leave a Comment