python - Convert dictionaries to dataframe

Question

I am trying to convert this dictionary:

data = ({"Jan 2018":1000},{"Feb 2018":1100},{"Mar 2018":1400},{"Apr 2018":700},{"May 2018":800})
data

to dataframe like:

date       balance
Jan 2018   1000
Feb 2018   1100
Mar 2018   1400
Apr 2018   700
May 2018   800

I used the dataframe to convert, but it didn't give the format as above, how can i do it? Thank you!

pd.DataFrame.from_dict(data_c, orient='columns')

Answer 1

Here is my solution:

import pandas as pd

data = ({"Jan 2018":1000},{"Feb 2018":1100},{"Mar 2018":1400},{"Apr 2018":700},{"May 2018":800})

arr = [list(*d.items()) for d in data]

df = pd.DataFrame(arr, columns=['data', 'balance'])

you need get proper array from the tuple of dictionary before pass it to DataFrame.