Pandas 多行并一行

def merge_rows_in_pandas():

    data = [{'name': 'jalen', 'age': 12, 'love': 'basketball'},

            {'name': 'jalen', 'age': 12, 'love': 'football'},

            {'name': 'kitty', 'age': 20, 'love': 'movies'},

            {'name': 'kitty', 'age': 20, 'love': 'singing'}]

    df = pd.DataFrame(data)

    df['love'] = df.groupby(['name', 'age'], as_index=False)['love'].transform(lambda x: ','.join(x))

    df.drop_duplicates(subset=['name', 'age'], keep='first', inplace=True)

if __name__ == '__main__':

    merge_rows_in_pandas()

    print('end!')