How to convert dictionary with multiple values into a pandas dataframe?

Question

I would like to convert a python dict to a pandas dataframe. The number of columns should be equal to number of values for a particular key. From the example below, column names should be i, a, b, c, and d where i is dictionary key and rest are values:

e = {}
for i in range(0,len(length_of_the_row)):
    e[i] = a,b,c,d

saladi · Accepted Answer · 2016-02-02 05:15:36Z

2

Try .from_dict():

import pandas as pd
e = {}
for i in range(0, len("length_of_the_row")):
    e[i] = "a", "b", "c", "d"

df = pd.DataFrame.from_dict(e, orient='index')

edited Feb 2, 2016 at 5:15

saladi

3,2936 gold badges39 silver badges65 bronze badges

answered Feb 2, 2016 at 0:46

DarkFranX

5614 silver badges23 bronze badges

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

Comments

saladi · Accepted Answer · 2016-02-02 05:31:38Z

1

Turn the dictionary directly into a dataframe and then transpose it since the rows and columns need to be swapped:

import pandas as pd
e_df = pd.DataFrame(e) 
e_df = e_df.T

edited Feb 2, 2016 at 5:31

saladi

3,2936 gold badges39 silver badges65 bronze badges

answered Feb 2, 2016 at 0:53

firstly

711 silver badge7 bronze badges

Collectives™ on Stack Overflow

How to convert dictionary with multiple values into a pandas dataframe?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related