A library for reading tables from an Access database into Polars dataframes, using mdbtools
Project description
polars_access_mdbtools
A library for reading tables from an Access database into Polars dataframes, using mdbtools
What is this?
A tiny, subprocess
-based tool for reading a
MS Access
database (.rdb
) as a Python Polars Dataframe.
Installation
To read the database, this package thinly wraps MDBTools.
If you are on OSX
, install it via Homebrew:
$ brew install mdbtools
If you are on Debian
, install it via apt:
$ sudo apt install mdbtools
If you are on Windows
, it's a little tougher. Install mdbtools
for Windows. Manually add to PATH.
- Download the mdb-tools files from Windows link above. Visit the Releases section, then downloadi the part that says "Source Code (zip)".
- Extract that to somewhere like
C:/bin/mdbtools-win/mdbtools-win-1.0.0
. - Follow these instructions to add that folder to your environment path (Method 1, but use the path to the mdbtools executable files).
- Restart your computer or just close and re-open the program you're running it from. You can test that it works by opening a terminal and running
mdb-tables --help
and see that it doesn't fail.
Finally, on all OS's:
$ pip install polars_access_mdbtools
Example Usage
import polars as pl
import polars_access_mdbtools as pl_access
file_path = 'path_to_file.mdb'
pl_access.list_table_names(file_path)
df = pl_access.read_table(file_path, table_name='your_table_name')
Acknowledgements
This code is based heavily on jbn's pandas_access
library.
To Do
- unit tests
- better error messages when subsections (e.g., schema fetching) fail
Contributing
Please Star this repo.
Please submit bug reports as GitHub Issues. Feel free to submit a PR to fix an issue!
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for polars_access_mdbtools-0.0.2.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2cef4bd829fb77e33ad96cfb1c683312cf1f00efe42fcdd2fd4af3a551d111ef |
|
MD5 | cdf3714ad63f38da2ac83ce5ec3243e7 |
|
BLAKE2b-256 | 87ddd341212504e6f0d79b5298538b7af21ec0b43f90d63e97839be9d486e878 |
Hashes for polars_access_mdbtools-0.0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f1898df17389efc0631eeca184b99dd6eb0f0f7bd5323459cecce10c773fb360 |
|
MD5 | a5dbfca2cfecda3527ac1ad3440305be |
|
BLAKE2b-256 | fe4fd28ac26328b4efe659214c3490c03c6e313f039afa2d9f2d3d8994c91b90 |