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: ml-node+s789695n4647264h98@n4.nabble.com
To: wenbo520@live.cn
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]]


