Questions tagged [pivot]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
0 answers

Print columns of text without hard coding the width (attempt 6 - pivot edition)

If you'd like to pivot this: ...
candied_orange's user avatar
3 votes
0 answers

SQL query to pivot table into dynamically growing set of columns

I am working on SQL Server I have sample data like this in a table. CustId Bank city rating date rnk 1 Deutsche Delhi 5 10/10/2022 1 1 BOA Pune 6 10/10/2022 2 1 UBS Mumbai 7 10/10/2022 3 1 SBI ...
user3580341's user avatar
2 votes
2 answers

Pivoting and then Padding a Pandas DataFrame with NaN between specific columns - Case Study

This question is about pivoting and padding columns, two very frequent activities in Pandas. I have a raw dataframe. I need to manipulate from long to ...
Andrea Ciufo's user avatar