Python Pandas, write DataFrame to fixed-width file (to_fwf?)

by

Until someone implements this in pandas, you can use the tabulate package:

import pandas as pd
from tabulate import tabulate

def to_fwf(df, fname):
    content = tabulate(df.values.tolist(), list(df.columns), tablefmt="plain")
    open(fname, "w").write(content)

pd.DataFrame.to_fwf = to_fwf

More Related Contents:

  1. How do I read a fixed width format text file in pandas?
  2. cartesian product in pandas
  3. Keep other columns when doing groupby
  4. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  5. Convert the string 2.90K to 2900 or 5.2M to 5200000 in pandas dataframe
  6. What does `ValueError: cannot reindex from a duplicate axis` mean?
  7. Reconstruct a categorical variable from dummies in pandas
  8. Conditionally fill column values based on another columns value in pandas
  9. Search for String in all Pandas DataFrame columns and filter
  10. Remove duplicate rows from Pandas dataframe where only some columns have the same value
  11. Normalize columns of a dataframe
  12. Rename result columns from Pandas aggregation (“FutureWarning: using a dict with renaming is deprecated”)
  13. Quickest way to make a get_dummies type dataframe from a column with a multiple of strings
  14. Vectorized look-up of values in Pandas dataframe
  15. Seaborn: countplot() with frequencies
  16. Removing the timestamp from a datetime in pandas dataframe
  17. How to read a column of csv as dtype list using pandas?
  18. Write pandas dataframe to xlsm file (Excel with Macros enabled)
  19. import pandas_datareader gives ImportError: cannot import name ‘is_list_like’
  20. PIP Install Numpy throws an error “ascii codec can’t decode byte 0xe2”
  21. Pandas: How to create a datetime object from Week and Year?
  22. Python Pandas merge samed name columns in a dataframe
  23. How can I replicate rows of a Pandas DataFrame?
  24. In Python pandas, start row index from 1 instead of zero without creating additional column
  25. plotting a histogram on a Log scale with Matplotlib
  26. How to convert R dataframe back to Pandas using rpy2?
  27. Changing width of bars in bar chart created using seaborn.factorplot
  28. How to do ‘lateral view explode()’ in pandas [duplicate]
  29. Convert pandas DataFrame into list of lists [duplicate]
  30. Got continuous is not supported error in RandomForestRegressor

Leave a Comment