Dear all,
I have a problem with importing an excel file into R. I can open the
file easily (either saving it as a CSV or using RODBC). But the
original file is using merged cell in its first column, which gives
the name of the observation. (I am dealing with repeated measurements
for the same
head(x,30)
On 6/30/07, Lhachimi, Stefan [EMAIL PROTECTED] wrote:
Dear all,
I have a problem with importing an excel file into R. I can open the
file easily (either saving it as a CSV or using RODBC). But the
original file is using merged cell in its first column, which gives
the name
==
# load the 'zoo' library for the function na.locf
require(zoo)
x$V1 - na.locf(x$V1) # key
x$V2 - na.locf(x$V2) # name
head(x,30)
On 6/30/07, Lhachimi, Stefan [EMAIL PROTECTED] wrote:
Dear all,
I have a problem with importing an excel file into R. I can open the
file easily
I use very much Excel in my job and often I've to read
Excel data in R. Usually I save Excel file as a .txt
file and then I read it in R with read.table().
I find really interesting the suggest of using the
function read.xls() in the 'gregmisc' package.
I work also with R in Excel sheets by
Hi,
I'm trying to use read.xls() function to import Excel
data, but I've this error:
Error in system(cmd, intern = !verbose) : perl not
found
R is running under Win2000;
This function works translating the named Microsoft
Excel file into a temporary .csv file, using Greg
Warnes' xls2csv perl
Hi,
On Thu, 8 Jul 2004, [iso-8859-1] Vito Ricci wrote:
Hi,
I'm trying to use read.xls() function to import Excel
data, but I've this error:
Error in system(cmd, intern = !verbose) : perl not
found
What happens?
It means it cannot find Perl. You need Perl installed (and in your Path)
in
Vito Ricci wrote:
Hi,
I'm trying to use read.xls() function to import Excel
data, but I've this error:
Error in system(cmd, intern = !verbose) : perl not
found
R is running under Win2000;
This function works translating the named Microsoft
Excel file into a temporary .csv file, using Greg
Warnes'
Hi
If you do not have complicated items with spaces and special
characters and you want some easy copiing on fly just issue in R
read.delim(clipboard)
after selecting an area in Excel file and pressing Ctrl-C
Cheers
Petr
On 8 Jul 2004 at 9:15, Vito Ricci wrote:
I use very much Excel in my
Hi Vito:
You may consider obtaining ActivePerl from the following site and install it in
Windows:
http://www.activestate.com/Products/ActivePerl/
and then retry.
HTH,
Arin
On Thu, 08 Jul 2004 Vito Ricci wrote :
Hi,
I'm trying to use read.xls() function to import Excel
data, but I've this
Hello, R users,
I am a very beginner of R and tried read.csv to import an excel file after
saving an excel file as csv. But it added alternating rows of fictitious NA
values after row number 16. When I applied read.delim, there were trailing
several commas at the end of each row after row number
On Wed, 2004-07-07 at 13:21, Park, Kyong H Mr. RDECOM wrote:
Hello, R users,
I am a very beginner of R and tried read.csv to import an excel file after
saving an excel file as csv. But it added alternating rows of fictitious NA
values after row number 16. When I applied read.delim, there were
On Wed, 2004-07-07 at 13:44, Marc Schwartz wrote:
On Wed, 2004-07-07 at 13:21, Park, Kyong H Mr. RDECOM wrote:
Hello, R users,
I am a very beginner of R and tried read.csv to import an excel file after
saving an excel file as csv. But it added alternating rows of fictitious NA
values
Am Mittwoch, 7. Juli 2004 20:21 schrieb Park, Kyong H Mr. RDECOM:
Hello, R users,
I am a very beginner of R and tried read.csv to import an excel file after
saving an excel file as csv. But it added alternating rows of fictitious NA
values after row number 16. When I applied read.delim, there
13 matches
Mail list logo
