R help - May 2008 - Query: how to add quotes when importing a txt file

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]]

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
That is not correct.  The file is fine the way it is.  Read it in
using read.zoo.  See ?read.zoo and read the
three vignettes that come with zoo.

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@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@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]]

Hi Stefano,

Why do you *need* to add the quotes to the text file? If you leave them 
out, any of the standard methods of reading data (i.e., 
read.table(filename, sep="") should work. See help(read.table), 
help(scan), or help(read.fwf) for more info.

Mike

Stefano Sofia 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.
>   
-- 
Michael D. Rennie
Ph.D. Candidate
University of Toronto at Mississauga
3359 Missisagua Rd. N. 
Mississauga, ON L5L 1C6
Ph: 905-828-5452 Fax: 905-828-3792
www.utm.utoronto.ca/~w3rennie