[R] import csv file into R, strange problem
Rainer M Krug
r.m.krug at gmail.com
Wed Sep 14 10:28:01 CEST 2011
-----BEGIN PGP SIGNED MESSAGE-----
On 13/09/11 18:08, bonnieyuan wrote:
> Hi, I used read.csv(file name, header=T, sep=",") to bring in a csv
> file I saved in MS Excel. The strange thing is all the data ended
> up in one big column. The number of rows match with the number of
> observations, but all the variables got squeezed into one column.
> Also the first row where the header is, the variables names have a
> dot between them, replacing the comma that's in the original csv
> What did I do wrong here?
Maybe Microsoft? We had the problem in South Adfrica, that if the
locale was set to South African English, then the csv was ";"
seperated - don't tell me why.
So: check your csv if it is really a csv.
> -- View this message in context:
Sent from the R help mailing list archive at Nabble.com.
> ______________________________________________ R-help at r-project.org
> mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do
> read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
Rainer M. Krug, PhD (Conservation Ecology, SUN), MSc (Conservation
Biology, UCT), Dipl. Phys. (Germany)
Centre of Excellence for Invasion Biology
Tel : +33 - (0)9 53 10 27 44
Cell: +33 - (0)6 85 62 59 98
Fax : +33 - (0)9 58 10 27 44
Fax (D): +49 - (0)3 21 21 25 22 44
email: Rainer at krugs.de
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
-----END PGP SIGNATURE-----
More information about the R-help