Re: [R] Importing CSV File

2010-10-25 Thread Petr PIKAL
[mailto:r-help-boun...@r-project.org] On Behalf Of Jason Kwok Sent: Monday, 25 October 2010 8:27 AM To: Erik Iverson Cc: r-help@r-project.org Subject: Re: [R] Importing CSV File Thanks for the response Erik. In this case, I would like to keep the row name as the month. How would I do

[R] Importing CSV File

2010-10-24 Thread Jason Kwok
I'm trying to import a CSV file into R and when it gets imported, the entries get numbered down the left side. How do I get rid of that? Thanks, Jason * read.csv(file=C:\\Program Files\\R\\Test Data\\sales.csv,head=TRUE) Month Sales 1January 422 2 February 151 3 March

Re: [R] Importing CSV File

2010-10-24 Thread Erik Iverson
On 10/24/2010 04:57 PM, Jason Kwok wrote: I'm trying to import a CSV file into R and when it gets imported, the entries get numbered down the left side. How do I get rid of that? When you imported the CSV file into R, an object of class data.frame was created, and since you did not assign it

Re: [R] Importing CSV File

2010-10-24 Thread Jason Kwok
Thanks for the response Erik. In this case, I would like to keep the row name as the month. How would I do that? Thanks, Jason On Sun, Oct 24, 2010 at 6:20 PM, Erik Iverson er...@ccbr.umn.edu wrote: On 10/24/2010 04:57 PM, Jason Kwok wrote: I'm trying to import a CSV file into R and when

Re: [R] Importing CSV File

2010-10-24 Thread Bill.Venables
Of Jason Kwok Sent: Monday, 25 October 2010 8:27 AM To: Erik Iverson Cc: r-help@r-project.org Subject: Re: [R] Importing CSV File Thanks for the response Erik. In this case, I would like to keep the row name as the month. How would I do that? Thanks, Jason On Sun, Oct 24, 2010 at 6:20 PM, Erik

Re: [R] Importing CSV File

2010-10-24 Thread Liviu Andronic
On Mon, Oct 25, 2010 at 12:26 AM, Jason Kwok jayk...@gmail.com wrote: Thanks for the response Erik. In this case, I would like to keep the row name as the month.  How would I do that? You can do this in Rcmdr. First Data Import From text file (or select your data.frame as active data set),

[R] Importing csv file with character values into sqlite3 and subsequent problem in R / RSQLite

2009-03-30 Thread Stephan Lindner
Dear all, I'm trying to import a csv file into sqlite3 and from there into R. Everything looks fine exepct that R outputs the character values in an odd fashion: they are shown as \CHARACTER\ instead of CHARACTER, but only if I show the character variable as a vector. Does someone know why this

Re: [R] Importing csv file with character values into sqlite3 and subsequent problem in R / RSQLite

2009-03-30 Thread Gabor Grothendieck
There are some examples of reading files into sqlite on the sqldf home page: http://sqldf.googlecode.com On Mon, Mar 30, 2009 at 12:19 PM, Stephan Lindner lindn...@umich.edu wrote: Dear all, I'm trying to import a csv file into sqlite3 and from there into R. Everything looks fine exepct