Converting a dictionary to a dataframe in python

Question

I have this dictionary record randomly generated looking like this (could have potentially more record)

{'Device_ID': 4, 'Temp1': 58.685912388818124, 'Temp2': 74.55450362769994, 'Temp3': 29.342956194409062, 'Temp_Ambient': 22.89076035200238, 'Time': 19}
{'Device_ID': 6, 'Temp1': 48.75315131444877, 'Temp2': 63.62846644589365, 'Temp3': 24.376575657224386, 'Temp_Ambient': 22.540969718435385, 'Time': 15}

I would like the keys: Device ID, Temp1, Temp2, Temp3, Time, Temp_Ambient to be columns of the dataframe

when i try:

df = pd.DataFrame([record], columns=record.keys())

it only shows one row of data.

U13-Forward · Accepted Answer · 2019-07-25 08:20:43Z

3

Assuming it's a list of dicts:

lod = [{'Device_ID': 4, 'Temp1': 58.685912388818124, 'Temp2': 74.55450362769994, 'Temp3': 29.342956194409062, 'Temp_Ambient': 22.89076035200238, 'Time': 19},
{'Device_ID': 6, 'Temp1': 48.75315131444877, 'Temp2': 63.62846644589365, 'Temp3': 24.376575657224386, 'Temp_Ambient': 22.540969718435385, 'Time': 15}]
df = pd.DataFrame(lod)
print(df)

Output:

   Device_ID      Temp1      Temp2      Temp3  Temp_Ambient  Time
0          4  58.685912  74.554504  29.342956      22.89076    19
1          6  48.753151  63.628466  24.376576      22.54097    15

answered Jul 25, 2019 at 8:20

U13-Forward

71.8k15 gold badges100 silver badges125 bronze badges

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

Collectives™ on Stack Overflow

Converting a dictionary to a dataframe in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related