擅长:python、mysql、java
<p>您可以使用<code>pandas</code>创建包含两列(“键”和“值”)的数据框,并将其保存到excel文件中</p>
<pre><code>import pandas as pd
dct = {1: [0, 120, 115, 100, 91, 131, 74, 14, 8, 105, 122, 47, 103, 0],
2: [0, 107, 25, 26, 121, 118]}
# define the second column name as "values"
df = pd.DataFrame({'values': dct}).reset_index()
# rename the first colum, here "keys"
df.rename(columns={"index": "keys"}, inplace = True)
# save dataframe to excel file
df.to_excel("output.xlsx")
</code></pre>