我有以下資料框
Firm Item Cost
0 Firm A Books 0.55
1 Firm A Pencils 0.60
2 Firm B Books 0.45
3 Firm B Pencils 0.35
我想把它轉換成下面的字典
{('Firm A', 'Books'): 0.55, ('Firm A', 'Pencils'): 0.6, ('Firm B', 'Books'): 0.45, ('Firm B', 'Pencils'): 0.35}
我試過
costs_dictionary = df.set_index('Firm','Item').to_dict()
但沒有成功。
uj5u.com熱心網友回復：
添加串列DataFrame.set_index并選擇Cost之前的列to_dict：
costs_dictionary = df.set_index(['Firm','Item'])['Cost'].to_dict()
print (costs_dictionary)
{('Firm A', 'Books'): 0.55, ('Firm A', 'Pencils'): 0.6,
('Firm B', 'Books'): 0.45, ('Firm B', 'Pencils'): 0.35}
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/365742.html