Hi, Within Excel, I save the file as a .csv file and then read it into R using read.csv. This will generate a data frame object which can then be fed to the extRemes Toolkit.
Alternatively you could master the R-ODBC package to load an excel file directly, but I find that rather complicated :D Regards, Ahraz -----Original Message----- From: Petr Pikal [mailto:[EMAIL PROTECTED] Sent: 01 November 2006 08:09 To: amna khan Cc: [email protected] Subject: Re: [R] how to make a data file Hi I use clipboard for transfering data from Excel. In Excel select the part you want to copy to R Press Ctrl-C In R write test <- read.delim("clipboard") or read.table("clipboard") to transfer your data to "test" data frame. However if you will not go through some introduction manual (what I already recommended) and do not know how to manipulate objects in R, you will quickly be completely lost. To use R efficiently you need to accept that it has its own language, terminology and its own way how to do things. R is not Excel (Thanks goodness :-) HTH Petr On 1 Nov 2006 at 11:42, amna khan wrote: Date sent: Wed, 1 Nov 2006 11:42:05 +0500 From: "amna khan" <[EMAIL PROTECTED]> To: "Petr Pikal" <[EMAIL PROTECTED]> Subject: Re: [R] how to make a data file > Sir i have been poor for saving data in form of a datafile. please > guid me in simple words to make a data file after importing it from > excel. Thank you > > > On 10/31/06, Petr Pikal <[EMAIL PROTECTED]> wrote: > > > > Hi > > > > well probably the best approach for you is to read some introductory > > documents. I would recommend this sequence > > > > R-intro > > R-lang > > R-data > > Posting guide > > > > or you can try to go through some documents from CRAN, in many of > > them you can find introductory chapters. > > > > And leas but not last when starting with R I found usefull Paul > > Johnson's Rtips (StatsRUs). > > > > At least for more concise help you need to provide R version, OS, > > and what exactly you did and how you failed - as recommended in > > posting guide ;-) > > > > HTH > > Petr > > > > > > On 31 Oct 2006 at 11:31, amna khan wrote: > > > > Date sent: Tue, 31 Oct 2006 11:31:08 +0500 > > From: "amna khan" <[EMAIL PROTECTED]> > > To: [email protected] > > Subject: [R] how to make a data file > > > > > Sir after importing data from excel to R, I am not understanding > > > how to make this data file. So that I can use it in extRemeToolkit > > > and other packages. Thank you > > > > > > -- > > > AMINA SHAHZADI > > > Department of Statistics > > > GC University Lahore, Pakistan. > > > Email: > > > [EMAIL PROTECTED] > > > [EMAIL PROTECTED] > > > [EMAIL PROTECTED] > > > > > > [[alternative HTML version deleted]] > > > > > > ______________________________________________ > > > [email protected] mailing list > > > https://stat.ethz.ch/mailman/listinfo/r-help > > > PLEASE do read the posting guide > > > http://www.R-project.org/posting-guide.html and provide commented, > > > minimal, self-contained, reproducible code. > > > > Petr Pikal > > [EMAIL PROTECTED] > > > > > > > -- > AMINA SHAHZADI > Department of Statistics > GC University Lahore, Pakistan. > Email: > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > Petr Pikal [EMAIL PROTECTED] ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
