Sometimes, we want to do long to wide reshape, by two variables with Python Pandas.
In this article, we’ll look at how to do long to wide reshape, by two variables with Python Pandas.
How to do long to wide reshape, by two variables with Python Pandas?
To do long to wide reshape, by two variables with Python Pandas, we can use groupby with cumcount.
For instance, we write
df['idx'] = df.groupby('Salesman').cumcount()
to call groupby to group values by the Salesman column.
And then call cumcount to return the cumulative counts of the grouped values.
Conclusion
To do long to wide reshape, by two variables with Python Pandas, we can use groupby with cumcount.
