Most of the time I would agree with csv being the best format. _If_ you
are dealing with plain ASCII text.
Having spent most of yesterday with an Excel spreadsheet containing Russian
letters, I can say it is quite difficult to export the data to Unicode
UTF-16 tab-delimited text and then successf
Although it may seem troublesome to export to csv, I have found that every
direct access library for reading Excel files seems to come with some fiddly
bits that confuse new users (and can show down an experienced user). For
example, XLConnect can be a headache if your files are large because it
On Wed, Sep 10, 2014 at 3:51 AM, Omar André Gonzáles Díaz
wrote:
> The best way is to save the file as CSV... after you can simply import it
> with this comand in R:
>
> read.csv(...) ... to know more about the read.csv comand use in R this:
> ?read.csv.
>
> There are other packages to import EXCE
The best way is to save the file as CSV... after you can simply import it
with this comand in R:
read.csv(...) ... to know more about the read.csv comand use in R this:
?read.csv.
There are other packages to import EXCEL FILES, but the simplest way, its
importing this as CSV.
2014-09-09 18:03 GM
On Tue, Sep 9, 2014 at 4:48 PM, JAWADI Fredj wrote:
> Hi
> I am a New user of R.
> Please, how to import data from Excel to R?
> Thanks,
> Best regards,
> Fredj,
>
There are some ways listed here:
https://web.archive.org/web/20131109195709/http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_win
pper to do the most standard
tasks (which I can share if you like)
Peter Alspach
-Original Message-
From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On
Behalf Of JAWADI Fredj
Sent: Wednesday, 10 September 2014 8:48 a.m.
To: r-help@R-project.org
Subject: [R] I
Read the manual.
http://cran.r-project.org/doc/manuals/r-release/R-data.html#Reading-Excel-spreadsheets
Best,
Ista
On Sep 9, 2014 6:39 PM, "JAWADI Fredj" wrote:
> Hi
> I am a New user of R.
> Please, how to import data from Excel to R?
> Thanks,
> Best regards,
> Fredj,
>
>
> [[alternat
Hi
I am a New user of R.
Please, how to import data from Excel to R?
Thanks,
Best regards,
Fredj,
[[alternative HTML version deleted]]
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting
reason to eliminate the column names??
A.K.
- Original Message -
From: li li
To: r-help
Cc:
Sent: Wednesday, August 15, 2012 5:04 PM
Subject: [R] Import Data from Excel
Dear all,
I want to import just part of an excel data file into R.
I would like to have the data imported wi
On Aug 15, 2012, at 4:07 PM, David Winsemius wrote:
On Aug 15, 2012, at 2:04 PM, li li wrote:
Dear all,
I want to import just part of an excel data file into R.
I would like to have the data imported without
rownames or colume names.
I used read.delim("clipboard", header=F). Somehow even
On Aug 15, 2012, at 2:04 PM, li li wrote:
Dear all,
I want to import just part of an excel data file into R.
I would like to have the data imported without
rownames or colume names.
I used read.delim("clipboard", header=F). Somehow even though
I added the argument "header=F", I still have
Hannah:
1. First of all, they are column names, not row names.
2. Second, no, you cannot fix it. All columns in a data frame *must*
have names, and if none are obtained from the "import," the defaults
you see will be provided.
See ?data.frame for details of how columns are named.
Columns of data
Dear all,
I want to import just part of an excel data file into R.
I would like to have the data imported without
rownames or colume names.
I used read.delim("clipboard", header=F). Somehow even though
I added the argument "header=F", I still have the row names V1, V2, ...,
Does anyone kno
13 matches
Mail list logo
