R help - Sep 2003 - reading in a file with multiple data types

Hi,

I have a data file which contains multiple data types
(char and numeric) alongside with line spaces, tabs
and spaces. I hope to extract out the numeric blocks
of the data, probably as matrices or dataframes where
each line in the data block is a corresponding row in
the dataframe/ matrix.

I have tried using many R read functions but they do
not seem to yield the appropriate structure that
allows the extraction of the numeric blocks correctly
(due to the line spaces, tabs and spaces).

I gratefully appreciate any advice and suggestion on
how to obtain the desired data matrices/ dataframes
from this data file in R.

Thank you,
Siew-Leng
*Using R1.7.1. on windows ME, and on Unix.

------------------------------------
My data file contains data in the following block
structure :

1) block of a summary (char)
2) line spaces
3) text line
4) Data : stored as : 
number \t number (spc) number (spc) number (spc) ...
and so on.
[the number of numeric values stored at this line is
not fixed]
5) same structure from 2 - 4

An example of my data (in exact format) is given below
:


Final results
Final value 75.162993 
First case value 11
First case value 10
Case indices 
3 4 1 5 6 7 8 9 10 11 

Estimates : 
8.875350 
3.894280 
7.972684 
4.934348 
0.012406 
0.002134 
-0.024216 
0.072946 
-0.000468 
0.042769 
-0.126641 

Final components :
3 	 0 2 2 

4 	 0 1 

1 	 

5 	 0 0 0 1 2 

6 	 1 1 1 1 1 1 

7 	 1 1 1 1 1 

8 	 1 1 1 1 

9 	 0 0 0 0 1 1 2 

10 	 2 2 

11 	 0 2

You need to use connections to read block by block.

On Sun, 14 Sep 2003, Siew Leng TENG wrote:
> Hi,
> 
> I have a data file which contains multiple data types
> (char and numeric) alongside with line spaces, tabs
> and spaces. I hope to extract out the numeric blocks
> of the data, probably as matrices or dataframes where
> each line in the data block is a corresponding row in
> the dataframe/ matrix.
> 
> I have tried using many R read functions but they do
> not seem to yield the appropriate structure that
> allows the extraction of the numeric blocks correctly
> (due to the line spaces, tabs and spaces).
> 
> I gratefully appreciate any advice and suggestion on
> how to obtain the desired data matrices/ dataframes
> from this data file in R.
> 
> Thank you,
> Siew-Leng
> *Using R1.7.1. on windows ME, and on Unix.
> 
> ------------------------------------
> My data file contains data in the following block
> structure :
> 
> 1) block of a summary (char)
> 2) line spaces
> 3) text line
> 4) Data : stored as : 
> number \t number (spc) number (spc) number (spc) ...
> and so on.
> [the number of numeric values stored at this line is
> not fixed]
> 5) same structure from 2 - 4
> 
> An example of my data (in exact format) is given below
> :
> 
> 
> Final results
> Final value 75.162993 
> First case value 11
> First case value 10
> Case indices 
> 3 4 1 5 6 7 8 9 10 11 
> 
> Estimates : 
> 8.875350 
> 3.894280 
> 7.972684 
> 4.934348 
> 0.012406 
> 0.002134 
> -0.024216 
> 0.072946 
> -0.000468 
> 0.042769 
> -0.126641 
> 
> Final components :
> 3 	 0 2 2 
> 
> 4 	 0 1 
> 
> 1 	 
> 
> 5 	 0 0 0 1 2 
> 
> 6 	 1 1 1 1 1 1 
> 
> 7 	 1 1 1 1 1 
> 
> 8 	 1 1 1 1 
> 
> 9 	 0 0 0 0 1 1 2 
> 
> 10 	 2 2 
> 
> 11 	 0 2
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
> 
> 
-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595