Convert comma separated string to numeric columns

by

I think you are looking for the strsplit() function;

a = "2000,1450,1800,2200"
strsplit(a, ",")
[[1]]                                                                                                                                                       
[1] "2000" "1450" "1800" "2200"

Notice that strsplit returns a list, in this case with only one element. This is because strsplit takes vectors as input. Therefore, you can also put a long vector of your single cell characters into the function and get back a splitted list of that vector. In a more relevant example this look like:

# Create some example data
dat = data.frame(reaction_time = 
       apply(matrix(round(runif(100, 1, 2000)), 
                     25, 4), 1, paste, collapse = ","),
                     stringsAsFactors=FALSE)
splitdat = do.call("rbind", strsplit(dat$reaction_time, ","))
splitdat = data.frame(apply(splitdat, 2, as.numeric))
names(splitdat) = paste("trial", 1:4, sep = "")
head(splitdat)
  trial1 trial2 trial3 trial4
1    597   1071   1430    997
2    614    322   1242   1140
3   1522   1679     51   1120
4    225   1988   1938   1068
5    621    623   1174     55
6   1918   1828    136   1816

and finally, to calculate the mean per person:

apply(splitdat, 1, mean)
[1] 1187.50  361.25  963.75 1017.00  916.25 1409.50  730.00 1310.75 1133.75
[10]  851.25  914.75  881.25  889.00 1014.75  676.75  850.50  805.00 1460.00
[19]  901.00 1443.50  507.25  691.50 1090.00  833.25  669.25

More Related Contents:

  1. how to use loop to subset 1000 csv files and do co-integration test in R?
  2. Read multiple CSV files into separate data frames
  3. What’s wrong with my function to load multiple .csv files into single dataframe in R using rbind?
  4. How can you read a CSV file in R with different number of columns
  5. How to read in numbers with a comma as decimal separator?
  6. Subset of rows containing NA (missing) values in a chosen column of a data frame
  7. Prevent row names to be written to file when using write.csv
  8. How do I import a CSV file in R? [closed]
  9. Merge 2 dataframes if value within range
  10. Delete “” from csv values and change column names when writing to a CSV
  11. duplicate ‘row.names’ are not allowed error
  12. Download a file from HTTPS using download.file()
  13. RStudio not picking the encoding I’m telling it to use when reading a file
  14. How to add a index by set of data when using rbindlist?
  15. Read and rbind multiple csv files
  16. How to read csv file in R where some values contain the percent symbol (%)
  17. write.csv for large data.table
  18. Is it possible to get the number of rows in a CSV file without opening it?
  19. How to append a whole dataframe to a CSV in R
  20. Using R to download zipped data file, extract, and import .csv
  21. Partially read really large csv.gz in R using vroom
  22. Save imported csv data in vector – R
  23. Calculate the mean of one column from several CSV files
  24. Correct number of decimal places reading in a .csv
  25. Reading a CSV file organized horizontally
  26. R: How to save lists into csv?
  27. Importing “csv” file with multiple-character separator to R?
  28. How to read specific rows of CSV file with fread function
  29. How can I merge many data frames from csv files when the ID column is implied?
  30. Override column types when importing data using readr::read_csv() when there are many columns

Leave a Comment