print a pandas dataframe to text with lines longer than 80 chars
Try changing pandas.options.display.width. (It's 80 by default)
I want to print a Dataframe to a text file,
Say I have a table with 4 lines, and 12 columns.
It looks quite nice when I just use print df, with all the values of a column aligned to the right, however, when there are too many columns (8 in my case) it breaks the table down so that the last 4 columns are printed after 4 lines of 8 values. Probably as Pandas tries to make the table fit in a 80 chars line.
I tried df.to_csv().replace(',','\t'), but then entries longer than a tab cause a jump in the line, and the lines are no longer aligned.
How can I get the nice, orderly, aligned to right, fashion, but not enforcing 80 characters per line?