Convert your columns into rows, and rows into columns.

Why transpose

Transposing data turns a dataframe's columns into rows, and rows into columns. Usually pandas dataframes are organized such that each row represents a record, transaction, object, etc., and each column represents a different attribute of those records. When your data is organized in the opposite orientation, using transpose is a helpful step in preparing your data.

How to transpose your data

To transpose a dataframe:

  1. Select the dataframe that you want to transpose.

  2. Select the Insert tab.

  3. Click Transpose.

The transpose operation creates a new dataframe in your Mito spreadsheet. It is named the name of the transposed dataframe appended with _transposed.

Last updated