我有一个pandas DataFrame df:
+------+---------+
| team | user |
+------+---------+
| A | elmer |
| A | daffy |
| A | bugs |
| B | dawg |
| A | foghorn |
| B | speedy |
| A | goofy |
| A | marvin |
| B | pepe |
| C | petunia |
| C | porky |
+------+---------
我想找到或编写一个函数来返回我将在MySQL中使用以下命令返回的DataFrame:
SELECT
team,
GROUP_CONCAT(user)
FROM
df
GROUP BY
team
为了以下结果:
+------+---------------------------------------+
| team | group_concat(user) |
+------+---------------------------------------+
| A | elmer,daffy,bugs,foghorn,goofy,marvin |
| B | dawg,speedy,pepe |
| C | petunia,porky |
+------+---------------------------------------+
通过迭代行并添加到字典,我可以想到通过讨厌的方式来实现这一点,但必须有更好的方法.