How To Transpose Matrix In Python

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