"""
id   value
1      A
1      B
1      C
2      D
2      E
2      F
變?yōu)椋?
id  value
1   [A,B,C]
2   [D,E,F]

pandas怎么把上面的結(jié)構(gòu)變?yōu)橄旅娴男问剑?
"""

import pandas as pd
import numpy as np
data = pd.DataFrame({'id':[1,1,1,2,2,2],'value':['A','B','C','D','E','F']})

data1 = np.array(data.groupby(['id']))#按照id進(jìn)行分類
# 轉(zhuǎn)變成array對象之后，可以根據(jù)data1[0][1]查看其結(jié)構(gòu)

id_kinds = 2#id的種類，此例比如1、2共兩種
all_value = []
for j in range(2):
    value = []
    for i in data1[j][1]['value']:
        value.append(i)
    all_value.append(value)
print(all_value)

#再創(chuàng)建新的dataframe
new_data = pd.DataFrame({'id':[1,2],'value':all_value})
print(new_data)

import pandas as pd
import numpy as np
data = pd.DataFrame({'id':[1,1,1,2,2,2],'value':['A','B','C','D','E','F']})
data1 = data.groupby(by='id')['value'].sum()

data = pd.DataFrame({'id':[1,1,1,2,2,2],'value':['A','B','C','D','E','F']})
data['value'] = data['value'].apply(lambda x:','+ x)

data1 = data.groupby(by='id').sum()

data1['value'] = data1['value'].apply(lambda x :[x[1:]])

data1 = data.groupby(by='id').apply(lambda x:[','.join(x['value'])])

for ID，group in group_df:
? ? print(ID)
? ? print(group)

a = ['a','b']
c = pd.Series(a).sum()

data['value'].apply(lambda x :*****)
data.groupby(by='**').apply(lambda x :*****)