How to read data when some numbers contain commas as thousand separator?

by

Not sure about how to have read.csv interpret it properly, but you can use gsub to replace "," with "", and then convert the string to numeric using as.numeric:

y <- c("1,200","20,000","100","12,111")
as.numeric(gsub(",", "", y))
# [1]  1200 20000 100 12111

This was also answered previously on R-Help (and in Q2 here).

Alternatively, you can pre-process the file, for instance with sed in unix.

More Related Contents:

  1. duplicate ‘row.names’ are not allowed error
  2. Aggregate / summarize multiple variables per group (e.g. sum, mean)
  3. Collapse / concatenate / aggregate a column to a single comma separated string within each group
  4. Order Bars in ggplot2 bar graph
  5. Sort (order) data frame rows by multiple columns
  6. Filter data.frame rows by a logical condition
  7. Evaluate expression given as a string
  8. Pass a data.frame column name to a function
  9. How to save a plot as image on the disk?
  10. Paste multiple columns together
  11. Using R to download zipped data file, extract, and import data
  12. Extracting specific columns from a data frame
  13. How does one reorder columns in a data frame?
  14. Group by multiple columns in dplyr, using string vector input
  15. Fitting a density curve to a histogram in R
  16. Changing date format in R
  17. How to perform natural (lexicographic) sorting in R? [duplicate]
  18. Test if characters are in a string
  19. as.Date with dates in format m/d/y in R
  20. How to order data by value within ggplot facets
  21. How to filter a data frame
  22. Delete “” from csv values and change column names when writing to a CSV
  23. Create categorical variable in R based on range
  24. Apply several summary functions (sum, mean, etc.) on several variables by group in one call
  25. Order of operator precedence when using “:” (the colon)
  26. How to read csv file in R where some values contain the percent symbol (%)
  27. Using R to download zipped data file, extract, and import .csv
  28. consolidating data frames in R
  29. What does the error “arguments imply differing number of rows: x, y” mean?
  30. R: How to split a data frame into training, validation, and test sets?

Leave a Comment