Change the Pandas Dataframe type to String

Question

I'm working on a chatbot that returns a string message to the user. However, my current code outputs a pandas DataFrame. May I know how to convert this DataFrame to a string output? Not just for the individual cell value. But the whole DataFrame change to string format.

such that type(df) is string.

df = 
     Bearish Neutral Bullish
CLOV   0.041   0.817   0.142
AMD    0.037   0.742   0.222
TTCF   0.063   0.759   0.177

type(df) =
<class 'pandas.core.frame.DataFrame'>

Take a look at pandas.DataFrame.to_string or pandas.DataFrame.to_markdown for more formatted tabular ascii options. — Henry Ecker
– Henry Ecker ♦, Commented Sep 4, 2021 at 5:30

DYZ · Accepted Answer · 2021-09-04 05:24:17Z

1

There are many ways to answer your question, depending on how you want the string to be formatted. Probably the simplest are df.to_csv() that creates a CSV-like table, and str(df) that formats the dataframe more or less the way it looks on your command line.

answered Sep 4, 2021 at 5:24

DYZ

57.3k10 gold badges73 silver badges101 bronze badges

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

Comments

mozway · Accepted Answer · 2021-09-04 05:42:54Z

0

If your goal is to output a string representation of the dataframe, you can use df.to_string().

You should get something like:

'     Bearish Neutral Bullish\nCLOV   0.041   0.817   0.142\nAMD    0.037   0.742   0.222\nTTCF   0.063   0.759   0.177'

answered Sep 4, 2021 at 5:42

mozway

267k13 gold badges56 silver badges106 bronze badges

Collectives™ on Stack Overflow

Change the Pandas Dataframe type to String

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related