python如何输入多行数据合并_Python3 Pandas - 如何将多行合并为一行

Python版本：3.6

熊猫版本：0.21.1

我如何从获得

print（df_raw）

device_id temp_a temp_b temp_c

0 0 0.2 0.8 0.6

1 0 0.1 0.9 0.4

2 1 0.3 0.7 0.2

3 2 0.5 0.5 0.1

4 2 0.1 0.9 0.4

5 2 0.7 0.3 0.9

到

print（df_except2）

device_id temp_a temp_b temp_c temp_a_1 temp_b_1 temp_c_1 temp_a_2 \

0 0 0.2 0.8 0.6 0.1 0.9 0.4 NaN

1 1 0.3 0.7 0.2 NaN NaN NaN NaN

2 2 0.5 0.5 0.1 0.1 0.9 0.4 0.7

temp_b_2 temp_c_2

0 NaN NaN

1 NaN NaN

2 0.3 0.9

数据代码：

df_raw = pd.DataFrame({'device_id' : ['0','0','1','2','2','2'],

'temp_a' : [0.2,0.1,0.3,0.5,0.1,0.7],

'temp_b' : [0.8,0.9,0.7,0.5,0.9,0.3],

'temp_c' : [0.6,0.4,0.2,0.1,0.4,0.9],

})

print(df_raw)

df_except = pd.DataFrame({'device_id' : ['0','1','2'],

'temp_a':[0.2,0.3,0.5],

'temp_b':[0.8,0.7,0.5],

'temp_c':[0.6,0.2,0.1],

'temp_a_1':[0.1,None,0.1],

'temp_b_1':[0.9,None,0.9],

'temp_c_1':[0.4,None,0.4],

'temp_a_2':[None,None,0.7],

'temp_b_2':[None,None,0.3],

'temp_c_2':[None,None,0.9],

})

df_except2 = df_except[['device_id','temp_a','temp_b','temp_c','temp_a_1','temp_b_1','temp_c_1','temp_a_2','temp_b_2','temp_c_2']]

print(df_except2)