大 pandas 数据框到一些列的字典 [英] Big pandas dataframe to dict of some columns

问题描述

我有一个像这样的大数据框:

I have a big dataframe like:

       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

我想转换为字典，但是我只想要一个输出:

I want to convert to dict, but I just want an output like:

   {serial: 2345}{serial: 4556}{serial: 9843} and {origin: V}{origin: V}{origin: M}

其中键是列名，值是值

现在，我尝试使用df.to_dict('values')并选择dic ['origin']并返回我

Now, i've tried with df.to_dict('values') and I selected dic['origin'] and returns me

   {0: V}{1:V}{2:M}

我也尝试过df.to_dict('records')，但它给了我:

I've tried too with df.to_dict('records') but it give me:

   {product: cookies, price: 4, serial:2345, category: breakfast, department:food, origin:V}

而且我不知道如何仅选择来源"或序列"

and I don't know how to select only 'origin' or 'serial'

推荐答案

您可以执行以下操作:

serial_dict = df[['serial']].to_dict('r')
origin_dict = df[['origin']].to_dict('r')

这篇关于大 pandas 数据框到一些列的字典的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！