擅长:python、mysql、java
<p>使用这段代码,您可以在一个名为“总计”的新列上获取每个nan的“运行总计”</p>
<pre><code>total = 0
df['Totals'] = 0 # assign 0 initially to all rows of the new column
for i in range(df.shape[0]): # shape[0] return number of rows
expenditure = df.loc[i+1, 'Budget_Expenditure_2012_'] # i+1 coz your indexing starts at 1
if np.isnan(expenditure):
df.loc[i, 'Totals'] = total
total = 0
else:
total += expenditure
</code></pre>