Great. Thank you, Peter! -----Original Message----- From: Peter Ehlers [mailto:ehl...@ucalgary.ca] Sent: Tuesday, January 25, 2011 7:26 PM To: Jim Moon Cc: r-help@r-project.org Subject: Re: [R] write.table -- maintain decimal places
On 2011-01-25 17:22, Jim Moon wrote: > Thank you for the response, Peter. > > The approach: > write.table(format(df, > drop0trailing=FALSE),file='df.txt',quote=F,sep='\t',row.names=F) > surprisingly still results in some loss of trailing 0's. Here are a couple more (essentially identical) ways: # 1. dfm <- within(df, { EFFECT2 <- sprintf("%6.3f", EFFECT2) PVALUE <- sprintf("%7.5f", PVALUE) }) # 2. dfm <- within(df, { EFFECT2 <- formatC(EFFECT2, format="f", digits=3) PVALUE <- formatC(PVALUE, format="f", digits=5) }) write.table(dfm, file='dfm.txt', quote=FALSE, sep='\t', row.names=FALSE) Peter Ehlers > > df: > EFFECT2 PVALUE > 1 0.023 0.88080 > 2 -0.260 0.08641 > 3 -0.114 0.45200 > > df.txt: > EFFECT2 PVALUE > 0.023 8.808e-01 > -0.26 8.641e-02 > -0.114 4.520e-01 > > > -----Original Message----- > From: Peter Ehlers [mailto:ehl...@ucalgary.ca] > Sent: Tuesday, January 25, 2011 5:09 PM > To: Jim Moon > Cc: r-help@r-project.org > Subject: Re: [R] write.table -- maintain decimal places > > On 2011-01-25 16:16, Jim Moon wrote: >> Hello, All, >> >> How can I maintain the decimal places when using write.table()? >> >> Jim >> >> e.g. >> >> df: >> EFFECT2 PVALUE >> 1 0.023 0.88080 >> 2 -0.260 0.08641 >> 3 -0.114 0.45200 >> >> write.table(df,file='df.txt',quote=F,sep='\t',row.names=F) > > write.table(format(df, drop0trailing=FALSE), ....) > > Peter Ehlers > >> >> >> df.txt: >> EFFECT2 PVALUE >> 0.023 0.8808 >> -0.26 0.08641 >> -0.114 0.452 >> >> [[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. > ______________________________________________ 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.