[R] [FORGED] same column name in a data frame
David L Carlson
dcarlson at tamu.edu
Tue Mar 14 15:59:19 CET 2017
How about just using data.frame(): instead of cbind():
> x <- data.frame(a=c(1,2,3))
> y <- data.frame(a=c(2,3,4))
> xy <- data.frame(x, y)
> str(xy)
'data.frame': 3 obs. of 2 variables:
$ a : num 1 2 3
$ a.1: num 2 3 4
> xy$a
[1] 1 2 3
> xy$a.1
[1] 2 3 4
-------------------------------------
David L Carlson
Department of Anthropology
Texas A&M University
College Station, TX 77840-4352
-----Original Message-----
From: R-help [mailto:r-help-bounces at r-project.org] On Behalf Of peter dalgaard
Sent: Tuesday, March 14, 2017 8:43 AM
To: Rolf Turner <r.turner at auckland.ac.nz>
Cc: r-help at r-project.org
Subject: Re: [R] [FORGED] same column name in a data frame
> On 14 Mar 2017, at 03:43 , Rolf Turner <r.turner at auckland.ac.nz> wrote:
>
> On 14/03/17 14:56, Jinsong Zhao wrote:
>> Hi there,
>>
>> I happened to find the following code can generate a data frame with
>> same column name.
>>
>>> x <- data.frame(a=c(1,2,3))
>>> y <- data.frame(a=c(2,3,4))
>>> z <- cbind(x,y)
>>
>> However, in this case, one can not use the $ to extract the second
>> column, right?
>>
>> Is it possible to prevent the cbind() produce a data frame with same
>> column name?
>
> No.
>
> Why not either:
>
> (a) Just make sure the names in "x" and "y" differ?
>
> Or:
>
> (b) Change the names of "z", e.g. names(z) <- c("clyde","irving")?
>
> Or maybe names(z) <- make.unique(names(z)).
>
> You could probably write a wrapper function for cbind() to automate (b) if you really want to.
>
Yes, this is what it is, and I doubt anyone is likely to set out to change it.
However, it is a bit of an oddity compared to the (often undesirable) pains the data.frame code goes through to ensure distinct _row_ names; e.g.,
> cbind(data.frame(a=1), data.frame(a=2))
a a
1 1 2
but
> rbind(data.frame(a=c(foo=1)), data.frame(a=c(foo=2)))
a
foo 1
foo1 2
-pr
--
Peter Dalgaard, Professor,
Center for Statistics, Copenhagen Business School
Solbjerg Plads 3, 2000 Frederiksberg, Denmark
Phone: (+45)38153501
Office: A 4.23
Email: pd.mes at cbs.dk Priv: PDalgd at gmail.com
______________________________________________
R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
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