Export a simple Dictionary into Excel file in python

Question

Python is new to me. I have a straightforward dictionary with the following key and values.

dict1 = {"number of storage arrays": 45, "number of ports":2390,......}

I need to get them in an excel sheet as follows:

number of storage arrays 45
number of ports          2390

I have a very big dictionary.

Answer 1

You can use pandas.

import pandas as pd

dict1 = {"number of storage arrays": 45, "number of ports":2390}

df = pd.DataFrame(data=dict1, index=[0])

df = (df.T)

print (df)

df.to_excel('dict1.xlsx')