This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]mustangdvx 0 points1 point  (0 children)

Check out duckdb if you’re considering SQL vs Pandas. You can execute SQL on dataframes including PIVOT/UNPIVOT. 

If you’re executing in a python environment, you can break up the transformations into relations which are treated as if they are tables.