Thanks, JeffThis is from a course, but the course is just needed to take some
slides for presentation. I just learn R by myself, and want this skill more
practical. So I try to use the innovative way to perform a more professional
presentation.hence, no worry about the homework support issue. However, I still
got the problem, I think I did the right thing to make the excel, then change
the extension to csv to make sure it has the appropriate comma in it.But the
warning still be there. I will try other more. Thank you.
Date: Tue, 23 Oct 2012 20:14:53 -0700
From: [email protected]
To: [email protected]
Subject: Re: incomplete final line found by readTableHeader
Keep in mind that this is NOT a homework support list... you are
supposed to use the support provided by your educational institution if you are
in a course. Read the posting guide mentioned in the footer of every email.
FWIW, as described your problem is with Excel, and this is not an Excel support
list either. I suggest that you edit the csv file with a text editor (e.g.
NotePad) to make sure the correct number of commas are on each line of the data
file.
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<[hidden email]> Basics: ##.#. ##.#. Live Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.
Shane2012 <[hidden email]> wrote:
>Hello,
>
>I am trying to read in an Excel file that I saved as a .csv so I can
>analyze
>my assignment data! I am getting really frustrated because this is what
>I
>keep getting:
>Warning message:
>In read.table("CityData.CSV", sep = "/", header = T) :
> incomplete final line found by readTableHeader on 'CityData.CSV'
>
>I have open the file and make sure click return after the last line,
>then
>save the file.
>
>I try to use kinds of read data frame methods, such as
>
>read.table
>
>read.csv or
>my.files <- list.files("path")
>for(i in my.files)
>{
> nam <- paste("CityData", substr(i, 14, 15), sep ='')
> assign(nam, read.csv(i))
>}
>-------------------------
>They all failed.
>
>Can anyone offer some help? Thanks a lot!
>
>
>
>--
>View this message in context:
>http://r.789695.n4.nabble.com/incomplete-final-line-found-by-readTableHeader-tp4647259.html
>Sent from the R help mailing list archive at Nabble.com.
>
>______________________________________________
>[hidden email] 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.
______________________________________________
[hidden email] 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.
If you reply to this email, your message will be added to the
discussion below:
http://r.789695.n4.nabble.com/incomplete-final-line-found-by-readTableHeader-tp4647259p4647264.html
To unsubscribe from incomplete final line found by
readTableHeader, click here.
NAML
--
View this message in context:
http://r.789695.n4.nabble.com/incomplete-final-line-found-by-readTableHeader-tp4647259p4647265.html
Sent from the R help mailing list archive at Nabble.com.
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
