How to read a *.csv file in R?

-----Original Message-----
From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org]
On Behalf Of Maximus
Sent: Wednesday, March 13, 2013 12:15 AM
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?

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