擅长:python、mysql、java
<p>如果要使用<code>iterrows()</code>,可以执行以下操作:
<br/>编辑:<code>skiprows</code>已添加,因为实际数据从第7行开始</p>
<pre><code>import pandas as pd
df = pd.read_excel(r'C:\Users\julia\OneDrive\Documents\python assignment\2016 data -EU
values.xlsx', sheet_name='PM10 ', skiprows=6)
result = 0
for row in df.iterrows():
if row[1]['Country'] == 'Malta':
result += row[1]['AirPollutionLevel']
print(result)
</code></pre>