Comment on page


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. 1.
    Select the dataframe that you want to transpose.
  2. 2.
    Select the Insert tab.
  3. 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.