How to export a series of text strings to csv via Python?

Question

I have a python script that runs a series of checks on a pandas dataframe, and prints the results of each check. The code behind each check looks a bit like this:

if sum(df["column1"]) >0:
    print("Success")
else:
    print("Failure")

What I want to do is save the results to a csv file with each result in its own cell, so that the csv looks like this:

Success
Success
Failure
Success
Failure

Does anyone know how to do this please?

Does this answer your question? How do I read and write CSV files with Python? — Yevhen Kuzmovych
– Yevhen Kuzmovych, Commented Sep 16, 2022 at 14:33
Your output is not formatted as csv, it's just a column of single words. Can't you use the default writing method? — Ignatius Reilly
– Ignatius Reilly, Commented Sep 16, 2022 at 14:38

Vignesh Babu P J · Accepted Answer · 2022-09-16 14:33:17Z

1

You can save the results as a List and export them as pandas DataFrame to csv:

res=[]
if sum(df["column1"]) >0:
    res.append("Success")
else:
    res.append("Failure")

pd.DataFrame(res).to_csv('filename.csv',index=False,header=False)

answered Sep 16, 2022 at 14:33

Vignesh Babu P J

363 bronze badges

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

Collectives™ on Stack Overflow

How to export a series of text strings to csv via Python?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related