[R] Importing CSV File

[Petr PIKAL]

Hi

r-help-bounces at r-project.org napsal dne 25.10.2010 00:47:22:

> sales <- read.csv(file="C:/Program Files/R/Test Data/sales.csv",
>             header=TRUE, row.names = "Month") 
> ________________________________^^^^^^^^^^^^^^^^^^^
> 
> 
> -----Original Message-----
> From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] 
On 
> Behalf Of Jason Kwok
> Sent: Monday, 25 October 2010 8:27 AM
> To: Erik Iverson
> Cc: r-help at 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?

Following Bill's answer I would add that you can not have duplicated row 
names. In your example it does not matter as each month is unique, but if 
you have more occurrences of some months you can not use it as a row name.

Regards
Petr

> 
> Thanks,
> 
> Jason
> 
> On Sun, Oct 24, 2010 at 6:20 PM, Erik Iverson <eriki at 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 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 to a variable name,
> > (e.g., df1 <- read.csv(...) ), the object got printed.
> >
> > A data.frame object is going to have a row.names attribute by 
definition,
> > which is what you're seeing.
> >
> > In ?data.frame, we see documentation for the "row.names" argument:
> >
> >  If 'row.names' was supplied as 'NULL'
> >     or no suitable component was found the row names are the integer
> >     sequence starting at one (and such row names are considered to be
> >     'automatic', and not preserved by 'as.matrix').
> >
> > The method that prints out a data.frame is called print.data.frame,
> > and it does have an argument to suppress printing of the row.names.
> >
> > The question is, why do you not want row.names?  Are they just
> > distracting you when printed, or is there some reason not to
> > carry them along in the object?
> >
> > --Erik
> >
> >
> >
> >> Thanks,
> >>
> >> Jason
> >>
> >> *>  read.csv(file="C:\\Program Files\\R\\Test 
Data\\sales.csv",head=TRUE)
> >>        Month Sales
> >> 1    January   422
> >> 2   February   151
> >> 3      March   451
> >> 4      April   175
> >> 5        May   131
> >> 6       June   307
> >> 7       July    47
> >> 8     August    12
> >> 9  September   488
> >> 10   October   122
> >> 11  November    54
> >> 12  December   244
> >>
> >>> *
> >>>
> >>
> >>        [[alternative HTML version deleted]]
> >>
> >> ______________________________________________
> >> R-help at r-project.org 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.
> >>
> >
> >
> 
>    [[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at r-project.org 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.