CODEWITHSUNDEEP
pythonpandascsv
senarijit1618
senarijit1618

Reputation: 417

Pandas .to_csv not exporting correct output into the csv file

I am trying to put a dataframe into a csv file and then access it. But by doing so the NaN values are showing up and the data are misaligned.

expenses = df.iloc[:][['Description','Debit']].dropna()

Here, i am trying to get the Description and debit column where there is no NaN data.

expenses.to_csv(path_or_buf= 'expenses.csv',index=False, header=["Description", "Debit"],encoding='utf-8')
expenses = pd.read_csv("expenses.csv", thousands=",", header= 0)

And then saving that dataframe into expenses and trying to access the same csv file but the content is misaligned. When I open the csv file its correct.

Here, is a screenshot to help you understand:

Image

Upvotes: 0

Views: 389

Answers (1)

user2906838
user2906838

Reputation: 1178

That is because, by default the inplace=False, when you use dropna , do:

df.dropna(subset=['Description','Debit'], inplace=True)

It should work. Your df, in this case, should have dropped the NaN values on these two columns.

Upvotes: 2

Related Questions