Don't be so US-centric, Abby... how do you know that javad's version of Excel
doesn't default to using semicolons?
?read.csv2
On July 1, 2019 6:06:32 PM PDT, Abby Spurdle <spurdl...@gmail.com> wrote:
>> 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.
--
Sent from my phone. Please excuse my brevity.
______________________________________________
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.
