> 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)
Firstly, I recommend against naming your file "1.csv". (Start with a letter not a number). Secondly, a CSV file should be separated by commas not semicolons. You can specify sep=",", however, it's probably easier to use the read.csv() function. Note that you should be able to open your file in a text editor to see the separators. > I dont know why in the "save as type" box Unicode text (*.txt) Other posters have suggested that you need to specify the encoding. Assuming that you create your CSV file correctly in Excel, I doubt that this is necessary, but I could be wrong... Your comment suggests that you have saved your document as "Unicode text". You need to tell Excel to save the file as a CSV file. (There should be a list of save options). Simply typing a file name with a .csv file extension is unlikely to produce the desired result. [[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.