Pandas to Dictionary

A dictionary is a way of storing information in Python. It has keys and values that are related to each other. Sometimes in Python, we may want to convert Pandas DataFrame into a different format, such as a dictionary. The “DataFrame.to_dict()” method converts the DataFrame to a Dictionary in Python.

This tutorial will give you a detailed guide on converting Pandas to Dictionaries using numerous examples.

How to Convert Pandas DataFrame to Python Dictionary?

To convert/transform a particular Pandas DataFrame to Dictionary, the “DataFrame.to_dict()” method is used in Python. The “DataFrame.to_dict()” syntax is shown below:

DataFrame.to_dict(orient='dict', into=<class 'dict'>, index=True)

Here in the above syntax:

  • The “orient” parameter specifies the type of value of the dictionary. It can be one of the following strings: “dict”, “list”, “series”, “split”, “tight”, “records”, or “index”.
  • The “into” parameter specifies the “” subclass utilized for all mappings in the retrieved value. (Default is “dict”).
  • The “index” parameter determines whether to add the index element to the returned dictionary.

The “DataFrame.to_dict()” method will return a dictionary with the column names as keys and the column values as sub-dictionaries with the index labels as keys.

Example 1: Convert Pandas DataFrame to Dictionary

This example uses the “df.to_dict()” method to convert Pandas DataFrame to Dictionary in Python:

import pandas

dict1 = {'name': ['Joseph', 'Anna', 'Lily'], 'id': [12, 22, 33], 'salary': ['$334', '$348', '$583']}

df = pandas.DataFrame(dict1)

print('DataFrame:\n', df)

print('\nDictionary Value:\n', df.to_dict())

In the above code:

  • The “pandas” module is imported.
  • The “pd.DataFrame()” creates the DataFrame by accepting the dictionary Data as an argument.
  • The “df.to_dict()” method converts the Pandas DataFrame to Dictionary.


The dictionary has been created from the Pandas DataFrame.

Example 2: Convert Pandas DataFrame to Dictionary Using “orient” Parameter

This example code is used to convert DataFrame to Dictionary using the specified “orient” parameter value such as list or split:

import pandas

dict1 = {'name': ['Joseph', 'Anna', 'Lily'], 'id': [12, 22, 33], 'salary': ['$334', '$348', '$583']}

df = pandas.DataFrame(dict1)

print('DataFrame:\n', df)

print('\nDictionary Value:\n', df.to_dict(orient='list'))

In the above code, the “orient” parameter value “list” is passed to the “df.to_dict()” method to convert the Pandas DataFrame to the dictionary in the “list” orientation structure.


The dictionary has been returned in the “list” orientation.


In Python, the “DataFrame.to_dict()” method of the “pandas” module is used to convert the specified Pandas DataFrame to Dictionary. The “DataFrame.to_dict()” method takes the “orient” parameter as an argument and returns the DataFrame in a specified orientation such as “list”, “split”, etc. This article presented/delivered an extensive guide on Pandas to Dictionaries utilizing numerous examples.

About the author

Haroon Javed

Hi, I'm Haroon. I am an electronics engineer and a technical content writer. I am a tech geek who loves to help people to the best of my knowledge.