我將如何使用 Pandas 組織 csv 檔案，以便它組織從最舊到最新日期的行。中的日期值data.csv是無組織的，我可以實作哪些代碼，以便獲得下面的預期輸出？
代碼：
data = pd.read_csv('data.csv')
dates= pd.to_datetime(data['Date'].to_list())
data.csv 檔案內容：
Unix Timestamp,Date,Symbol,Open,High,Low,Close,Volume
1635686100,2021-10-31 13:15:00,BTCUSD,60620.0,60633.0,60565.0,60568.0,1.3977284440628714
1635686220,2021-10-31 13:17:00,BTCUSD,60638.0,60640.0,60636.0,60638.0,0.4357009185659157
1635686160,2021-10-31 13:16:00,BTCUSD,60568.0,60640.0,60568.0,60638.0,3.9771881707839967
預期輸出：
Unix Timestamp,Date,Symbol,Open,High,Low,Close,Volume
1635686220,2021-10-31 13:17:00,BTCUSD,60638.0,60640.0,60636.0,60638.0,0.4357009185659157
1635686160,2021-10-31 13:16:00,BTCUSD,60568.0,60640.0,60568.0,60638.0,3.9771881707839967
1635686100,2021-10-31 13:15:00,BTCUSD,60620.0,60633.0,60565.0,60568.0,1.3977284440628714
uj5u.com熱心網友回復：
首先將列轉換Date為datetimes按引數parse_dates，然后使用DataFrame.sort_values：
data = pd.read_csv('data.csv', parse_dates=['Date'])
data = data.sort_values('Date', ascending=False, ignore_index=True)
print (data)
Unix Timestamp Date Symbol Open High Low \
0 1635686220 2021-10-31 13:17:00 BTCUSD 60638.0 60640.0 60636.0
1 1635686160 2021-10-31 13:16:00 BTCUSD 60568.0 60640.0 60568.0
2 1635686100 2021-10-31 13:15:00 BTCUSD 60620.0 60633.0 60565.0
Close Volume
0 60638.0 0.435701
1 60638.0 3.977188
2 60568.0 1.397728
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/355486.html