T is the function used to transpose the dataframe in pandas python. Let’s see how to
- Transpose the data from rows to columns and from columns to rows in pandas python
Let’s first create the dataframe.
import pandas as pd
import numpy as np
#Create a DataFrame
df1 = {
'Name':['George','Andrea','micheal','maggie','Ravi','Xien','Jalpa'],
'State':['Arizona','Georgia','Newyork','Indiana','Florida','California','Texas'],
'Gender':["M","F","M","F","M","M","F"],
'Score':[63,48,56,75,32,77,85],
}
df1 = pd.DataFrame(df1,columns=['Name','State','Gender','Score'])
print(df1)
So the resultant dataframe will be
Transpose simply means to change the rows to columns and columns to rows. This can be accomplished by T function as shown below
transposed_df =df1.T print(transposed_df)
So the transposed dataframe will be
transposed_df:
