Converting to text file from dataframe doesnt separate lines

Question

I use export from pandas data frame in Jupyter:

        df_merged.to_csv(text_file, index=True, mode='a', sep=' ')

In Jupyter all looks nice:

But when I download it I see that the lines are not separated:

Please, dont you know where the issue might be? Thanks!

RESULT: this helped for Windows:

        df_merged.to_csv(text_file, index=False, mode='a', sep='\t', line_terminator='\r\n')

which format is your text_file? Does `.txt`has line breakers? Try to export it as csv, then it should work — PV8, Aug 13 '19 at 11:23
You can try `line_terminator='\n'` in the `to_csv` arguments. — Sayandip Dutta, Aug 13 '19 at 11:23
https://stackoverflow.com/questions/31247198/python-pandas-write-content-of-dataframe-into-text-file — PV8, Aug 13 '19 at 11:24
Hi, this helped: df_merged.to_csv(text_file, index=False, mode='a', sep='\t', line_terminator='\r\n') — HeadOverFeet, Aug 13 '19 at 13:11

score 1 · Accepted Answer · answered Aug 13 '19 at 11:24

It looks like:

Pandas will write out the csv file with newline '\n' only as the line separator. Notepad will only break a line if it has carriage returns '\r'.

I would recommend using a different text editor such as Notepad++

1 Answers1