I am working on a dataset, which includes data both from the current year and from the previous year. The following is an example: I currently have a dataset like this: # CY_1 CY_2 CY_3 PY_1 PY_2 PY_3 1 c e g a b e 2 b c f a d g 3 b d e c d e 4 a c d a b e I want to find out how many variables in CY_1, CY_2, and CY_3 equals valuables in PY_1, PY_2, and PY_3. I hope to get the following output. # CY_1 CY_2 CY_3 PY_1 PY_2 PY_3 output 1 c e g a b e 1 2 b c f a d g 0 3 b d e c d e 2 4 a c d a b e 1 Thank you!
... View more