Pandas - Creating pivot of duplicates index column

Question

I am trying to create a pivot of my Dataframe that has no numerical values and duplicates exist in the index column. Given below is how my data looks:

sale_id, product, sale_date
101, ABC, 2021-01-01
101, DEF, 2021-02-01
101, XYZ, 2021-03-01
101, KLM, 2021-01-04

Expect the below output:

    ABC, DEF, XYZ, KLM
101 2021-01-01, 2021-02-01, 2021-03-01, 2021-01-04

I tried the below

df.pivot(index='sale_id', columns='product', values='sale_date')

It threw the below error

ValueError: Index contains duplicate entries, cannot reshape

jezrael · Accepted Answer · 2021-10-08 13:07:13Z

1

I am trying to create a pivot of my Dataframe that has no numerical values and duplicates exist in the index column.

For test duplicates use DataFrame.duplicated:

df1 = df[df.duplicated(['sale_id','product'], keep=False)]
print (df1)

For remove duplicates use DataFrame.drop_duplicates:

(df.drop_duplicates(['sale_id','product'])
   .pivot(index='sale_id', columns='product', values='sale_date'))

edited Oct 8, 2021 at 13:07

answered Oct 8, 2021 at 13:03

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pandas - Creating pivot of duplicates index column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related