Categories
Python Answers

How to convert a Python dict into a Pandas DataFrame?

Spread the love

Sometimes, we want to convert a Python dict into a Pandas DataFrame.

In this article, we’ll look at how to convert a Python dict into a Pandas DataFrame.

How to convert a Python dict into a Pandas DataFrame?

To convert a Python dict into a Pandas DataFrame, we can use the DataFrame constructor with an iterator with the tuples of the key-value pairs.

For instance, we write:

import pandas as pd

d = {
    u'2012-06-08': 388,
    u'2012-06-09': 388,
    u'2012-06-10': 388,
    u'2012-06-11': 389,
    u'2012-06-12': 389,
    u'2012-06-13': 389
}
df = pd.DataFrame(d.items())
print(df)

to convert the d dictionary to a DataFrame.

We call d.items to return the iterator with the tuples of the key-value pairs and use that as the argument of DataFrame.

And then we assign the returned DataFrame to df.

Therefore, we get:

            0    1
0  2012-06-08  388
1  2012-06-09  388
2  2012-06-10  388
3  2012-06-11  389
4  2012-06-12  389
5  2012-06-13  389

as the value of df.

Conclusion

To convert a Python dict into a Pandas DataFrame, we can use the DataFrame constructor with an iterator with the tuples of the key-value pairs.

Leave a Reply

Your email address will not be published. Required fields are marked *