我無法以正確的格式將數(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é)果
Python Pandas 將數(shù)據(jù)移動(dòng)到新行
桃花長(zhǎng)相依
2021-11-16 16:55:31