data1 data2 key1 key2
0 1 2 a one
1 3 4 a two
2 5 6 b one
3 7 8 b two
4 9 10 a one
key1
a 3
b 2
dtype: int64
++++++++++++++
key1
a 4.333333
b 6.000000
Name: data1, dtype: float64
<class 'pandas.core.series.Series'>
++++++++++++++++++
data1 data2 key1 key2 add
0 1 2 a one AA
1 3 4 a two BB
2 5 6 b one CC
3 7 8 b two DD
4 9 10 a one EE
key1 key2
a one 2
two 1
b one 1
two 1
dtype: int64
<class 'pandas.core.series.Series'>
++++++++++++++++++
key1 add
a AA 1.0
BB 3.0
EE 9.0
b CC 5.0
DD 7.0
Name: data1, dtype: float64
<class 'pandas.core.series.Series'>