pandas.DataFrame.to_csv header formatting

Question

I'm wondering if there is a method to change the string formatting in pandas.DataFrame.to_csv.

In particular, I'd like to set each column header to something like %20s so that they are all evenly spaced out in the file. I read this stackexchange but I was hoping to do it without writing the header beforehand.

Thanks in advance.

user3483203 · Accepted Answer · 2021-06-18 02:14:18Z

0

I don't think to_csv has a built in header formatting function, but you can always loop over the headers and fill them to the full length before printing. Something like

df.columns = [column_header.rjust(20, ' ') for column_header in df.columns]

edited Jun 18, 2021 at 2:14

user3483203

51.3k10 gold badges72 silver badges104 bronze badges

answered Jun 14, 2021 at 20:32

Nate Rush

3952 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

pandas.DataFrame.to_csv header formatting

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related