Displaying 6 results from an estimated 6 matches similar to: "prcomp: Error in La.svd(x, nu, nv): error code 1 from Lapack routine "dgesdd""
2017 Aug 27
1
help with read.csv() for files with different number of columns
Dear R community,
I have a text file (test.txt) with different number of columns:
0610007P14Rik%%% Tcf19 Gtf2i 0610010O12Rik%%% Ivns1abp Etv6 1100001G20Rik%%% Nmi 1500015O10Rik%%% Foxi1 Ascl3 Sirt3 1700003E16Rik%%% Ascl2 Ifnar2 1700028J19Rik%%% Musk Nfe2l3 1810011O10Rik%%% Ppp1r13b Bpnt1 Cdkn2c Foxc1 Sox10 Smarca2 1810019D21Rik%%% Asb8 1810037I17Rik%%% Zfp612 1810055G02Rik%%% Nkx2-3 Maged1 Runx1
2017 Aug 27
0
help with read.csv() for files with different number of columns
Hi Ace,
As your example seems to have spaces as separators,
testdf<-read.table("test.txt",header=FALSE,fill=TRUE,
col.names=paste("V",1:14,sep=""),stringsAsFactors=FALSE)
By specifying the number of columns with "col.names" and using
"fill=TRUE" you can get a data frame with zero length strings where
values are missing in the input file.
Jim
2017 Aug 28
2
help with read.csv() for files with different number of columns
Hi, Jim,
Thank you very much for pointing out the format issue. Here is the original text:
===I have a text file (test.txt) with different number of columns:
0610007P14Rik%%% Tcf19 Gtf2i 0610010O12Rik%%% Ivns1abp Etv6 1100001G20Rik%%% Nmi 1500015O10Rik%%% Foxi1 Ascl3 Sirt3 1700003E16Rik%%% Ascl2 Ifnar2 1700028J19Rik%%% Musk Nfe2l3 1810011O10Rik%%% Ppp1r13b Bpnt1 Cdkn2c Foxc1 Sox10 Smarca2
2017 Aug 29
2
help with read.csv() for files with different number of columns
Thank you very much! Looks like I have to know the length of each record ahead of time.
Ace
On Monday, August 28, 2017 12:56 AM, Jim Lemon <drjimlemon at gmail.com> wrote:
Hi Ace,
With tabs as separators:
testdf<-read.table("test.txt",header=FALSE,fill=TRUE,sep="\t",
col.names=paste("V",1:19,sep=""),stringsAsFactors=FALSE)
Also note
2017 Aug 28
0
help with read.csv() for files with different number of columns
Hi Ace,
With tabs as separators:
testdf<-read.table("test.txt",header=FALSE,fill=TRUE,sep="\t",
col.names=paste("V",1:19,sep=""),stringsAsFactors=FALSE)
Also note that I got the number of columns wrong the first time.
Jim
On Mon, Aug 28, 2017 at 12:56 PM, Fix Ace <acefix at rocketmail.com> wrote:
> Hi, Jim,
>
> Thank you very much for
2017 Aug 29
0
help with read.csv() for files with different number of columns
Hi Ace,
You can just read the file first to find out:
max_fields<-function(file,sep=" ") {
rlines<-readLines(file)
return(max(unlist(lapply(sapply(rlines,strsplit,sep),length))))
}
nmax<-max_fields(test.txt,"\t")
Jim
On Wed, Aug 30, 2017 at 2:22 AM, Fix Ace <acefix at rocketmail.com> wrote:
> Thank you very much! Looks like I have to know the length of