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

[Maximus]

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.