How to transpose a DataFrame in Pandas

By Anish

In this tutorial, we will learn how to transpose a DataFrame in Python using a library called pandas.

Pandas library in Python is a very powerful tool for data manipulation and analysis used by data scientists and analysts across the globe. With the help of pandas, we can create a data structure called DataFrame. A DataFrame is a tabular form of the data present in CSV, excel, etc types of files. Creating a DataFrame using pandas eases out the process of data cleaning and sorting. Let us first install pandas.

pip install pandas

This command installs pandas in our computer. Now, we need to import it in our IDE or text editor.

import pandas as pd

Now, pandas is imported and ready to use. Let us make a DataFrame which we wish to transpose.

name = ['John', 'Paul', 'George', 'Ringo']
rno = ['2', '3', '1', '4']
mks = ['60', '80', '90', '75']

dict = {'Name':name, 'Rollno':rno, 'Marks':mks}

This is the data which we want to convert into a DataFrame. To do that, we use the pandas.Dataframe() method which is in-built in pandas.

df = pd.Dataframe(dict)
print(df)

Output:

     Name Rollno Marks
0    John      2    60
1    Paul      3    80
2  George      1    90
3   Ringo      4    75

Here, we have created a DataFrame and stored it in a variable called df.

Moving on, to transpose this DataFrame we need to use another in-built pandas function Dataframe.transpose().

transposed_df = df.transpose()
print(transposed_df)

Output:

           0     1       2      3
Name    John  Paul  George  Ringo
Rollno     2     3       1      4
Marks     60    80      90     75

As a result, we have successfully transposed our DataFrame using in-built pandas functions.