save to text from pandas dataframe

Question

Im trying to save my dataframe which consists of 2 colums into a text file,I get this error of mismatch between array dtype,any suggestions on what i could do?

The error Image

afagarap · Accepted Answer · 2017-08-01 17:02:09Z

7

Use DataFrame.to_csv:

df.to_csv('hopefully.txt', index=False, sep=' ', header=None)

For the file to be saved without a comma, use the sep=' '. To cut off the column title, header=None.

edited Aug 1, 2017 at 17:02

afagarap

6492 gold badges10 silver badges22 bronze badges

answered Aug 1, 2017 at 16:55

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

3 Comments

Ryan Over a year ago

thanks,that works but i was hoping to save the file without the comma,in this file there is a comma in between, i need just a space in between,what do i do get that?

jezrael Over a year ago

@Abien Fred Agarap - Thank you.

Ryan Over a year ago

Thanks a million man!! once i get 15 rep points ,ill make sure to come back and accept.

Collectives™ on Stack Overflow

save to text from pandas dataframe

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related