The pandas.pivot(data, index=None, columns=None, values=None) function returns reshaped DataFrame organized by given index / column values.
Click here for the documentation.
import pandas as pd
import numpy as np
df_to_pivot = pd.read_csv('to_pivot.csv', header=0)
df_to_pivot.head()
df_to_pivot['HEAD'].unique()array(['BASIC', 'DA', 'HRA', 'SPECIAL'], dtype=object)
df_to_pivot = pd.pivot(df_to_pivot, index=['EMP_NO'], columns=['HEAD'],
values=['AMOUNT'])
df_to_pivot.head()
df_to_pivot.columns = [str(j) + '_' + str(i) for i, j in df_to_pivot.columns]
df_to_pivot.head()
df_to_pivot.reset_index(inplace=True)
df_to_pivot