Converting a pandas dataframe into python dictionary

Question

I am trying to convert a dataframe into dictionary which has columns in the following order

df.columns = Index([u'Symbol', u'Name', u'MarketCap', u'IPOyear', u'Sector', u'Industry'], dtype='object')

when I converted by using

df.to_dict(orient = 'list')

I got a dictionary with the keys in following order

dict1.keys() = ['Sector', 'Name', 'Symbol', 'MarketCap', 'IPOyear', 'Industry']

I want the order to be unchanged. anyone please help me with this?

But I have a need of loading that dictionary into MySQLdb table. — Bhargav
– Bhargav, Commented Jan 10, 2017 at 1:53
Do you need to iterated over your dict to load it to MySQLdb table? — Akavall
– Akavall, Commented Jan 10, 2017 at 2:01

akuiper · Accepted Answer · 2017-01-10 02:00:14Z

1

You can use an OrderedDict, which can remember the order that keys were first inserted:

from collections import OrderedDict
myDict = OrderedDict()

for col in df.columns:
    myDict[col] = df[col].tolist()

answered Jan 10, 2017 at 1:54

akuiper

216k33 gold badges362 silver badges379 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1