pandas 将两个相关的 Dataframe 合并为一个

vulvrdjw 于 2022-11-20 发布在其他

关注(0)|答案(2)|浏览(184)

如何创建一个新的DF，使每个教师都包含一个学生列表

教师df

name  married                  school
0    Pep Guardiola     True  Manchester High School
1     Jurgen Klopp     True   Liverpool High School
2     Mikel Arteta    False            Arsenal High
3  Zinadine Zidane     True                     NaN

学生df

teacher                name  age height weight
0   Mikel Arteta         Bukayo Saka   21   2.1m   80kg
1   Mikel Arteta  Gabriel Martinelli   21   2.1m   75kg
2  Pep Guardiola       Jack Grealish   27   2.1m   80kg
3   Jurgen Klopp     Roberto Firmino   31   2.1m   65kg
4   Jurgen Klopp    Andrew Robertson   28   2.1m   70kg
5   Jurgen Klopp        Darwin Nunez   23   2.1m   75kg
6  Pep Guardiola      Ederson Moraes   29   2.1m   90kg
7  Pep Guardiola       Manuel Akanji   27   2.1m   80kg
8   Mikel Arteta       Thomas Partey   29   2.1m   80kg

pandas

来源：https://stackoverflow.com/questions/74443285/merge-two-related-dataframe-to-one

2条答案

按热度按时间

8ehkhllq1#

如果需要由学生列表填充新列，则使用Series.map与list的合计：

df1['students'] = df1['name'].map(df2.groupby('teacher')['name'].agg(list))

赞(0）回复(0）举报 2022-11-20

nkkqxpd92#

您可以考虑使用：

df.merge(df.groupby('teacher',as_index=False).agg({'name':list}),
                                   how='left',
                                   on='teacher',
                                   suffixes=('','_list'))

重新调谐：

teacher        name  age height weight                    name_list
0   Mikel Arteta        Saka   21   2.1m   80kg   [Saka, Martinelli, Partey]
1   Mikel Arteta  Martinelli   21   2.1m   75kg   [Saka, Martinelli, Partey]
2  Pep Guardiola    Grealish   27   2.1m   80kg   [Grealish, Moraes, Akanji]
3   Jurgen Klopp     Firmino   31   2.1m   65kg  [Firmino, Robertson, Nunez]
4   Jurgen Klopp   Robertson   28   2.1m   70kg  [Firmino, Robertson, Nunez]
5   Jurgen Klopp       Nunez   23   2.1m   75kg  [Firmino, Robertson, Nunez]
6  Pep Guardiola      Moraes   29   2.1m   90kg   [Grealish, Moraes, Akanji]
7  Pep Guardiola      Akanji   27   2.1m   80kg   [Grealish, Moraes, Akanji]
8   Mikel Arteta      Partey   29   2.1m   80kg   [Saka, Martinelli, Partey]

赞(0）回复(0）举报 2022-11-20

我来回答

pandas 将两个相关的 Dataframe 合并为一个

2条答案

相关问题

热门标签

最新问答