how to transpose a pandas dataframe in python

To transpose a Pandas DataFrame in Python, you can use the transpose() function or the .T attribute.

Here's an example:

main.py
import pandas as pd

# Create a sample DataFrame
data = {'Name': ['John', 'Emma', 'Ryan'],
        'Age': [26, 24, 30],
        'Country': ['USA', 'Canada', 'UK']}
df = pd.DataFrame(data)

# Transpose the DataFrame using the transpose() function
transposed_df = df.transpose()
print(transposed_df)

# Transpose the DataFrame using the .T attribute
transposed_df = df.T
print(transposed_df)

390 chars
16 lines

Both transpose() function and .T attribute will return a new transposed DataFrame. The result will be a DataFrame where the columns of the original DataFrame become rows, and vice versa.

Note that the transposed DataFrame will have the column names of the original DataFrame as index.

Output:

main.py
           0       1     2
Name    John    Emma  Ryan
Age       26      24    30
Country  USA  Canada    UK

           0       1     2
Name    John    Emma  Ryan
Age       26      24    30
Country  USA  Canada    UK

217 chars
10 lines

similar python code snippets

add a numpy array to dataframe in python
update a dataframe row from another row in python
keep first unique values of each coumn in dataframe and replace other repeated values with nan in python
moving average in pandas in python
how to append at the end of a dataframe in python
add colname to a dataframe in python
combine two dataframes in python
jean paul get all the unique values from a pandas series exept for some specific values to not consider in python
not select columns of a dataframe from a list of those columns in python
merge tables in python

related categories

pandas
dataframes

gistlibby LogSnag