[R] How to read a *.csv file in R?

[John Kane]

If that is a text file I'd guess that the seperator is a tab.  I don's see why you used NULL as R should just read in the file with NA's for empty values.

You might want to try :
heisenberg <- read.csv(file="comprice.csv",head=TRUE,sep="\t")

John Kane
Kingston ON Canada


> -----Original Message-----
> From: e0928766 at student.tuwien.ac.at
> Sent: Wed, 13 Mar 2013 00:14:58 -0700 (PDT)
> To: r-help at r-project.org
> Subject: [R] How to read a *.csv file in R?
> 
> Hey guys,
> 
> I am dealing with this kind of data. To read the file in R I have nulled
> all
> empty fields and tried:
> 
> date	BRENT	BRENTchg	HWWI	HWWIchg
> Jan. 86	22,5	NULL	68,1	-15,6
> Feb.86	17	NULL	64,9	-21,6
> Mar. 86	13,7	NULL	66,6	-19,5
> Apr.86	12,3	NULL	63,6	-19,1
> May 86	14	NULL	61,5	-20,9
> June 86	11,8	NULL	59,8	-20,7
> July 86	9,4	NULL	57,2	-19,3
> Aug.86	13,2	NULL	55,5	-18,3
> Sep.86	14,2	NULL	57,5	-15,1
> Oct. 86	13,7	NULL	55,5	-14,1
> Nov.86	14,4	NULL	54,9	-14,9
> Dec. 86	15,7	NULL	52,9	-26,4
> Jan. 87	18,3	-18,67	49,8	-26,87
> Feb.87	17,3	1,76	49,9	-23,11
> Mar. 87	17,8	29,93	49,7	-25,38
> Apr.87	18	46,34	50,5	-20,6
> May 87	18,6	32,86	52,3	-14,96
> June 87	18,8	59,32	53,5	-10,54
> July 87	19,8	110,64	54,5	-4,72
> Aug.87	18,9	43,18	55,3	-0,36
> Sep.87	18,2	28,17	55,1	-4,17
> Oct. 87	18,6	35,77	57,8	4,14
> Nov.87	17,7	22,92	55,5	1,09
> Dec. 87	16,8	7,01	56,5	6,81
> Jan. 88	16,7	-8,74	58,4	17,27
> Feb.88	15,7	-9,25	59,5	19,24
> 
>> heisenberg <- read.csv(file="comprice.csv",head=TRUE,sep="")
> Error in read.table(file = file, header = header, sep = sep, quote =
> quote,
> :
>   duplicate 'row.names' are not allowed
> 
> However, my row names are not duplicated. When I try:
> 
>> heisenberg <- read.csv(file="comprice.csv",head=TRUE,sep=",")
> Error in read.table(file = file, header = header, sep = sep, quote =
> quote,
> :
>   more columns than column names
> 
> I have saved the file with excel under *.csv(MSDOS).
> 
> How to read this file?
> 
> Thank you in advance for your help?
> 
> 
> 
> 
> 
> --
> View this message in context:
> http://r.789695.n4.nabble.com/How-to-read-a-csv-file-in-R-tp4661154.html
> Sent from the R help mailing list archive at Nabble.com.
> 
> ______________________________________________
> 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.

____________________________________________________________
FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on your desktop!