R: Split unbalanced list in data.frame column

by 
#Split by ; as before
allJobs <- strsplit(df$b, ";", fixed=TRUE)

#Replicate a by the number of jobs in each case
n <- sapply(allJobs, length)
id <- rep(df$a, times = n)

#Turn allJobs into a vector
job <- unlist(allJobs)

#Retrieve position of each job
jobNum <- unlist(lapply(n, seq_len))

#Combine into a data frame
df2 <- data.frame(id = id, job = job, jobNum = jobNum)

More Related Contents:

  1. Reshape three column data frame to matrix (“long” to “wide” format) [duplicate]
  2. Convert data from long format to wide format with multiple measure columns
  3. Fastest way to add rows for missing time steps?
  4. Change value of variable with dplyr
  5. Why is plyr so slow?
  6. Split Data Frame into Rows of Fixed Size
  7. Reshaping data.frame from wide to long format
  8. Combine two data frames by rows (rbind) when they have different sets of columns
  9. Convert a list to a data frame
  10. How to combine multiple conditions to subset a data-frame using “OR”?
  11. Splitting a dataframe string column into multiple different columns [duplicate]
  12. Conditional replacement of values in a data.frame
  13. How do I combine two data-frames based on two columns? [duplicate]
  14. Count NAs per row in dataframe [duplicate]
  15. dplyr filter with condition on multiple columns
  16. Create categories by comparing a numeric column with a fixed value
  17. Add a prefix to column names
  18. Add empty columns to a dataframe with specified names from a vector
  19. How to save a data.frame in R?
  20. How to append rows to an R data frame
  21. Specifying column names in a data.frame changes spaces to “.”
  22. merge data.frames based on year and fill in missing values
  23. Delete a column in a data frame within a list
  24. Dollar sign before a variable
  25. Count number of zeros per row, and remove rows with more than n zeros
  26. How I can select rows from a dataframe that do not match?
  27. Select last non-NA value in a row, by row
  28. ddply for sum by group in R
  29. Difference between `names(df[1])
  30. Data.frame Merge and Selection of values which are common in 2 Data.frames

Leave a Comment