tabs not getting displayed when writing dataframe to csv in pandas

Question

I have a dataframe where one of the columns contains strings. But they have some tab formatting for each of them. Below is a snippet of how it looks like

formatted_line_items[1:3]
Out[393]: ['\t<string1>', '\t\t<string2>']

However when I write the dataframe using to_csv the formatting is lost. How can I write this to a csv file or excel file and still retain the formatting?

EDIT: I got to know that csv doesn't retain formatting so I used the pandas to_excel function but still no luck with the formatting.

Sujay DSa · Accepted Answer · 2018-04-03 10:56:48Z

1

Just found XlsxWriter has a set_indent function where we can specify the indentation.

answered Apr 3, 2018 at 10:56

Sujay DSa

1,1923 gold badges25 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

tabs not getting displayed when writing dataframe to csv in pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related