解决pandas.errors.InvalidIndexError: (slice(None, None, None), None)

Traceback (most recent call last):  File "D:\Anaconda\lib\site-packages\pandas\core\indexes\base.py", line 3621, in get_loc    return self._engine.get_loc(casted_key)  File "pandas\_libs\index.pyx", line 136, in pandas._libs.index.IndexEngine.get_loc  File "pandas\_libs\index.pyx", line 142, in pandas._libs.index.IndexEngine.get_locTypeError: '(slice(None, None, None), None)' is an invalid keyDuring handling of the above exception, another exception occurred:Traceback (most recent call last):  File "D:\Anaconda\lib\site-packages\matplotlib\cbook\__init__.py", line 1318, in _check_1d    ndim = x[:, None].ndim  File "D:\Anaconda\lib\site-packages\pandas\core\frame.py", line 3505, in __getitem__    indexer = self.columns.get_loc(key)  File "D:\Anaconda\lib\site-packages\pandas\core\indexes\base.py", line 3628, in get_loc    self._check_indexing_error(key)  File "D:\Anaconda\lib\site-packages\pandas\core\indexes\base.py", line 5637, in _check_indexing_error    raise InvalidIndexError(key)pandas.errors.InvalidIndexError: (slice(None, None, None), None)

ValueError: x and y must have same first dimension, but have shapes (2, 14) and (14,)

问题分析：
由于上图索引（时间列）存在重复，导致下面代码中， ax.plot()的时候，把两个相同的索引，构造了一个(2,14)的重复

fig, ax = plt.subplots(figsize=(15, 7))cmap = plt.get_cmap('viridis')colors = cmap(np.linspace(0, 1, len(df_10minv2)))for i, (name, color) in tqdm(enumerate(zip(names, colors), 1)):    ax.plot(df_10minv2.loc[name], height, c=color, linestyle='-', label=str(name), marker='.')

解决办法：对索引列去重复

# 如果你想保留第一个aa，那么keep就是firstdf.reset_index().drop_duplicates(subset='index', keep='first').set_index('index')

来源地址：https://blog.csdn.net/weixin_46713695/article/details/128138944