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.ra...@ouce.ox.ac.uk <mailto: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 <mailto: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?
______________________________________________
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.