Pivoting means to use unique values from the specified index/columns to form the apex of the resulting data frame. Pivot() and pivot_table() methods. Pivot and Unpivot in SQL are two relational operators that are used to convert a table expression into another.