Re: [R] sorting data

From: ONKELINX, Thierry <Thierry.ONKELINX_at_inbo.be>
Date: Thu, 21 Jun 2007 16:06:57 +0200


Why don't you use a package like RODBC and read the data directly from the Excel file? Then you probably won't have to worry on how to get the dates in the right format.

Another, maybe easier, solution is to export the Excel to CSV and then use read.csv().

Cheers,

Thierry




ir. Thierry Onkelinx
Instituut voor natuur- en bosonderzoek / Research Institute for Nature and Forest
Cel biometrie, methodologie en kwaliteitszorg / Section biometrics, methodology and quality assurance
Gaverstraat 4
9500 Geraardsbergen
Belgium
tel. + 32 54/436 185
Thierry.Onkelinx_at_inbo.be
www.inbo.be

Do not put your faith in what statistics say until you have carefully considered what they do not say. ~William W. Watt A statistical analysis, properly conducted, is a delicate dissection of uncertainties, a surgery of suppositions. ~M.J.Moroney  

> -----Oorspronkelijk bericht-----
> Van: r-help-bounces_at_stat.math.ethz.ch
> [mailto:r-help-bounces_at_stat.math.ethz.ch] Namens dala
> Verzonden: donderdag 21 juni 2007 15:54
> Aan: r-help_at_stat.math.ethz.ch
> Onderwerp: [R] sorting data
>
>
> I have a 2 columns, Date and Number, in Excel.
> I copy and paste them into Notepad.
> I can use scan() to import the file but how do I plot this
> data with Date as the x-axis?
> --
> View this message in context:
> http://www.nabble.com/sorting-data-tf3958889.html#a11233613
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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.
>



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. Received on Thu 21 Jun 2007 - 14:26:39 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 21 Jun 2007 - 14:32:09 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.