DOC: Pivot() example call incorrectly used and would give "error: duplicate index" #61058
Description
Pandas version checks
- I have checked that the issue still exists on the latest versions of the docs on
mainhere
Location of the documentation
doc/source/user_guide/reshaping.rst
Documentation problem
the table given as an example for pivot() is wrong and cant be used. it would return "error duplicate index" as there are duplicate values in the column given for "index" parameter.
Suggested fix for documentation
The "foo" column must contain unique values