回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>关于这个话题,我看到了许多不同的答案。在我的情况下,情况有点不同,我有以下数据帧</p>
<pre><code> A B C
0 OPXXX OPT1 70
1 OPXXX OPT2 KO
2 OPXXX OPT3 KO
3 OPXXX OPT4 B
4 OPXXX OPT5 175000
5 OPXXX OPT6 Europ
6 OPXXX OPT7 2019-01-21
7 OPXXX OPT8 2019-05-21
8 OPXXX OPT9 2019-10-21
</code></pre>
<p>我很想这样,但问题是数据透视表由于聚合功能而无法工作:</p>
<blockquote>
<pre><code> A OPT1 OPT2 OPT3 OPT4 OPT5 OPT6 OPT7 OPT8 OPT9
OPXXX 70 KO KO B 175000 Europe 2019-01-21 2019-10-21 2019-10-21
</code></pre>
</blockquote>
<p>当我这样做时:测向枢轴(索引='A',值='C',列='B')</p>
<p>我有以下错误</p>
<blockquote>
<p>Traceback (most recent call last): File
"C:/Users/V002697/PycharmProjects/portia/tiaex.py", line 17, in
print(df.pivot(index='ticker',values='value', columns= 'field')) File
"C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\frame.py",
line 3853, in pivot
return pivot(self, index=index, columns=columns, values=values) File
"C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\reshape\reshape.py",
line 378, in pivot
return indexed.unstack(columns) File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\series.py",
line 2028, in unstack
return unstack(self, level, fill_value) File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\reshape\reshape.py",
line 458, in unstack
fill_value=fill_value) File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\reshape\reshape.py",
line 110, in <strong>init</strong>
self._make_selectors() File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\reshape\reshape.py",
line 148, in _make_selectors
raise ValueError('Index contains duplicate entries, ' ValueError: Index contains duplicate entries, cannot reshape</p>
</blockquote>
<p>我想知道你有什么想法?你知道吗</p>
<p>谢谢</p>