r - Duplicate columns in dyadic-year data -


as title indicates have dyadic-year data. problem have (for reason...) duplicated dyadic column names – example, shown below, a , b b observations make no sense. real data on 70.000 observations.

what want generate dummy variable indicate same-same dyadic observations. 

person1     person2      year                            1990                           1991                           1992                  b          1990                  b          1991                  b          1992                 c          1990                 c          1991                 c          1992        b           b          1990        b           b          1991        b           b          1992        ...

the function duplicated() doesn't help, other basic r commands since it's dyadic data.

here's reproducible example 

structure(list(person1 = structure(c(1l, 1l, 1l, 1l, 1l, 1l,  1l, 1l, 1l, 2l, 2l, 2l, 2l, 2l, 2l, 2l, 2l, 2l, 3l, 3l, 3l, 3l,  3l, 3l, 3l, 3l, 3l), .label = c("a", "b", "g"), class = "factor"),      person2 = structure(c(1l, 1l, 1l, 2l, 2l, 2l, 3l, 3l, 3l,      1l, 1l, 1l, 2l, 2l, 2l, 3l, 3l, 3l, 1l, 1l, 1l, 2l, 2l, 2l,      3l, 3l, 3l), .label = c("a", "b", "c"), class = "factor"),      year = c(1990l, 1991l, 1992l, 1990l, 1991l, 1992l, 1990l,      1991l, 1992l, 1990l, 1991l, 1992l, 1990l, 1991l, 1992l, 1990l,      1991l, 1992l, 1990l, 1991l, 1992l, 1990l, 1991l, 1992l, 1990l,      1991l, 1992l)), .names = c("person1", "person2", "year"), class = "data.frame", row.names = c(na,  -27l))

the desired output (duplicate dummy)

person1 person2 year    duplicate             1990    1             1991    1             1992    1          b    1990    0          b    1991    0          b    1992    0          c    1990    0          c    1991    0          c    1992    0 b             1990    0 b             1991    0 b             1992    0 b          b    1990    1 b          b    1991    1 b          b    1992    1

we can comparing 'person1' 'person2'

setdt(df1)[, duplicate := as.integer(as.character(person1) == as.character(person2))]  head(df1, 15) #    person1 person2 year duplicate # 1:             1990         1 # 2:             1991         1 # 3:             1992         1 # 4:             b 1990         0 # 5:             b 1991         0 # 6:             b 1992         0 # 7:             c 1990         0 # 8:             c 1991         0 # 9:             c 1992         0 #10:       b       1990         0 #11:       b       1991         0 #12:       b       1992         0 #13:       b       b 1990         1 #14:       b       b 1991         1 #15:       b       b 1992         1

or using base r

transform(df1, duplicate = as.integer(as.character(person1)== as.character(person2)))

-

Comments

Post a Comment

Popular posts from this blog

serialization - Convert Any type in scala to Array[Byte] and back -

i have following question: i have variable value in program declared value. i want convert value byte array.. how can serialize byte array , back? found examples related other types such double or int, not any. this should need. it's pretty similar how 1 in java. import java.io.{bytearrayinputstream, bytearrayoutputstream, objectinputstream, objectoutputstream} object serialization extends app { def serialise(value: any): array[byte] = { val stream: bytearrayoutputstream = new bytearrayoutputstream() val oos = new objectoutputstream(stream) oos.writeobject(value) oos.close stream.tobytearray } def deserialise(bytes: array[byte]): = { val ois = new objectinputstream(new bytearrayinputstream(bytes)) val value = ois.readobject ois.close value } println(deserialise(serialise("my test"))) println(deserialise(serialise(list(1)))) println(deserialise(serialise(map(1 -> 2)))) println(deserialise(seri
Read more

matplotlib support failed in PyCharm on OSX -

any idea how fix ? how can debug might problem ? not seem : https://youtrack.jetbrains.com/issue/py-15520 i in console: python 2.6.9 (unknown, jul 14 2015, 19:46:31) [gcc 4.2.1 compatible apple llvm 6.0 (clang-600.0.39)] on darwin >>> import matplotlib.pyplot plt matplotlib support failed the backend : >>> import matplotlib >>> print(matplotlib.rcparams['backend']) macosx
Read more

python - Matplotlib: TypeError: 'AxesSubplot' object is not callable -

i new programming please pardon me if rookie mistake. i writing python script have defined functions create subplots of distributions. i have slider widget end user change value of variables(mu , sigma) , see effect on distribution. here's code import numpy np print np.__version__ import scipy print scipy.__version__ scipy.stats import norm, lognorm, uniform import matplotlib print matplotlib.__version__ import matplotlib.pyplot plt matplotlib.widgets import slider, button, radiobuttons, checkbuttons #####calculating mean , standard deviation##### global mu_a1 mu_a1 = 1 global mu_b1 mu_b1 = 10 global mu_c1 mu_c1 = -13 global sigma_a1 sigma_a1 = 0.14 global sigma_b1 sigma_b1 = 1.16 global sigma_c1 sigma_c1 = 2.87 mu_x01 = -11 sigma_x01 = 1.9 #####_____##### #####generating random data##### a1 = 0.75*mu_a1 + (1.25 - 0.75)*sigma_a1*np.random.sample(10000) b1 = 8*mu_b1 + (12 - 8)*sigma_b1*np.random.sample(10000) c1 = -12*mu_c1 + 2*sigma_c1*np.random.sample(10000)
Read more