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

From: jim holtman <jholtman_at_gmail.com>
Date: Mon, 04 Apr 2011 09:57:25 -0400

?read.table

Then look at the 'fill' & 'flush' parameters; this may do the trick

On Mon, Apr 4, 2011 at 9:32 AM, Ram H. Sharma <sharma.ram.h_at_gmail.com> wrote:
> 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.
>

-- 
Jim Holtman
Data Munger Guru

What is the problem that you are trying to solve?

______________________________________________
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 - 14:00:48 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