Dear R users;
I am trying to read an excel CSV file (1.csv). When I read it as csv file
in R, the R shows me the exact number of row. But it puts all columns in
one column, while I have 3 or 4 columns in the data frame.
"
d4 = read.table("./4.csv",sep=";",header=TRUE)
Warning messages:
1: In read.table("./4.csv", sep = ";", header = TRUE) :
line 1 appears to contain embedded nulls
2: In read.table("./4.csv", sep = ";", header = TRUE) :
line 2 appears to contain embedded nulls
3: In read.table("./4.csv", sep = ";", header = TRUE) :
line 3 appears to contain embedded nulls
4: In read.table("./4.csv", sep = ";", header = TRUE) :
line 4 appears to contain embedded nulls
5: In read.table("./4.csv", sep = ";", header = TRUE) :
line 5 appears to contain embedded nulls
6: In read.table("./4.csv", sep = ";", header = TRUE) :
line 1 appears to contain embedded nulls
7: In scan(file = file, what = what, sep = sep, quote = quote, dec =
dec, :
embedded nul(s) found in input
> attach(d4)
> dim(d4)
[1] 1814394 1
"
I opened the csv file in excel and I tried to make a new csv (delimited)
file. I dont know why in the "save as type" box Unicode text (*.txt) is
written. Why the format is txt while the file extension is .CSV?
Please help me to read this format correctly.
Many thanks.
--
Best Regards
Javad Bayat
M.Sc. Environment Engineering
Alternative Mail: bayat...@yahoo.com
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
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.
