Dear all;
I use your suggestion but I gave the same warning messages. I changed the
file name (Data.csv).
"
d4<-read.csv("./Data.csv",sep=";",header=TRUE,encoding="UTF-16")
Warning messages:
1: In read.table(file = file, header = header, sep = sep, quote =
quote, :
line 1 appears to contain embedded nulls
2: In read.table(file = file, header = header, sep = sep, quote =
quote, :
line 2 appears to contain embedded nulls
3: In read.table(file = file, header = header, sep = sep, quote =
quote, :
line 3 appears to contain embedded nulls
4: In read.table(file = file, header = header, sep = sep, quote =
quote, :
line 4 appears to contain embedded nulls
5: In read.table(file = file, header = header, sep = sep, quote =
quote, :
line 5 appears to contain embedded nulls
6: In read.table(file = file, header = header, sep = sep, quote =
quote, :
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
"
I opened the Data in notepad. This is the head of Data.csv. The columns
have been separated by semicolons.
"
"INLET Time";"INLET ValueY";"TRATED WATER TANK Time";"TRATED WATER TANK
ValueY"
10/28/2018;550.057861328125;10/28/2018;487.812530517578
10/28/2018 12:00:01 ق.ظ;550.057861328125;10/28/2018 12:00:01
ق.ظ;487.812530517578
10/28/2018 12:00:02 ق.ظ;550.057861328125;10/28/2018 12:00:02
ق.ظ;487.812530517578
10/28/2018 12:00:03 ق.ظ;550.057861328125;10/28/2018 12:00:03
ق.ظ;487.812530517578
10/28/2018 12:00:04 ق.ظ;550.057861328125;10/28/2018 12:00:04
ق.ظ;487.812530517578
.
.
.
"
Thanks.
On Tue, Jul 2, 2019 at 6:14 AM Jeff Newmiller <jdnew...@dcn.davis.ca.us>
wrote:
> 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.
>
--
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.
