[R] write.csv: set the name of the column containing the row.names
Rui Barradas
ruipbarradas at sapo.pt
Wed Mar 19 12:18:30 CET 2014
Hello,
> write.csv(df, row.names=TRUE, col.names=c("ID", colnames(df)))
"","a","b"
"A",1,3
"B",2,4
"C",3,5
Warning message:
In write.csv(df, row.names = TRUE, col.names = c("ID", colnames(df))) :
attempt to set 'col.names' ignored
This gives a warning, not an error message. I've also tried setting
col.names = NA, and the same warning message is given. Why I don't know,
according to the help page ?write.csv the default behavior should be
overriden.
Hope this helps,
Rui Barradas
Em 19-03-2014 11:01, Luca Cerone escreveu:
> Thanks Ista,
> sorry it was a typo in my email, but in the code I have the right option.
>
> On Wed, Mar 19, 2014 at 11:58 AM, Ista Zahn <istazahn at gmail.com> wrote:
>> The argument is "col.names", not "colnames".
>>
>> Best,
>> Ista
>>
>> On Mar 19, 2014 6:14 AM, "Luca Cerone" <luca.cerone at gmail.com> wrote:
>>>
>>> Hi everybody,
>>> I am sorry if this is a silly question (I have tried to search it at
>>> http://tolstoy.newcastle.edu.au/R/ but I get a 404 page).
>>>
>>> I have a script writing some data.frames to csv files.
>>> I write the csv files using the write.csv function and the option
>>> row.names=TRUE.
>>> Everything works fine, except that I am not able to set the name of
>>> the column holding the row.names.
>>>
>>> For example I tried to set the column name to ID like this:
>>>
>>> df = data.frame(a=c(1,2,3), b=c(3,4,5))
>>> rownames(df) = c("A","B","C")
>>>
>>> write.csv(df, row.names=TRUE, colnames=c("ID", colnames(df)))
>>>
>>> This fails with the following error:
>>> Error in write.table(df, row.names = TRUE, colnames = c("ID",
>>> colnames(df)), :
>>> unused argument (colnames = c("ID", colnames(df)))
>>>
>>> How can I do this? I have tried to use write.table() as well, but it
>>> seems I never get to set the options right.
>>>
>>> Thanks a lot in advance for the help,
>>>
>>> Cheers,
>>> Luca
>>>
>>> ______________________________________________
>>> 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.
>
> ______________________________________________
> 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.
>
More information about the R-help
mailing list