我無法以正確的格式將數(shù)據(jù)加載到數(shù)據(jù)幀中。我正在處理的數(shù)據(jù)具有以下形式：Sensor Name,Variable,Units,Timestamp,Value,Flagged as Suspect ReadingPER_EMOTE_2202,CO,ugm -3,2019-02-15 15:46:16,476.634102929914,FalsePER_EMOTE_2202,Humidity,%,2019-02-15 15:46:16,49.8,FalsePER_EMOTE_2202,NO,ugm -3,2019-02-15 15:46:16,68.5581902781,FalsePER_EMOTE_2202,NO2,ugm -3,2019-02-15 15:46:16,80.220623065752,FalsePER_EMOTE_2202,Sound,db,2019-02-15 15:46:16,69.0,FalsePER_EMOTE_2202,Temperature,Celsius,2019-02-15 15:46:16,13.2,FalsePER_EMOTE_2202,CO,ugm -3,2019-02-15 15:47:16,475.363796635848,FalsePER_EMOTE_2202,NO,ugm -3,2019-02-15 15:47:16,84.7920567981415,FalsePER_EMOTE_2202,NO2,ugm -3,2019-02-15 15:47:16,82.3021250062142,FalsePER_EMOTE_2202,Sound,db,2019-02-15 15:47:16,69.0,False我想將它加載到代表每個(gè)變量值的列中，按時(shí)間戳索引。例如; 所需格式到目前為止，我有以下幾點(diǎn)：def load_data(path): df = pd.read_csv(path, usecols=['Timestamp', 'Variable', 'Units', 'Value']) df = df.set_index('Timestamp') return df這產(chǎn)生了結(jié)果；結(jié)果
1 回答
江戶川亂折騰
TA貢獻(xiàn)1851條經(jīng)驗(yàn) 獲得超5個(gè)贊
嘗試使用數(shù)據(jù)透視表。
def load_data(path):
df = pd.read_csv(path, usecols=['Timestamp', 'Variable', 'Units', 'Value'])
df = df.pivot_table(index='Timestamp', columns='Variable', values='Value')
return df
添加回答
舉報(bào)
0/150
提交
取消