CODEWITHSUNDEEP
pythonpython-3.xpandas
Tejus Shama
Tejus Shama

Reputation: 1

Pandas and Spreadsheet

I am using ubuntu and as a result unable to use ms excel.Anyways I have created a spread sheet and I wish to make use of it in my python program. Following is the Python program.

import pandas as pd

df=pd.read_excel("/home/files/file1.ods")

df.head()

Traceback (most recent call last):
File "spreadsheet.py", line 2, in <module>
  df=pd.read_excel("/home/files/file1.ods")
File "/usr/lib/python3/dist-packages/pandas/io/excel.py", line 163, in    read_excel
  io = ExcelFile(io, engine=engine)
File "/usr/lib/python3/dist-packages/pandas/io/excel.py", line 187, in __init__
  import xlrd  # throw an ImportError if we need to
ImportError: No module named 'xlrd'

Does it mean that I have to use ms excel or is there an error in my understanding.Whatever be the case your help will be highly appreciated.

Upvotes: 0

Views: 1267

Answers (1)

CPBL
CPBL

Reputation: 4030

In recent versions (since 0.25) of Pandas, this feature is provided.

Just install the odfpy package (with pip install odfpy or etc) and then use pandas' (sadly) read_excel() function with the engine='odf' option. For example:

pd.read_excel('path_to_file.ods', engine='odf')

See https://pandas.pydata.org/pandas-docs/stable/user_guide/io.html#opendocument-spreadsheets.

Upvotes: 1

Related Questions