Displaying 2 results from an estimated 2 matches for "spreadsheet_002dlik".
Did you mean:
spreadsheet_002dlike
2012 Mar 15
2
Importing multiple worksheets from one Excle/ csv file into R
...39;, I still can not see how to read multiple sheets from one Excle
file or one csv file and put them into one R data.frame.
Or does anyone ever used any packages in part 8 shown in the following link
that can help to do the job I mentioned here??
http://cran.r-project.org/doc/manuals/R-data.html#Spreadsheet_002dlike-data
Many thanks in advance!
HJ
I know how to import one single worksheet in one file but would like to
know how to import data from .csv file containning multiple worksheets.
[[alternative HTML version deleted]]
2006 Feb 14
9
read.table
I have a file named "test.csv" with the following 3 lines:
%y-%m-%d;VALUE
1999-01-01;100
2000-12-31;999
> read.table("test.csv", header = TRUE, sep = ";")
delivers:
X.y..m..d VALUE
1 1999-01-01 100
2 2000-12-31 999
I would like to see the following ...
%y-%m-%d VALUE
1 1999-01-01 100
2 2000-12-31 999
Note,
>