python - Python：当我们在特定列中有重复项时合并行

Question

假设我有这个数据框：

Name = ['ID', 'Country', 'IBAN','Dan_Age', 'Dan_city', 'Dan_country', 'Dan_info', 'Dan_info','Sara_Age', 'Sara_country','Sara_info' ,'Sara_info','Sara_info','Dan_info' ]
Value = ['TAMARA_CO', 'GERMANY','FR56','18', 'Berlin', 'GER', 'Tall', 'Brown Hair', '22', 'FRA', 'Small','Blue eyes', 'Brown Hair', 'Tall']
Ccy = ['','','','EUR','EUR','USD','USD','USD','CHF', '','DKN','DKN','DKN','HKN']
Group = ['0','0','0','1','1','1','1','1','3','3','3','3','3','4']
df = pd.DataFrame({'Name':Name, 'Value' : Value, 'Ccy' : Ccy,'Group':Group})

print(df)

            Name       Value  Ccy Group
0             ID   TAMARA_CO          0
1        Country     GERMANY          0
2           IBAN        FR56          0
3        Dan_Age          18  EUR     1
4       Dan_city      Berlin  EUR     1
5    Dan_country         GER  USD     1
6       Dan_info        Tall  USD     1
7       Dan_info  Brown Hair  USD     1
8       Sara_Age          22  CHF     3
9   Sara_country         FRA          3
10     Sara_info       Small  DKN     3
11     Sara_info   Blue eyes  DKN     3
12     Sara_info  Brown Hair  DKN     3
13      Dan_info        Tall  HKN     4

当我们在“名称”列中有几个相同的数据彼此跟随（并且仅当它们跟随时）时，我想合并“值”列中的数据。如果是这种情况，则“Ccy”和“Group”列中的值相同。

所以最后我想得到：

            Name                         Value  Ccy Group
0             ID                     TAMARA_CO          0
1        Country                       GERMANY          0
2           IBAN                          FR56          0
3        Dan_Age                            18  EUR     1
4       Dan_city                        Berlin  EUR     1
5    Dan_country                           GER  USD     1
6       Dan_info              Tall, Brown Hair  USD     1
7       Sara_Age                            22  CHF     3
8   Sara_country                           FRA          3
9      Sara_info  Small, Blue eyes, Brown Hair  DKN     3
10      Dan_info                          Tall  HKN     4

任何人都有一个有效的想法？

标签： pythonpandasnumpydataframemerge