> -----Original Message-----
> From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org]
> On Behalf Of Maximus
> Sent: Wednesday, March 13, 2013 12:15 AM
> To: r-help@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?
>
>
The data appear to be tab delimited with the decimal point being a comma (',').
So, try read.csv2()
heisenberg <- read.csv2(file="comprice.csv", header=TRUE, sep="\t")
Hope this is helpful,
Dan
Daniel Nordlund
Bothell, WA USA
______________________________________________
R-help@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.
