擅长:python、mysql、java
<p>在一个循环中生成多个数据帧并将它们连接起来是非常低效的。最好在列表或字典上进行迭代,然后在循环后创建一个数据帧。下面,我已将您的系列文章转换回字典。请注意,在循环的每次迭代中都必须复制字典,以便循环不会不断改变原始字典</p>
<pre><code>import pandas as pd
import openpyxl
from copy import deepcopy
area = pd.Series({'California':423967, 'Texas':695662})
pop = pd.Series({'California':38332521, 'Texas':26448193})
area_d = area.to_dict()
pop_d = pop.to_dict()
sample = []
for i in range(10):
area_copy = deepcopy(area_d)
pop_copy = deepcopy(pop_d)
area_copy['wk'] = i
pop_copy['wk'] = i
sample += [area_copy, pop_copy]
df = pd.DataFrame(sample)
df.to_excel("result.xlsx", index = False)
</code></pre>