R: CSV files
CSV data file is one of the most common formats for storing table data. CSV file can be with header, or without header. Also it can be comma, semi-column or tab separated. Float digits can be with . or , decimal separators.
Reading from CSV file in R
In R different functions are used to read from these different types of files, which is not very optimal.
There are main function to read CSV files are:
- read.csv(filename) - Read CSV file , separated
- read.csv(filename, header=FALSE) - - Read CSV file , separated without header line
- read.csv2(filename) - Read CSV file with ; separator and , as a deciaml separator
- read.delim(filename) - Read CSV file TAB separated
But you should also remember, that other parameters can be used to adjust the format of the given CSV file in more details
Also, it is strongly recommend after reading CSV file data <- read.csv(filename) to check it with str(data) to understand what the columns name are. Some special characters from CSV in the names are substituted by dots.
Exporting data to CSV
To write CSV file use function write.csv(data, file=filename)
> coffe <- data.frame(
+ country = c("aaaa", "bbbb", "cccc", "dddd"),
+ product = c(33.3, 22.2, 44.4, 11.1),
+ percent = c(30, 20, 40, 10),
+ increas = c(F, F, T, F))
write.csv(coffe, file="coffe.csv")
#"","country","product","percent","increas"
#"1","aaaa",33.3,30,FALSE
#"2","bbbb",22.2,20,FALSE
#"3","cccc",44.4,40,TRUE
#"4","dddd",11.1,10,FALSE
Published: 2021-11-11 01:07:17
Last 10 artitles
- 2025-04-05 16:11:46 - Simple Python Projects
- 2025-04-05 16:09:15 - Currency exchange rate
- 2025-03-28 08:41:03 - Privacy Policy - https://mycoding.uk/
- 2024-11-29 16:38:37 - Estimating super-sonic missile velocity in the atmosphere
- 2024-11-27 19:16:02 - YouTube manipulations
- 2024-10-31 19:17:21 - Hydrogen (H) electron density
- 2024-10-31 16:09:56 - Period 1 element
- 2024-10-31 12:46:28 - Atom electron clouds
- 2024-10-31 12:04:50 - Ephemerides
- 2024-10-19 14:46:49 - Polynomial fit with Numpy polyfit
9 popular artitles
- Python Panda (2319)
- Python NumPy (1698)
- Python: How to make absolute links in BeautifulSoup (1129)
- In-place and out-place Numpy functions (1078)
- Python: How to make video from images (1017)
- Linear first order ODE (990)
- NumPy: What the difference between mgrid and meshgrid (957)
- Polynomial fit with Numpy polyfit (866)
- Plotting of Interactive Electric field due to point charges with Matplotlib (859)
