On 14.09.2011 10:28, Rainer M Krug wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
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
file.
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.
Probably MS expects that South Africans, like Germans, use a comma ","
as the decimal "point", and hence the separator is ";". That's why
read.csv2() is available - reading that pseudo comma separated format..
Uwe Ligges
So: check your csv if it is really a csv.
Cheers,
Rainer
-- View this message in context:
http://r.789695.n4.nabble.com/import-csv-file-into-R-strange-problem-tp3810470p3810470.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________ R-help@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
Stellenbosch University
South Africa
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: rai...@krugs.de
Skype: RMkrug
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAk5wZZEACgkQoYgNqgF2egqGfgCeKWohnNQONvSge1M6Bf9OtBMP
ln4An1n64fYAwNfTzc3rbD/tRXx9ksry
=XYvm
-----END PGP SIGNATURE-----
______________________________________________
R-help@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.
______________________________________________
R-help@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.
