Export DataFrame from Python to CSV

Question

I have a data frame I created with my original data appended with the topics from topic modeling. I keep running into errors when trying to export the data table into csv.

I've tried both csv module and pandas but get errors from both.

The data table has 1765 rows so writing the file row by row is not really an option.

When using pandas, most common errors are

DataFrame constructor not properly called!

and

function object has no attribute 'to_csv'

Code used:

import pandas as pd

data = (before.head)

df = pd.DataFrame(before.head)
df.to_csv (r'C:\Users\***\Desktop\beforetopics.csv', index = False, header=True)
print (df)

For the CSV module, there have been several errors such as

iterable expected, not method

Basically, how do I export this table (screenshot attached) into a csv file?

what error are you getting? And pandas has to_csv for saving a Dataframe to csv — Imanpal Singh
– Imanpal Singh, Commented May 24, 2020 at 15:51
You should update your question with a minimal, reproducible example of your code — Imanpal Singh
– Imanpal Singh, Commented May 24, 2020 at 15:59

Imanpal Singh · Accepted Answer · 2020-05-24 16:10:20Z

1

You can use the to_csv function:

before.to_csv('file_name.csv')

If you need extra options, you can check the documentation from here.

edited May 24, 2020 at 16:10

Imanpal Singh

1,2081 gold badge13 silver badges25 bronze badges

answered May 24, 2020 at 16:06

Karina Kozarova

1,2134 gold badges17 silver badges33 bronze badges

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

Comments

Imanpal Singh · Accepted Answer · 2020-05-24 16:07:31Z

1

What is the command that you're trying to run?

Try this:

dataframe.to_csv('file_name.csv')

Or if it is the unicode error that you're coming across,

Try this:

dataframe.to_csv('file_name.csv', header=True, index=False, encoding='utf-8')

Since your dataframe's name is before,

Try this:

before.to_csv('file_name.csv', header=True, index=False, encoding='utf-8')

edited May 24, 2020 at 16:07

Imanpal Singh

1,2081 gold badge13 silver badges25 bronze badges

answered May 24, 2020 at 15:58

Vijay

13412 bronze badges

2 Comments

Kayla Schwoerer Over a year ago

That worked. Not surprising since I finally used the correct name for my data frame...I think it's time to finally take a break! I'm starting to lose my mind....THANK YOU!

Vijay Over a year ago

Haha! You're welcome. All the best for your future works!

Collectives™ on Stack Overflow

Export DataFrame from Python to CSV

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related