Excel data to R

freeze4real · 2013-06-12 21:57:35

Hi guys, I am having problems opening an excel file saved as CSV to R. I am getting errors which says that the file is not on the directory where I saved it. I am new to R. So I have no clue as to what the error means. Mods I am not sure if this query is meant to be on the development forum o maths forum.If you can bridge…

12-06-2013 10:57PM

#1

freeze4real

Registered Users, Registered Users 2 Posts: 2,540 ✭✭✭

Join Date: November 2009

Posts: 2337

Hi guys,

I am having problems opening an excel file saved as CSV to R.

I am getting errors which says that the file is not on the directory where I saved it.

I am new to R. So I have no clue as to what the error means.

Mods I am not sure if this query is meant to be on the development forum o maths forum.If you can bridge it I will really appreciate it thanks.

0

Comments

#2 14-06-2013 12:39AM

sock puppet

Registered Users, Registered Users 2 Posts: 4,586 ✭✭✭

Join Date: June 2006

Posts: 4564

Check that the file path is correct. Otherwise you can change the directory in R up the top to where you have the csv file saved. So instead of writing read.csv("C:\.......\myfile.csv") you can just write read.csv("myfile.csv"). It's handy as well for outputting files as everything's in one place.

0
#3 15-06-2013 10:50PM

freeze4real

Registered Users, Registered Users 2 Posts: 2,540 ✭✭✭

Join Date: November 2009

Posts: 2337

Thanks I got it to work.

0