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
Tena koe Fredj
There are lots of ways, depending on your precise task and preference. Have
you Googled 'Import data from Excel to R'? That will bring up lots of relevant
hits, including the data import/export manual that ships with R.
FWIW, I use RODBC and have written a simple wrapper to do
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 guess you were talking about column names instead of rownames.
If you have a data like the one below to read:
dat1<-read.table(text="
beta0 beta1 pvalor Crom
rs17 158.5980 12.252462 9.083193e-135 1
rs46 163.3730 3.304276 3.279925e-06 1
rs63
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
11 matches
Mail list logo
