Export Python Dataframe to Excel

Question

I'm trying to export a Python Dataframe to excel using xlsx or csv...

Here is the code I tried to use:

    export_word_count = word_count.to_excel (r'C:\Users\OTR\PycharmProjects\MyProjects\word_count.xlsx', index = None, header=True)

I keep getting the following error messages:

Traceback (most recent call last):
File "C:/Users/OTR/PycharmProjects/MyProjects/CAP_Test_MotsCles.py", line 35, 
in <module>
export_word_count = word_count.to_excel 
(r'C:\Users\OTR\PycharmProjects\MyProjects\word_count_CAP.xlsx', index = None, 
header=True)
File "C:\Users\OTR\PycharmProjects\MyProjects\venv\lib\site- 
packages\pandas\core\generic.py", line 2127, in to_excel
engine=engine)
File "C:\Users\OTR\PycharmProjects\MyProjects\venv\lib\site-packages\pandas\io\formats\excel.py", line 656, in write
writer = ExcelWriter(_stringify_path(writer), engine=engine)
File "C:\Users\OTR\PycharmProjects\MyProjects\venv\lib\site-packages\pandas\io\excel.py", line 1204, in __init__
from openpyxl.workbook import Workbook
ModuleNotFoundError: No module named 'openpyxl'

Any output on this would be greatly appreciated. I tried to tweek the code, but still wouldn't export. Thank you.

EDIT:

Managed to export, but having issues with full data export

Sample Python Data:

products          58
company           53
cannabis          42
business          39

There is something wrong with your installation, which seems to be missing the openpyxl library. Try installing it separately. To export it via a csv, use df.to_csv(). — Niels Henkens
– Niels Henkens, Commented May 14, 2019 at 19:32

Klemen Koleša · Accepted Answer · 2019-05-14 19:27:27Z

1

You dont have python openpyxl module installed. Install it with:

pip install openpyxl

answered May 14, 2019 at 19:27

Klemen Koleša

4563 silver badges6 bronze badges

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

5 Comments

OnThaRise Over a year ago

I just did, it managed to export. However, my export is a list of most commun words in my dataframe. It only exported the frequency of the words, without the words themselves. So for example, I get : products 58 company 53 ........ but in excel, I get 58 53.

Klemen Koleša Over a year ago

Can you please provide sample of dataframe that you want to export ?

Niels Henkens Over a year ago

The words themselves are probably your index. So instead remove the argument ‘index = None’.

OnThaRise Over a year ago

Klemen, I've provided a sample, but Niels Henkens provided me with the right answer. Thank you all so much for your answers! It did work at last :) It was the index = None that was removing the words.

ToddEmon Over a year ago

For those who use the conda distribution (Anaconda or Miniconda), the equivalent is writing in the Anaconda Prompt conda install openpyxl

Niels Henkens · Accepted Answer · 2019-05-14 19:41:51Z

0

Your words are your index. Right now you are not exporting the index. Try changing your code to:

word_count.to_excel (r'C:\Users\OTR\PycharmProjects\MyProjects\word_count.xlsx', index =True, header=True)

‘index=True’ is the default behavior, so not actually necessary.

answered May 14, 2019 at 19:41

Niels Henkens

2,7161 gold badge14 silver badges29 bronze badges

Collectives™ on Stack Overflow

Export Python Dataframe to Excel

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related