[R] reading in file with different row length

[Muhammad Rahiz]

Thanks Jim but I've tried the method but it didnt work.

Space separates the columns so when I pass

x <- read.csv("test.txt",sep=",")

it reads and prints ok but gives the wrong dim

> x <- dim(x)
[1] 9 1

when the dim(x) should be 9 3


Muhammad 





jim holtman wrote:
> What is the delimiter between the columns?  If it is a tab/comma, then 
> read.table will handle it.  If as your example shows, the missing data 
> is just a space, then you will have to have some code that cleans up 
> the data,  For example a single space is replaced by a single comma, 
> two spaces replaced by two commas, ...  Then read.csv should handle it 
> fine.
>
> On Thu, May 6, 2010 at 12:10 PM, Muhammad Rahiz 
> <muhammad.rahiz at ouce.ox.ac.uk <mailto:muhammad.rahiz at ouce.ox.ac.uk>> 
> wrote:
>
>     Hi all,
>
>     I have a file, say, test.txt, which contains the following
>     information. I'm trying to read in the file and specifying the
>     missing values as NA so that each column has the same number of rows.
>
>     I've tried all sorts of manipulation but to no avail.
>
>     r1 r2 r3
>     1   3
>     2   3
>     3 2 3
>     4 2 3
>     5 2 3
>     6 2 3
>     7 2
>     8 2
>     9 2 3
>
>     The output should be
>
>     r1 r2 r3
>     1 NA 3
>     2 NA 3
>     3 2 3
>     4 2 3
>     5 2 3
>     6 2 3
>     7 2 NA
>     8 2 NA
>     9 2 3
>
>     Muhammad
>
>     ______________________________________________
>     R-help at r-project.org <mailto: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
>     <http://www.r-project.org/posting-guide.html>
>     and provide commented, minimal, self-contained, reproducible code.
>
>
>
>
> -- 
> Jim Holtman
> Cincinnati, OH
> +1 513 646 9390
>
> What is the problem that you are trying to solve?