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.ra...@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@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? [[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.
