擅长:python、mysql、java
<p>您应该首先从字典中构建一个键、值元组列表,然后使用pandas将其转换为excel</p>
<pre><code>d = {1: [0, 120, 115, 100, 91, 131, 74, 14, 8, 105, 122, 47, 103, 0], 2: [0, 107, 25, 26, 121, 118] }
data = [(i, j) for i in d.keys() for j in d[i]]
# Export to excel format
df = pd.DataFrame(data, columns=["A", "B"])
df.to_excel("table.xlsx")
</code></pre>