[R] reading from text file that have different rowlength and create a data frame

From: Ram H. Sharma <sharma.ram.h_at_gmail.com>
Date: Mon, 04 Apr 2011 09:32:14 -0400


Hi R-experts

I have many text files to read and combined them into one into R that are output from other programs. My textfile have unbalanced number of rows for example:

;this is example
; r help

Var1     Var2      Var3      Var4      Var5
0             0.05     0.01        12
1             0.04     0.06        18        A
2             0.05     0.08        14
3             0.01     0.06        15       B
4             0.05     0.07        14       C

and so on
Inames<-as.data.frame(read.table("CLG1mpd.asc",header=T,comment=";")) Inames<-as.matrix(read.table("example.txt",header=T,comment=";")) Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, :
  line 1 did not have 5 elements

In bestcase scenerio, I want to fill the blank space with NA's, with matrix or dataframe

 Var1     Var2      Var3      Var4      Var5
0             0.05     0.01        12        NA
1             0.04     0.06        18        A
2             0.05     0.08        14       NA
3             0.01     0.06        15       B
4             0.05     0.07        14       C

The minimum would be to remove the column Var5, so that my data.frame would look like the follows:

 Var1     Var2      Var3      Var4
0             0.05     0.01        12
1             0.04     0.06        18
2             0.05     0.08        14
3             0.01     0.06        15
4             0.05     0.07        14
-- 
Thank you in advance for the help.

Ram H

	[[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.
Received on Mon 04 Apr 2011 - 13:56:04 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Mon 04 Apr 2011 - 14:10:26 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive