Read in an ODS file and return it as a pandas.DataFrame
Provides a function to read in an ODS file and returns a pandas DataFrame.
ezodf to read in the ods file. If a range is specified in the sheet
to be imported, it seems that
ezodf imports empty cells as well. Therefore,
completely empty rows and columns are dropped from the DataFrame, before it is
returned. Only trailing empty rows and columns are dropped.
If the ODS file contains duplicated column names, they will be numbered and the number is appended to the column name in the resulting DataFrame.
pip install pandas_ods_reader
from pandas_ods_reader import read_ods path = "path/to/file.ods" # load a sheet based on its index (1 based) sheet_idx = 1 df = read_ods(path, sheet_idx) # load a sheet based on its name sheet_name = "sheet1" df = read_ods(path, sheet_name) # load a file that does not contain a header row # if no columns are provided, they will be numbered df = read_ods(path, 1, headers=False) # load a file and provide custom column names # if headers is True (the default), the header row will be overwritten df = read_ods(path, 1, columns=["A", "B", "C"])
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
|Filename, size||File type||Python version||Upload date||Hashes|
|Filename, size pandas_ods_reader-0.0.7-py3-none-any.whl (7.1 kB)||File type Wheel||Python version py3||Upload date||Hashes View|
|Filename, size pandas_ods_reader-0.0.7.tar.gz (4.6 kB)||File type Source||Python version None||Upload date||Hashes View|
Hashes for pandas_ods_reader-0.0.7-py3-none-any.whl