我有一個帶有日期、代碼和關閉的資料框有些行有相同的日期
key= date value= ticker value close
import pandas as pd
data = {'Ticker': ['laptop', 'printer', 'tablet', 'desk', 'chair'],
'close': [1200, 150, 300, 450, 200]
}
df = pd.DataFrame(data, index=
['27/01/2022','27/01/2022','25/01/2022','24/01/2022','23/01/2022'])
df
Ticker close
27/01/2022 laptop 1200
27/01/2022 printer 150
25/01/2022 tablet 300
24/01/2022 desk 450
23/01/2022 chair 200
我正在嘗試獲取一個看起來像這樣的字典
Key
27/01/2022 laptop : 1200, printer : 150
25/01/2022 tablet : 300
24/01/2022 desk 450
23/01/2022 chair 200
uj5u.com熱心網友回復：
正如 baileythegreen 在評論中所暗示的那樣，您的示例輸出不是有效的字典。如果你想要輸出
{'23/01/2022': {'chair': 200},
'24/01/2022': {'desk': 450},
'25/01/2022': {'tablet': 300},
'27/01/2022': {'laptop': 1200, 'printer': 150}}
你可以做
{date: dict(zip(sub_df['Ticker'], sub_df['close']))
for date, sub_df in df.groupby(df.index)}
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/455933.html