CODEWITHSUNDEEP
pythonpandasdataframetranspose
Coloane
Coloane

Reputation: 317

Pandas dataframe transpose, to_csv

In the code below, in line 4 I can transpose the dataframe, but in line 5, when I use to_csv, the new CSV file is created, it remains the original version and not the transposed one. What might have gone wrong? 

import numpy as np
import pandas as pd

df = pd.read_csv('~/N.csv')

df2 = df.T

df2 = df.to_csv('~/N_transposed.csv')

Thank you!

Upvotes: 5

Views: 9200

Answers (2)

Anshul Goyal
Anshul Goyal

Reputation: 77073

In line 5, use 

df3 = df2.to_csv('~/N_transposed.csv')

or

 df2.to_csv('~/N_transposed.csv')

The df variable has not been altered, the result is stored in df2 and that's what you need to output to csv, not df.to_csv.

Upvotes: 4

chucklukowski
chucklukowski

Reputation: 2034

No need to use df2 =

This is enough..

df2.to_csv('~/N_transposed.csv')

Upvotes: 8

Related Questions