How can I turn rows that have the same id to one longer row? Im not exactly looking to pivot in this scenario

Asked Jul 11 '19 at 18:51

Active Jul 11 '19 at 20:07

Viewed 19 times

for example my dataframe looks like this below

id    |   answer      |     reason
1     |    yes        |      possible fraud
1     |    maybe      |      scam
2     |    no         |      no evidence

how can I turn it into something like this below?

id    |    answer_1  |     reason_1     | answer_2    |reason_2
1     |    yes       | possible fraud   |   maybe     | possible fraud
2     |    no        |    no_evidence   |             |

edited Jul 11 '19 at 20:07

asked Jul 11 '19 at 18:51

Drew Pham

Check with the Q10 in the link – BENY Jul 11 '19 at 18:53
Not quite sure I understand your edit. This **is** a pivot, so why are you trying to avoid that? – ALollz Jul 11 '19 at 20:20
Should `reason_2` be 'scam' in your expected output? – ALollz Jul 11 '19 at 20:20
How can I get the column names to enumerate properly when I pivot and yes reason_2 should be scam – Drew Pham Jul 11 '19 at 21:00

How can I turn rows that have the same id to one longer row? Im not exactly looking to pivot in this scenario

0 Answers0