By dafault, write.csv will change the characters such as 5/38 as a date
May-38. How can I not change the format?
Thanks.
ChangJiang
[[alternative HTML version deleted]]
__
R-help@r-project.org mailing list
Read your Excel documentation. AFAIK, R just writes text files -- you
need to tell Excel how to read them in.
Cheers,
Bert
Bert Gunter
Genentech Nonclinical Biostatistics
(650) 467-7374
Data is not information. Information is not knowledge. And knowledge
is certainly not wisdom.
H. Gilbert
ChangJiang:
Open the .csv file with Notepad or other plain vanilla text processor,
NOT EXCEL. You will find that the columns are text. Excel
automatically converts them to dates. Read Excel's docs or get help
from someone to learn how to convert the dates back to text.
-- Bert
Bert Gunter
Hi ChangJiang,
Date conversion is one of the biggest headaches with Excel. Even if you
import those data into Excel and then specify that the column should be
text format, it won't convert the values back into what they
originally were. Be aware that Excel may, when encountering dates from a
Thanks. I still didn't get the solution. For example, I have a data frame,
called temp
temp
Chr Ref Var AFFUNAFF AFF.test pvalue
1 10 A G 2/1/240/0/1905/49 2.429e-09
2 18 G A 1/9/17 0/23/167 11/43 2.484e-04
3 1 G A 2/2/220/8/176
Hi
I second Jim's comments.
I have also been bitten by British being converted to American format as
well as ANSI numeric to a date format which I did not want .
And if you want to take a daily series from the 1890's to the 2000's caveat
emptor.
If you are dealing with dates use something that
6 matches
Mail list logo