Python, Pandas : write content of DataFrame into text File

by

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.

More Related Contents:

  1. pandas to_csv output quoting issue
  2. Python Pandas: How to read only first n rows of CSV files in?
  3. Convert percent string to float in pandas read_csv
  4. How do I read a large csv file with pandas?
  5. Pandas filtering for multiple substrings in series
  6. Python pandas insert list into a cell
  7. Pandas DataFrame Groupby two columns and get counts
  8. Pandas: conditional rolling count
  9. group by pandas dataframe and select latest in each group
  10. Selection with .loc in python
  11. How to flatten a hierarchical index in columns
  12. Add column to dataframe with constant value
  13. Check if string is in a pandas dataframe
  14. How to efficiently handle European decimal separators using the pandas read_csv function?
  15. Compare Python Pandas DataFrames for matching rows
  16. How to use Pandas rolling_* functions on a forward-looking basis
  17. Finding consecutive segments in a pandas data frame
  18. Pandas DataFrames with NaNs equality comparison
  19. round a single column in pandas
  20. Pandas – Strip white space
  21. Identifying statistical outliers with pandas: groupby and reduce rows into different dataframe
  22. Creating an empty Pandas DataFrame, and then filling it
  23. How to remove decimal points in pandas
  24. Write file with specific permissions in Python
  25. Pretty print a pandas dataframe in VS Code
  26. Why doesn’t my pandas rolling().apply() work when the series contains collections?
  27. Add numpy array as column to Pandas data frame
  28. How to use ast.literal_eval in a pandas dataframe and handle exceptions
  29. Why is NaN considered as a float?
  30. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13

Leave a Comment