Skip to main content

Read in .ods and .fods files and return a pandas.DataFrame.

Project description

pandas-ods-reader

Provides a function to read in a .ods or .fods file and returns a pandas DataFrame.

It uses ezodf to read in .ods files. Since .fods files are essentially xml, lxml is used to read them. The correct parser is automatically chosen based on the file's extension.

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.

Dependencies

  • ezodf
  • lxml
  • pandas

Installation

pip install pandas-ods-reader

Usage

from pandas_ods_reader import read_ods

path = "path/to/file.ods"

# by default the first sheet is imported
df = read_ods(path)

# load a sheet based on its index (1 based)
sheet_idx = 2
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"])

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pandas_ods_reader-1.0.2.tar.gz (5.3 kB view details)

Uploaded Source

Built Distribution

pandas_ods_reader-1.0.2-py3-none-any.whl (7.5 kB view details)

Uploaded Python 3

File details

Details for the file pandas_ods_reader-1.0.2.tar.gz.

File metadata

  • Download URL: pandas_ods_reader-1.0.2.tar.gz
  • Upload date:
  • Size: 5.3 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/2.1.2 CPython/3.12.7 Linux/6.12.25_1

File hashes

Hashes for pandas_ods_reader-1.0.2.tar.gz
Algorithm Hash digest
SHA256 dc414120e28e72a509b163d6d10a04d06e2ce343095fa1adf8e4a6606f383ec4
MD5 5d3142d9bb0b9ccf90103cbb03ef0cb0
BLAKE2b-256 e0de14e25051b1c60690f1400b40519ccee5c16b8f868e3be7185d40637b1f9c

See more details on using hashes here.

File details

Details for the file pandas_ods_reader-1.0.2-py3-none-any.whl.

File metadata

  • Download URL: pandas_ods_reader-1.0.2-py3-none-any.whl
  • Upload date:
  • Size: 7.5 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/2.1.2 CPython/3.12.7 Linux/6.12.25_1

File hashes

Hashes for pandas_ods_reader-1.0.2-py3-none-any.whl
Algorithm Hash digest
SHA256 3e2e4a58ddb423b3c4ae64880edbf5ae72ea5f2ffffadfaf4af76dd182774a08
MD5 64736c27669d5bf4d9319cb2a0913c50
BLAKE2b-256 85d95474a94729a9f0c3e6f020cbfdf919624f6c329992ef871b6f2289d3a902

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page