Create a dataframe from dictionary - python

Question

Say, I have a dictionary of form:

dct = {'A': [1,2,3], 'B': [4,5,6,7]}

How can it be transformed into pandas dataframe such the result will be of the form:

Column1  Column2
A        1
A        2
A        3
B        4
B        5
B        6
B        7

yes @AnandSKumar , apparently i don't know how to create a table, sorry for that — bninopaul
– bninopaul, Commented Jul 10, 2015 at 10:21

peterfields · Accepted Answer · 2015-07-10 10:47:31Z

1

You can use DataFrame.from_dict to import the data:

In [1059]: dct = {'A': [1,2,3], 'B': [4,5,6]}

In [1060]: df = pnd.DataFrame.from_dict(dct)

In [1061]: df
Out[1061]: 
   A  B
0  1  4
1  2  5
2  3  6

And then simply use pandas' very handymelt function to unpivot the dataframe:

In [1062]: pnd.melt(df)
Out[1062]: 
 variable  value
0        A      1
1        A      2
2        A      3
3        B      4
4        B      5
5        B      6

answered Jul 10, 2015 at 10:47

peterfields

3161 silver badge5 bronze badges

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

Comments

zero323 · Accepted Answer · 2015-07-10 13:08:57Z

0

from itertools import chain
pd.DataFrame(list(chain.from_iterable(
    ((k, v) for v in vals) for (k, vals) in dct.items())),
    columns=('Column1', 'Column2'))

edited Jul 10, 2015 at 13:08

answered Jul 10, 2015 at 10:30

zero323

331k108 gold badges981 silver badges958 bronze badges

2 Comments

bninopaul Over a year ago

thanks, the code works, it is more general, I forgot that every value in dictionary have different lengths.

zero323 Over a year ago

I suspected it may be the case and I am glad it works for you.

Collectives™ on Stack Overflow

Create a dataframe from dictionary - python

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related