Hi, How do I open an excel file in R? I have save the excel file in unicode text format, but it is not possible to open the file in R. /Pernilla
-----Urspr??ngliche Nachricht-----
Von: TEMPL Matthias
Gesendet: Montag, 12. Juli 2004 17:29
An: 'Pernilla Karlsson'
Betreff: Re: [R] Excel file
It is possible to open the file in R.
?read.table
excelfile <- read.table("../file.txt", sep=",",
header=T)
when you have a komma as seperator and a header in your .txt file.
The seperator and the header should be set correctly.
Or save your excel file in the .csv format and do
read.csv(...)
Best,
Matthias
> > -----Urspr??ngliche Nachricht-----
> > Von: Pernilla Karlsson [mailto:pernilla.karlsson at mednut.ki.se]
> > Gesendet: Montag, 12. Juli 2004 17:17
> > An: R-help at stat.math.ethz.ch
> > Betreff: [R] Excel file
> >
> >
> > Hi,
> >
> > How do I open an excel file in R? I have save the excel file
> > in unicode text format, but it is not possible to open the
> file in R.
> >
> > /Pernilla
> >
> > ______________________________________________
> > R-help at stat.math.ethz.ch mailing list
> > https://www.stat.math.ethz.ch/mailman/listinfo> /r-help
> > PLEASE
> > do read the posting guide!
> > http://www.R-project.org/posting-guide.html
> >
>
On Mon, 12 Jul 2004 17:17:00 +0200, "Pernilla Karlsson" <pernilla.karlsson at mednut.ki.se> wrote :>Hi, > >How do I open an excel file in R? I have save the excel file in unicode text >format, but it is not possible to open the file in R.See the R Data Import/Export manual (via Help|Manuals). You probably want to save in CSV format. Duncan Murdoch
Pernilla Karlsson wrote:> Hi, > > How do I open an excel file in R? I have save the excel file in unicode text > format, but it is not possible to open the file in R. > > /Pernilla > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > https://www.stat.math.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.htmlSee the "R Data Import/Export" manual and the Posting Guide cited above. Uwe Ligges
Hi,
We just discussed about this matter last week; see the
subject in the mailing list:
[R]Importing an Excel file
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
as seggested by Petr
or you can you can use read.xls() function included in
the package "gregmisc", but you must install Perl on
your PC. In this way you could import MS Excel file
directly in format xls, without saving it as .csv or
.txt.
Bye
Vito
Hi,
How do I open an excel file in R? I have save the
excel file in unicode text
format, but it is not possible to open the file in R.
/Pernilla
====Diventare costruttori di soluzioni
Visitate il portale http://www.modugno.it/
e in particolare la sezione su Palese
http://www.modugno.it/archivio/cat_palese.shtml
Hi Pernilla Under menu go to help >manuals > R Data Import/Export and read the section on spreadsheet-like data import. Also you can try ?read.table Francisco>From: "Pernilla Karlsson" <pernilla.karlsson at mednut.ki.se> >To: <R-help at stat.math.ethz.ch> >Subject: [R] Excel file >Date: Mon, 12 Jul 2004 17:17:00 +0200 > >Hi, > >How do I open an excel file in R? I have save the excel file in unicode >text >format, but it is not possible to open the file in R. > >/Pernilla > >______________________________________________ >R-help at stat.math.ethz.ch mailing list >https://www.stat.math.ethz.ch/mailman/listinfo/r-help >PLEASE do read the posting guide! >http://www.R-project.org/posting-guide.html
Hi Group, I have a set of number (~300) and I want to find the unique numbers in it. Basically I want to get rid of duplicate numbers. Is there a function in R to do this. Please help. thank you SP --- F Z <gerifalte28 at hotmail.com> wrote:> Hi Pernilla > > Under menu go to help >manuals > R Data > Import/Export and read the section > on spreadsheet-like data import. > Also you can try ?read.table > > Francisco > > > >From: "Pernilla Karlsson" > <pernilla.karlsson at mednut.ki.se> > >To: <R-help at stat.math.ethz.ch> > >Subject: [R] Excel file > >Date: Mon, 12 Jul 2004 17:17:00 +0200 > > > >Hi, > > > >How do I open an excel file in R? I have save the > excel file in unicode > >text > >format, but it is not possible to open the file in > R. > > > >/Pernilla > > > >______________________________________________ > >R-help at stat.math.ethz.ch mailing list > >https://www.stat.math.ethz.ch/mailman/listinfo/r-help > >PLEASE do read the posting guide! > >http://www.R-project.org/posting-guide.html > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list >https://www.stat.math.ethz.ch/mailman/listinfo/r-help> PLEASE do read the posting guide! > http://www.R-project.org/posting-guide.html >
?unique S Peri wrote:>Hi Group, > I have a set of number (~300) and I want to find the >unique numbers in it. Basically I want to get rid of >duplicate numbers. Is there a function in R to do >this. > >Please help. > >thank you > >SP > > > > >--- F Z <gerifalte28 at hotmail.com> wrote: > > >>Hi Pernilla >> >>Under menu go to help >manuals > R Data >>Import/Export and read the section >>on spreadsheet-like data import. >>Also you can try ?read.table >> >>Francisco >> >> >> >> >>>From: "Pernilla Karlsson" >>> >>> >><pernilla.karlsson at mednut.ki.se> >> >> >>>To: <R-help at stat.math.ethz.ch> >>>Subject: [R] Excel file >>>Date: Mon, 12 Jul 2004 17:17:00 +0200 >>> >>>Hi, >>> >>>How do I open an excel file in R? I have save the >>> >>> >>excel file in unicode >> >> >>>text >>>format, but it is not possible to open the file in >>> >>> >>R. >> >> >>>/Pernilla >>> >>>______________________________________________ >>>R-help at stat.math.ethz.ch mailing list >>> >>> >>https://www.stat.math.ethz.ch/mailman/listinfo/r-help >> >> >>>PLEASE do read the posting guide! >>>http://www.R-project.org/posting-guide.html >>> >>> >>______________________________________________ >>R-help at stat.math.ethz.ch mailing list >> >> >> >https://www.stat.math.ethz.ch/mailman/listinfo/r-help > > >>PLEASE do read the posting guide! >>http://www.R-project.org/posting-guide.html >> >> >> > >______________________________________________ >R-help at stat.math.ethz.ch mailing list >https://www.stat.math.ethz.ch/mailman/listinfo/r-help >PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html > >