<ol>
<li>构建数据帧</li>
</ol>
<p>使用熊猫,并根据这个<a href="https://stackoverflow.com/questions/55602398/complex-nested-dictionaries/55605428#55605428">answer</a>读取你的文件。你知道吗</p>
<pre><code>import pandas as pd
filename = 'dph_SYB60_T03_Population Growth, Fertility and Mortality Indicators.csv'
df = pd.read_csv(filename)
</code></pre>
<ol start=“2”>
<li>构建数据透视表</li>
</ol>
<p>然后可以为“Region/Country/Area”和“Series”创建一个轴,并将其用作聚合函数“max”。你知道吗</p>
<pre><code>pivot = df.pivot_table(index='Region/Country/Area', columns='Series', values='Value', aggfunc='max')
</code></pre>
<ol start=“3”>
<li>按您感兴趣的系列排序</li>
</ol>
<p>然后按序列名对“透视表”排序,并使用参数“升序”</p>
<pre><code>df_sort = pivot.sort_values(by='Maternal mortality ratio (deaths per 100,000 population)', ascending=False)
</code></pre>
<ol start=“4”>
<li>提取第一行中的最大值。你知道吗</li>
</ol>
<p>最后你会得到你问题的答案。你知道吗</p>
<pre><code>df_sort['Maternal mortality ratio (deaths per 100,000 population)'].head(1)
Region/Country/Area
Sierra Leone 1986.0
Name: Maternal mortality ratio (deaths per 100,000 population), dtype: float64
</code></pre>
<blockquote>
<p>Warning: Some of your regions have records before 2005, so you should filter your data only for values between 2005 and 2015.</p>
</blockquote>