Convert Python dict of Arrays into a dataframe

Question

I have a dictionary of arrays like the following:

d = {'a': [1,2], 'b': [3,4], 'c': [5,6]}

I want to create a pandas dataframe like this:

   0      1      2
0  a      1      2
1  b      3      4
2  c      5      6

I wrote the following code:

pd.DataFrame(list(d.items()))

which returns:

   0    1      
0  a  [1,2]      
1  b  [3,4]      
2  c  [5,6]    

Do you know how can I achieve my goal?!

Thank you in advance.

Answer 1

Pandas allows you to do this in a straightforward fashion:

pd.DataFrame.from_dict(d,orient = 'index')
>>      0   1
    a   1   2
    b   3   4
    c   5   6

pd.DataFrame.from_dict(d,orient = 'index').reset_index() gives you what you are looking for.