[R] how to make a data file

[Ahraz.Sheikh at ubs.com]

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:petr.pikal at precheza.cz] 
Sent: 01 November 2006 08:09
To: amna khan
Cc: r-help at stat.math.ethz.ch
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" <amnakhan493 at gmail.com>
To:             	"Petr Pikal" <petr.pikal at precheza.cz>
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 <petr.pikal at precheza.cz> 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" <amnakhan493 at gmail.com>
> > To:                     R-help at stat.math.ethz.ch
> > 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:
> > > amnakhan493 at gmail.com
> > > amna_989 at hotmail.com
> > > amna_989 at yahoo.com
> > >
> > >  [[alternative HTML version deleted]]
> > >
> > > ______________________________________________
> > > R-help at stat.math.ethz.ch 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
> > petr.pikal at precheza.cz
> >
> >
> 
> 
> --
> AMINA SHAHZADI
> Department of Statistics
> GC University Lahore, Pakistan.
> Email:
> amnakhan493 at gmail.com
> amna_989 at hotmail.com
> amna_989 at yahoo.com
> 

Petr Pikal
petr.pikal at precheza.cz