How to read in numbers with a comma as decimal separator?

by

When you check ?read.table you will probably find all the answer that you need.

There are two issues with (continental) European csv files:

  1. What does the c in csv stand for? For standard csv this is a ,, for European csv this is a ;
    sep is the corresponding argument in read.table
  2. What is the character for the decimal point? For standard csv this is a ., for European csv this is a ,
    dec is the corresponding argument in read.table

To read standard csv use read.csv, to read European csv use read.csv2. These two functions are just wrappers to read.table that set the appropriate arguments.

If your file does not follow either of these standards set the arguments manually.

More Related Contents:

  1. how to use loop to subset 1000 csv files and do co-integration test in R?
  2. What’s wrong with my function to load multiple .csv files into single dataframe in R using rbind?
  3. How to convert dataframe into time series?
  4. Trimming a huge (3.5 GB) csv file to read into R
  5. Convert comma separated string to numeric columns
  6. Specifying colClasses in the read.csv
  7. How do I import a CSV file in R? [closed]
  8. Merge 2 dataframes if value within range
  9. Delete “” from csv values and change column names when writing to a CSV
  10. duplicate ‘row.names’ are not allowed error
  11. RStudio not picking the encoding I’m telling it to use when reading a file
  12. Convert numbers to SI prefix
  13. How to add a index by set of data when using rbindlist?
  14. Error in file(file, “rt”) : cannot open the connection [duplicate]
  15. How to check if CSV file has a comma or a semicolon as separator?
  16. R on Windows: character encoding hell
  17. Preserving large numbers
  18. How to read csv file in R where some values contain the percent symbol (%)
  19. write.csv for large data.table
  20. Using R to download zipped data file, extract, and import .csv
  21. Trying to merge multiple csv files in R
  22. Partially read really large csv.gz in R using vroom
  23. Save imported csv data in vector – R
  24. Calculate the mean of one column from several CSV files
  25. Correct number of decimal places reading in a .csv
  26. Reading a CSV file organized horizontally
  27. R: How to save lists into csv?
  28. Importing “csv” file with multiple-character separator to R?
  29. How to read specific rows of CSV file with fread function
  30. How can I merge many data frames from csv files when the ID column is implied?

Leave a Comment