Python Pandas write content of DataFrame into text File

Question

I have pandas DataFrame like this          X    Y  Z    Value  0      18   55  1      70    1      18   55  2      67  2      18   57  2      75      3      18   58  1      35   4      19   54  2      70      I want to write this data to a text file that looks like this   18 55 1 70    18 55 2 67  18 57 2 75      18 58 1 35   19 54 2 70    I have tried something like   f   open writePath   a   f writelines    n   str data  X          str data  Y          str data  Z          str data  Value      f close     but it s not working  How to do this

User · Answer

I used a slightly modified version   with open file name   w   encoding    utf-8   as f      for rec index  rec in df iterrows            f write rec   lt field gt        n     I had to write the contents of a dataframe field  that was delimited  as a text file

User · Answer

You can use pandas DataFrame to csv    and setting both index and header to False   In  97   print df to csv sep      index False  header False  18 55 1 70 18 55 2 67 18 57 2 75 18 58 1 35 19 54 2 70   pandas DataFrame to csv can write to a file directly  for more info you can refer to the docs linked above

User · Answer

Way to get Excel data to text file in tab delimited form  Need to use Pandas as well as xlrd   import pandas as pd import xlrd import os  Path  C  downloads  wb   pd ExcelFile Path    input xlsx   engine None  sheet2   pd read excel wb  sheet name  Sheet1   Excel Filter sheet2 sheet2  Name     Test   Excel Filter to excel  C  downloads  output xlsx   index None  wb2 xlrd open workbook Path    output xlsx   df wb2 sheet by name  Sheet1   x df nrows y df ncols  for i in range 0 x       for j in range 0 y           A str df cell value i j           f open Path    emails txt    a           f write A   t           f close       f open Path    emails txt    a       f write   n       f close   os remove Path    output xlsx   print Excel Filter    We need to first generate the xlsx file with filtered data and then convert the information into a text file   Depending on requirements  we can use  n  t for loops and type of data we want in the text file

User · Answer

Late to the party  Try this   base filename    Values txt  with open os path join WorkingFolder  base filename   w   as outfile      df to string outfile   Neatly allocate all columns and rows to a  txt file

User · Answer

The current best way to do this is to use df to string     with open writePath   a   as f      f write          df to string header   False  index   False         Will output the following 18 55 1 70    18 55 2 67  18 57 2 75      18 58 1 35   19 54 2 70   This method also lets you easily choose which columns to print with the columns attribute  lets you keep the column  index labels if you wish  and has other attributes for spacing ect

User · Answer

You can just use np savetxt and access the np attribute  values   np savetxt r c  data np txt   df values  fmt   d     yields   18 55 1 70 18 55 2 67 18 57 2 75 18 58 1 35 19 54 2 70   or to csv   df to csv r c  data pandas txt   header None  index None  sep      mode  a     Note for np savetxt you d have to pass a filehandle that has been created with append mode

User · Answer

AHegde - To get the tab delimited output use separator sep   t    For df to csv   df to csv r c  data pandas txt   header None  index None  sep   t   mode  a     For np savetxt   np savetxt r c  data np txt   df values  fmt   d   delimiter   t

[python] Python, Pandas : write content of DataFrame into text File

Examples related to python

Examples related to pandas

Examples related to file-io