我有一个大数据帧,比如:
product price serial category department origin
0 cookies 4 2345 breakfast food V
1 paper 0.5 4556 stationery work V
2 spoon 2 9843 kitchen household M
我想转换为dict,但我只想要一个输出,比如:
{serial: 2345}{serial: 4556}{serial: 9843} and {origin: V}{origin: V}{origin: M}
其中key是列名,value是值
现在,我尝试了df.to_dict('values'(,我选择了dic['origin']并返回
{0: V}{1:V}{2:M}
我也试过使用df.to_dict("记录"(,但它给了我:
{product: cookies, price: 4, serial:2345, category: breakfast, department:food, origin:V}
我不知道如何只选择"原点"或"串行">
您可以执行以下操作:
serial_dict = df[['serial']].to_dict('r')
origin_dict = df[['origin']].to_dict('r')