[Python] Pandas pivot ValueError: Index contains duplicate entries, cannot reshape

I have a dataframe as shown below (top 3 rows):

Sample_Name Component_Name Calculated_Concentration
Index
1 20170824_ELN147926_HexLacCer_Plasma_A-1-1 GluCer(d18:1/12:0)_LCB_264.3 NaN
2 20170824_ELN147926_HexLacCer_Plasma_A-1-1 GluCer(d18:1/17:0)_LCB_264.3 NaN
3 20170824_ELN147926_HexLacCer_Plasma_A-1-1 GluCer(d18:1/16:0)_LCB_264.3 125.92766


When trying to generate a pivot table:

pivoted_report_conc = raw_report.pivot(
index="Sample_Name",
columns='Component_Name',
values="Calculated_Concentration")


I get the following error:

ValueError: Index contains duplicate entries, cannot reshape


I tried resetting the index but it did not help. I couldn't find any duplicate values in the "Index" column. Could someone please help identify the problem here?

The expected output would be a reshaped dataframe with only the unique component names as columns and respective concentrations for each sample name:

GluCer(d18:1/12:0)_LCB_264.3 GluCer(d18:1/17:0)_LCB_264.3 GluCer(d18:1/16:0)_LCB_264.3
Sample_Name
20170824_ELN147926_HexLacCer_Plasma_A-1-1 NaN NaN 125.92766


To clarify, I am not looking to aggregate the data, just reshape it.

Continue reading...