Transpose and save a one column pandas dataframe

November 5, 2021

I removed all except one row of a pandas dataframe and pandas automatically transposed it. I then try to retranspose it back (and eventually want save it as a .csv) without effect.

As a final result I want to have:

df3:
col1  col2  col3  
2     7     5

instead of

df3:
col1    2
col2    7
col3    5

and in the save .csv I want to have:

,col1,col2,col3
1,2,7,5

,1
col1,2
col2,7
col3,5

Here is the script:

import pandas as pd
d1 = {
    'col1': [1, 2], 
    'col2': [4, 7], 
    'col3': [8, 5], 
    }
df1 = pd.DataFrame(data=d1)
df2 = df1.loc[df1.loc[:,"col2"].idxmax(),:]
df3 = df2.transpose() # df2.That
print(df1)
print(df2)
print("df3:")
print(df3)
df3.to_csv("df3.csv")