Rajendra Gupta shows a few ways to pivot data using Python:
We can use groupby and lambda functions as well in the Python scripts for Pivot tables. For this example, I have a data set of a few states of India and their cities in a SQL table.
We need a pivot table from this data. In the output, it should list all cities for a state in a column; it should use || as a city name separator.
This is an unorthodox but interesting use of Machine Learning Services.