Pivot - Index contains duplicate entries, cannot reshape - which line in the dataframe is causing the error?
a
b
c




54545
3
8


54545
2
16


54545
1
64




The idea is to generate a Pivot out of it with B being the columns, column A is going to be the index and C is the value of the columns.
df = df_2.pivot(index='A', columns="B", values='C').reset_index()
Hope it is understandable what I want to do.
I have an issue with a dataframe I try to pivot. The error message says that it contains duplicate entires. However I have checked the file and there are no duplicates (checked with df.duplicated, in Excel and manually). As I am running out of ideas, is there a way to know in which line in the dataframe is causing the error to throw? The Python error message is unfortuneately not very clear...
The code itself is working with another dataframe so I assume my code should be fine...