Re: [R] Query: how to add quotes when importing a txt file

From: Jorge Ivan Velez <jorgeivanvelez_at_gmail.com>
Date: Fri, 09 May 2008 09:02:17 -0400

Hi Stefano,

Take a look at ?read.table and its friends. Now, assuming that your file is "data.txt" you can use, for example:

# Option 1
> df=read.table('your.ubication.here/data.txt',header=FALSE)
> df

# Option 2
Copy your data set in the clipboard and write this in the R Console:

> df=read.table('clipboard')
> df

In my opinion, I think you don't need the quotes at least you use

> y="10092007 24.62 24.31 24.90

11092007 19.20 23.17 22.10
13092007 24.71 27.33 23.10
14092007 27.33 27.90 24.10
15092007 28.22 28.55 24.30
16092007 28.53 29.24 27.40
17092007 24.19 30.64 26.80
18092007 22.60 20.62 28.40
19092007  8.89  1.70 14.70
20092007 21.27  2.92 17.30
21092007 22.38 24.72  8.80
22092007 23.94 24.73 20.40
23092007 25.33 25.12 22.60
24092007 24.91 22.46 21.40
25092007 23.52 25.00 21.70
26092007  2.50  2.29  8.80"

> df=read.table(textConnection(y),header=FALSE)
> df

HTH, Jorge

On Fri, May 9, 2008 at 8:52 AM, Stefano Sofia < stefano.sofia_at_regione.marche.it> wrote:

>
> Dear R users,
> I have a txt file of the form
>
> 10092007 24.62 24.31 24.90
> 11092007 19.20 23.17 22.10
> 13092007 24.71 27.33 23.10
> 14092007 27.33 27.90 24.10
> 15092007 28.22 28.55 24.30
> 16092007 28.53 29.24 27.40
> 17092007 24.19 30.64 26.80
> 18092007 22.60 20.62 28.40
> 19092007 8.89 1.70 14.70
> 20092007 21.27 2.92 17.30
> 21092007 22.38 24.72 8.80
> 22092007 23.94 24.73 20.40
> 23092007 25.33 25.12 22.60
> 24092007 24.91 22.46 21.40
> 25092007 23.52 25.00 21.70
> 26092007 2.50 2.29 8.80
>
> and I have to import it into R. The problem is that I have to add the
> quotes at the beginning and end of the file, like shown here below. I tried
> to use read.zoo (in fact I will have to use the zoo package afterwards), but
> I have not been able to do what I need.
> Could you please help me in that? (not necessarily with read.zoo, any
> method will be fine!)
>
> "10092007 24.62 24.31 24.90
> 11092007 19.20 23.17 22.10
> 13092007 24.71 27.33 23.10
> 14092007 27.33 27.90 24.10
> 15092007 28.22 28.55 24.30
> 16092007 28.53 29.24 27.40
> 17092007 24.19 30.64 26.80
> 18092007 22.60 20.62 28.40
> 19092007 8.89 1.70 14.70
> 20092007 21.27 2.92 17.30
> 21092007 22.38 24.72 8.80
> 22092007 23.94 24.73 20.40
> 23092007 25.33 25.12 22.60
> 24092007 24.91 22.46 21.40
> 25092007 23.52 25.00 21.70
> 26092007 2.50 2.29 8.80"
>
> thank you
> Stefano
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help_at_r-project.org 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

        [[alternative HTML version deleted]]



R-help_at_r-project.org 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 Fri 09 May 2008 - 13:17:08 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 Fri 09 May 2008 - 13:30:35 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.

list of date sections of archive