Re: [R] write.table -- maintain decimal places

2011-01-26 Thread Jim Moon 
I am using:
R version 2.11.1 (2010-05-31)
It is good to know that it works in 2.12.1

Jim

-Original Message-
From: Peter Ehlers [mailto:ehl...@ucalgary.ca] 
Sent: Tuesday, January 25, 2011 5:57 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.


What version of R?
I'm using R version 2.12.1 Patched (2010-12-27 r53883)
and it works for me.

Peter Ehlers

 df:
 EFFECT2  PVALUE
 1 0.0230.88080
 2 -0.260  0.08641
 3 -0.114  0.45200

 df.txt:
 EFFECT2PVALUE
 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.0230.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:
 EFFECT2PVALUE
 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.

Re: [R] write.table -- maintain decimal places

2011-01-26 Thread Jim Moon 
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.0230.88080
 2 -0.260  0.08641
 3 -0.114  0.45200

 df.txt:
 EFFECT2PVALUE
 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.0230.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:
 EFFECT2PVALUE
 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.

Re: [R] write.table -- maintain decimal places

2011-01-25 Thread Sebastian P. Luque 
On Tue, 25 Jan 2011 16:16:37 -0800,
Jim Moon moo...@ohsu.edu wrote:

 Hello, All, How can I maintain the decimal places when using
 write.table()?

Have a look at ?format.data.frame


-- 
Seb

__
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.

Re: [R] write.table -- maintain decimal places

2011-01-25 Thread Peter Ehlers 

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.0230.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:
EFFECT2PVALUE
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.

Re: [R] write.table -- maintain decimal places

2011-01-25 Thread Jim Moon 
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.

df:
   EFFECT2  PVALUE
1 0.0230.88080
2 -0.260  0.08641
3 -0.114  0.45200

df.txt:
EFFECT2PVALUE
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.0230.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:
 EFFECT2PVALUE
 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.

Re: [R] write.table -- maintain decimal places

2011-01-25 Thread Peter Ehlers 

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.



What version of R?
I'm using R version 2.12.1 Patched (2010-12-27 r53883)
and it works for me.

Peter Ehlers


df:
EFFECT2  PVALUE
1 0.0230.88080
2 -0.260  0.08641
3 -0.114  0.45200

df.txt:
EFFECT2PVALUE
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.0230.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:
EFFECT2PVALUE
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.

Re: [R] write.table -- maintain decimal places

2011-01-25 Thread Peter Ehlers 

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.0230.88080
2 -0.260  0.08641
3 -0.114  0.45200

df.txt:
EFFECT2PVALUE
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.0230.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:
EFFECT2PVALUE
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.