Mastering pandas - Second Edition

Transpose in pandas

The transpose function in pandas is similar to that of NumPy. It interchanges rows and columns. Let's find the transpose of the following DataFrame:

sales_data.groupby("Category").sum()

The following will be the output:

Data to be transposed

In the transpose of the DataFrame, the column labels and row indices are swapped:

sales_data.groupby("Category").sum().transpose()

The following will be the output:

Output of transpose

T acts as an accessor to the transpose function and can be used as shown:

sales_data.groupby("Category").sum().T ...