python字典保存为excel,在python中将简单的Dictionary转换为Excel文件

I am new to python.

I have a simple dictionary for which the key and values are as follows

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

i need to get them in a excel sheet as follows

number of storage arrays 45

number of ports 2390

I have a very big dictionary.

解决方案

Sassikant,

This will open a file named output.csv and output the contents of your dictionary into a spreadsheet. The first column will have the key, the second the value.

import csv

with open('output.csv', 'wb') as output:

writer = csv.writer(output)

for key, value in dict1.iteritems():

writer.writerow([key, value])

You can open the csv with excel and save it to any format you'd like.