Convert Pandas dataframe to csv string

by

The simplest way is just to not input any filename, in this case a string is returned:

>>> df = pd.DataFrame({'A' : [0, 1], 'B' : [1, 6]})
>>> df.to_csv()
',A,B\n0,0,1\n1,1,6\n'

More Related Contents:

  1. Pandas conditional creation of a series/dataframe column
  2. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  3. How to unnest (explode) a column in a pandas DataFrame, into multiple rows
  4. Get the row(s) which have the max value in groups using groupby
  5. Why does concatenation of DataFrames get exponentially slower?
  6. Remove unwanted parts from strings in a column
  7. Combine Date and Time columns using python pandas
  8. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  9. Pandas Timedelta in Days
  10. how to get ticks every hour?
  11. How to add value labels on a bar chart
  12. How to remove blanks/NA’s from dataframe and shift the values up
  13. Why does my Pandas DataFrame not display new order using `sort_values`?
  14. python/pandas: convert month int to month name
  15. How to check if a column exists in Pandas
  16. Difference(s) between merge() and concat() in pandas
  17. Seaborn showing scientific notation in heatmap for 3-digit numbers
  18. Format certain floating dataframe columns into percentage in pandas
  19. How can I see the formulas of an excel spreadsheet in pandas / python?
  20. Count distinct words from a Pandas Data Frame
  21. How to annotate each segment of a stacked bar chart
  22. python pandas groupby() result
  23. How to implode(reverse of pandas explode) based on a column
  24. Pandas concat yields ValueError: Plan shapes are not aligned
  25. how to replace an entire column on Pandas.DataFrame
  26. Creating dummy variables in pandas for python
  27. How to convert DataFrame.append() to pandas.concat()?
  28. how to save a pandas DataFrame to an excel file?
  29. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  30. Add image annotations to bar plots

Leave a Comment