数据帧：熊猫在一种情况下起作用，但在另一种情况下显示错误

Question

我有以下代码，可以分析最近的COVID19数据，并找到选定国家的累计确诊病例，这很好。

import pandas as pd
import matplotlib.pyplot as plt
url="https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv"
df=pd.read_csv(url)
print(df.head())
print('Dropping province, latitude and longitude')
df = df.drop(['Province/State', 'Lat', 'Long'], axis = 1)
print(df.head())
print('Selecting the countries of interest')
countries=['Italy','Netherlands']
s1=df.loc[df['Country/Region'].isin(countries)]    
print('s1=n',s1.head())
print('Summing all provinces for the same country')
df_gr = s1.groupby('Country/Region').sum()#.reset_index() 
print(df_gr.head())

以上最后给了我：

Summing all provinces for the same country
1/22/20  1/23/20  1/24/20  1/25/20  1/26/20  1/27/20  1/28/20  1/29/20  1/30/20  ...  3/26/20  3/27/20  3/28/20  3/29/20  3/30/20  3/31/20  4/1/20  4/2/20  4/3/20
Country/Region                                                                                   ...
Italy                 0        0        0        0        0        0        0        0        0  ...    80589    86498    92472    97689   101739   105792  110574  115242  119827
Netherlands           0        0        0        0        0        0        0        0        0  ...     7468     8647     9819    10930    11817    12667   13696   14788   15821

现在我先做groupby，然后做isin，以选择两个国家的数据，并期望获得相同的结果：

import pandas as pd
import matplotlib.pyplot as plt
url="https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv"
df=pd.read_csv(url)
print(df.head())
print('Dropping province, latitude and longitude')
df = df.drop(['Province/State', 'Lat', 'Long'], axis = 1)
print(df.head())

print('Summing all provinces for the same country')
df_gr = df.groupby('Country/Region').sum()#.reset_index() 
print(df.head())
print('Selecting the countries of interest')
countries=['Italy','Netherlands']
s1=df_gr.loc[df_gr['Country/Region'].isin(countries)]
print('s1=n',s1.head())

然而，我得到以下错误：

Traceback (most recent call last):
File "/usr/local/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2646, in get_loc
return self._engine.get_loc(key)
File "pandas/_libs/index.pyx", line 111, in pandas._libs.index.IndexEngine.get_loc
File "pandas/_libs/index.pyx", line 138, in pandas._libs.index.IndexEngine.get_loc
File "pandas/_libs/hashtable_class_helper.pxi", line 1619, in pandas._libs.hashtable.PyObjectHashTable.get_item
File "pandas/_libs/hashtable_class_helper.pxi", line 1627, in pandas._libs.hashtable.PyObjectHashTable.get_item
KeyError: 'Country/Region'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "dr2.py", line 27, in <module>
s1=df_gr.loc[df_gr['Country/Region'].isin(countries)]
File "/usr/local/lib/python3.7/site-packages/pandas/core/frame.py", line 2800, in __getitem__
indexer = self.columns.get_loc(key)
File "/usr/local/lib/python3.7/site-packages/pandas/core/indexes/base.py", line 2648, in get_loc
return self._engine.get_loc(self._maybe_cast_indexer(key))
File "pandas/_libs/index.pyx", line 111, in pandas._libs.index.IndexEngine.get_loc
File "pandas/_libs/index.pyx", line 138, in pandas._libs.index.IndexEngine.get_loc
File "pandas/_libs/hashtable_class_helper.pxi", line 1619, in pandas._libs.hashtable.PyObjectHashTable.get_item
File "pandas/_libs/hashtable_class_helper.pxi", line 1627, in pandas._libs.hashtable.PyObjectHashTable.get_item
KeyError: 'Country/Region'

有什么解释或补救措施吗？

Answer 1

您的代码看起来是正确的。粘贴后，它在pandas 1.0.3下正确运行，没有改变。

我建议您升级到以下软件包版本：

# Name                    Version                   Build  Channel
numpy                     1.17.3           py37hde6bac1_0    conda-forge
pandas                    1.0.3            py37h94625e5_0    conda-forge

如果您还没有针对您的conda管理包版本，它可以从https://conda.io/en/latest/miniconda.html