pandas怎么根据多列的值将多行 合并成一行？
我需要将多个行组合成一行，原始数据格式如下所示：
RegisterID | IndividualID | DayID | TripID | JourSequence | NoteID | TripPurpose |
|---|---|---|---|---|---|---|
408257 | 200100000001 | one | apple | one | orange | aaa |
408257 | 200100000001 | one | apple | two | orange | bbb |
408257 | 200100000001 | one | apple | three | orange | abc |
408257 | 200100000001 | one | apple | four | orange | ccc |
408257 | 200100000001 | one | apple | five | orange | bcd |
408257 | 200100000001 | one | apple | six | orange | eaf |
408359 | 200100000009 | two | apple | one | orange | dfc |
408359 | 200100000009 | two | apple | two | orange | www |
408359 | 200100000009 | two | apple | three | orange | xxx |
408359 | 200100000009 | two | apple | four | orange | yyy |
408359 | 200100000009 | two | apple | five | orange | zzz |
408359 | 200100000009 | two | apple | six | orange | xyz |
我试图将表转换为如下所示：
RegisterID | IndividualID | DayID | TripID | one | two | three | four | five | six |
|---|---|---|---|---|---|---|---|---|---|
408257 | 200100000001 | one | apple | aaa | bbb | abc | ccc | bcd | eaf |
408359 | 200100000009 | two | apple | dfc | www | xxx | yyy | zzz | xyz |
请问解决方案是什么？我试过pivot，但是老是报错。
回答
和开发者交流更多问题细节吧，去 写回答
相关文章
相似问题
相关问答用户
请输入您想邀请的人