我有多個DataFrames存盤在dictionary我嘗試改變的型別Dates從列object到datetime所有DataFrames的dictionary在同一時間。
這將是一個帶有兩個DataFrames df1&的示例df2。
import pandas as pd
df1 = pd.DataFrame({
'Dates':['2021-01-01', '2021-01-03', '2021-01-04', '2021-01-05', '2021-01-06'],
'ID1':[0,0,0.1,0.2,0.1],
'ID2':[0,0,0.1,0.2,0.1],
'ID3':[0.1,0,0,0.2,0.4],
'ID4':[0,0,0.1,0.2,0.1],
'ID6':[0,0,0.1,0.2,0.1]})
df2 = pd.DataFrame({
'Dates':['2021-01-01', '2021-01-02', '2021-01-03', '2021-01-04', '2021-01-05'],
'ID2':[3,6,3,-1,3],
'ID4':[1,2.4,-2,1,4],
'ID5':[4,3,3,-3,4],
'ID6':[2,1.5,2,-2,3]})
dfs = dict()
dfs['df1'] = df1
dfs['df2'] = df2
我試圖找出一種轉換列的方法；Dates同時dictionary為所有的日期時間格式DataFrames。到目前為止，我只能在將它們放在一起之前單獨轉換它們dictionary：df1['Dates'] = pd.to_datetime(df1['Dates'])
非常感謝！
uj5u.com熱心網友回復：
使用字典理解DataFrame.assign：
dfs = {k:v.assign(Dates = pd.to_datetime(v['Dates'])) for k, v in dfs.items()}
編輯：
dfs = {k:v.assign(Dates = pd.to_datetime(v['Dates'])).sort_values('Dates', ignore_index=True)
for k, v in dfs.items()}
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/386402.html
上一篇：如何將陣列轉換為物件