ValueError: Index contains duplicate entries, cannot reshape

raise ValueError("Index contains duplicate entries, cannot reshape") ValueError: Index contains duplicate entries, cannot reshape

df6 = pd.read_csv('E:/应统案例大赛/all.csv') df6 = df6.pivot(index='date', columns='code', values='avg') df6.to_csv('all_avg.csv', index=False)ValueError: Index contains duplicate entries, cannot reshape

Index contains duplicate entries, cannot reshape

C:\Users\99797\AppData\Local\Programs\Python\Python39\python.exe -X pycache_prefix=C:\Users\99797\AppData\Local\JetBrains\PyCharm2024.1\cpython-cache "C:/Program Files/JetBrains/PyCharm 2024.1.1/plugins/python/helpers/pydev/pydevd.py" --multiprocess --qt-support=auto --client 127.0.0.1 --port 49244 --file D:\python.py\pythonProject\csv2data_scaled.py 已连接到 pydev 调试器(内部版本号 241.15989.155)Traceback (most recent call last): File "C:\Program Files\JetBrains\PyCharm 2024.1.1\plugins\python\helpers\pydev\pydevd.py", line 1535, in _exec pydev_imports.execfile(file, globals, locals) # execute the script File "C:\Program Files\JetBrains\PyCharm 2024.1.1\plugins\python\helpers\pydev\_pydev_imps\_pydev_execfile.py", line 18, in execfile exec(compile(contents+"\n", file, 'exec'), glob, loc) File "D:\python.py\pythonProject\csv2data_scaled.py", line 18, in <module> pivot_df = df.pivot( File "C:\Users\99797\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\frame.py", line 8414, in pivot return pivot(self, index=index, columns=columns, values=values) File "C:\Users\99797\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\reshape\pivot.py", line 557, in pivot result = indexed.unstack(columns_listlike) # type: ignore[arg-type] File "C:\Users\99797\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\frame.py", line 8961, in unstack result = unstack(self, level, fill_value) File "C:\Users\99797\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\reshape\reshape.py", line 475, in unstack return _unstack_frame(obj, level, fill_value=fill_value) File "C:\Users\99797\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\reshape\reshape.py", line 498, in _unstack_frame unstacker = _Unstacker(obj.index, level=level, constructor=obj._constructor) File "C:\Users\99797\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\reshape\reshape.py", line 136, in __init__ self._make_selectors() File "C:\Users\99797\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\reshape\reshape.py", line 188, in _make_selectors raise ValueError("Index contains duplicate entries, cannot reshape") ValueError: Index contains duplicate entries, cannot reshape 进程已结束，退出代码为 1