Contents
hide
How To Transpose Matrix In Python
Step 1: Define DataFrame
# app.py
import pandas as pd
dt = {
'Stranger Things': ['Mike', 'Eleven'],
'Money Heist': ['Professor', 'Tokyo']
}
df1 = pd.DataFrame(data=dt)
print(df1)
#######################Output
python3 app.py
Stranger Things Money Heist
0 Mike Professor
1 Eleven Tokyo
Step 2: pandas.DataFrame.T
import pandas as pd
dt = {
'Stranger Things': ['Mike', 'Eleven'],
'Money Heist': ['Professor', 'Tokyo']
}
df1 = pd.DataFrame(data=dt)
print(df1)
print('----------------------')
print('After apply transponse')
tdf1 = df1.T
print(tdf1)
#########################Output
python3 app.py
Stranger Things Money Heist
0 Mike Professor
1 Eleven Tokyo
----------------------
After apply transponse
0 1
Stranger Things Mike Eleven
Money Heist Professor Tokyo
Pandas.DataFrame.transpose()
import pandas as pd
dt = {
'Stranger Things': ['Mike', 'Eleven'],
'Money Heist': ['Professor', 'Tokyo']
}
df1 = pd.DataFrame(data=dt)
print(df1)
print('----------------------')
print('After apply transponse')
tdf1 = df1.transpose()
print(tdf1)
#############Output
python3 app.py
Stranger Things Money Heist
0 Mike Professor
1 Eleven Tokyo
----------------------
After apply transponse
0 1
Stranger Things Mike Eleven
Money Heist Professor Tokyo
Pandas transpose: Change the original object itself
import pandas as pd
dt = {
'Stranger Things': ['Mike', 'Eleven'],
'Money Heist': ['Professor', 'Tokyo']
}
df1 = pd.DataFrame(data=dt)
print(df1)
print('----------------------')
print('After apply transponse')
df1 = df1.transpose()
print(df1)
############Output
python3 app.py
Stranger Things Money Heist
0 Mike Professor
1 Eleven Tokyo
----------------------
After apply transponse
0 1
Stranger Things Mike Eleven
Money Heist Professor Tokyo
Pandas transpose: Non-square DataFrame with mixed dtypes
import pandas as pd
dt = {
'netflix': ['Birdbox', 'Murder Mystery'],
'actress': ['Sandra', 'Jennifer'],
'genre': ['Horror', 'Crime'],
'age': [52, 50]
}
df1 = pd.DataFrame(data=dt)
print(df1)
print('----------------------')
print('After apply transponse')
df1 = df1.transpose()
print(df1)
#############Output
python3 app.py
netflix actress genre age
0 Birdbox Sandra Horror 52
1 Murder Mystery Jennifer Crime 50
----------------------
After apply transponse
0 1
netflix Birdbox Murder Mystery
actress Sandra Jennifer
genre Horror Crime
age 52 50
Pandas transpose: View and copy
import pandas as pd
dt = {
'netflix': ['Birdbox', 'Murder Mystery'],
'actress': ['Sandra', 'Jennifer'],
'genre': ['Horror', 'Crime'],
'age': [52, 50]
}
df1 = pd.DataFrame(data=dt)
print(df1)
print('----------------------')
print('After apply transponse')
df2 = df1.transpose()
print(df2)
print('----------------------')
print('After modify the value of original dataframe')
df1.at[0,'actress'] = 'Bullock'
print(df1)
Output
python3 app.py
netflix actress genre age
0 Birdbox Sandra Horror 52
1 Murder Mystery Jennifer Crime 50
----------------------
After apply transponse
0 1
netflix Birdbox Murder Mystery
actress Sandra Jennifer
genre Horror Crime
age 52 50
----------------------
After modify the value of original dataframe
netflix actress genre age
0 Birdbox Bullock Horror 52
1 Murder Mystery Jennifer Crime 50