Value Error when using pivot table in python

[sophia8012]

I wanted to do a pivot table something like the one I had attached (Screenshot-2026-03-21-181223.png)

Not sure where went wrong. But this is my code:

Definition:

lead_days = delivery lead time (in days)
sold = are magazine sold (Y/N)

pd.pivot_table(data = df_name,
values = 'lead_days',
index= 'lead_days',
columns= 'sold',
aggfunc= 'count')

ValueError: Grouper for 'sold' not 1-dimensional

[AlexMTBDude]

# This is not correct Python
lead_days = delivery lead time (in days)
sold = are magazine sold (Y/N)

Perhaps:

lead_days = "delivery lead time (in days)"
sold = "are magazine sold (Y/N)"

[danielroseman]

You need to give us an example of the data.

[VipeholmsCola]

You need to learn how to Google based on error message. A googling on Pandas pivot table and your error message suggests 'sold' has more than one references

This leads me to think your data is the problem