Passing list-likes to .loc or [] with any missing label will raise KeyError in the future

报错信息

C:\Anaconda3\lib\site-packages\pandas\core\indexing.py:1472: FutureWarning: 
Passing list-likes to .loc or [] with any missing label will raise
KeyError in the future, you can use .reindex() as an alternative.

主要原因是由于再用loc的时候传入了df不存在的 index 或者 column， 下面举例说明：

>>> import pandas as pd

>>> df = pd.DataFrame([[1,2,3,4],[4,5,6,7]], columns=list('abcd'))
>>> df
   a  b  c  d
0  1  2  3  4
1  4  5  6  7

• 下面传入索引 [1, 3] ,其中 3 并不存在， 解决办法是先dropna

>>> df.loc[[1,3], :]
C:\Apps\anaconda3.6\lib\site-packages\pandas\core\indexing.py:1472: FutureWarning: 
Passing list-likes to .loc or [] with any missing label will raise
KeyError in the future, you can use .reindex() as an alternative.

See the documentation here:
https://pandas.pydata.org/pandas-docs/stable/indexing.html#deprecate-loc-reindex-listlike
  return self._getitem_tuple(key)
     a    b    c    d
1  4.0  5.0  6.0  7.0
3  NaN  NaN  NaN  NaN
# 解决办法是先dropna
>>> df.loc[[1,3], :].dropna()
>    a    b    c    d
1  4.0  5.0  6.0  7.0

• 对于 column 列，同理; 传入[‘a’, ‘b’, ‘h’]，‘h’ 不存在。解决办法也是 dropna， 不过 axis=1

>>> df.loc[:, ['a', 'b', 'h']]
   a  b   h
0  1  2 NaN
1  4  5 NaN
# 解决办法也是 dropna， 不过 axis=1
>>> df.loc[:, ['a', 'b', 'h']].dropna(axis=1)
   a  b
0  1  2
1  4  5