Print A Pandas Data Frame to a Text File (Python 3)

Question

I have a large data file like this

 Words
 One
 Two
 Three
 ....
 Threethousand

I am trying to print this list to a text file with this code:

 df1 = df[['Words']]
 with open('atextfile.txt', 'w', encoding='utf-8') as outfile:
         print(df1, file=outfile)

But what happens is that it doesn't print out the whole DF, it ends up looking like this:

 Words
 One
 Two
 Three
 ....
 Threethousand
 Fourthousand
 Fivethousand

How can I print out the whole DF?

Andy Hayden · Accepted Answer · 2014-09-24 23:37:45Z

2

I would use to_string to do this, it doesn't abbreviate like the printing:

df['Words'].to_string('atextfile.txt')
# or
df[['Words']].to_string('atextfile.txt')

answered Sep 24, 2014 at 23:37

Andy Hayden

378k110 gold badges640 silver badges546 bronze badges

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

1 Answer 1