Registry / data / pandas-access

pandas-access

JSON →
library0.0.1pypypiunverified

A tiny, subprocess-based tool for reading a MS Access database (.mdb/.accdb) as a Pandas DataFrame. Version 0.0.1. No recent updates; experimental and likely unmaintained.

datadatabase
pip install pandas-access
github ↗package ↗
INSTALL
IMPORT
SIG · PANDAS-ACCESS
P
pandas-access
datapythonv0.0.1
Install
2.4s avg
Import
—
Disk
17MB
Pass rate
10/ 10
Env Coverage10 / 10
glibc
3.9–3.13
musl
3.9–3.13
Install & Compatibility
Where this runs
tested against v0.0.1 · pip install
no network on importno background threads
Install × environment matrix
Each cell = how many times install + import succeeded across repeated harness runs. Partial = flaky.
glibc = Debian/Ubuntu slim · musl = Alpine Linux
musl
py 3.10–3.95 runs
installs and imports cleanly · install 0.0s · import 0.000s · 19.2MB
glibc
py 3.10–3.95 runs
installs and imports cleanly · install 2.4s · import 0.000s · 20MB
17MB installed
● package 17MB
Code
Verified usage

Verified import paths — ran on the pinned version, not inferred.

read_access
✓ from pandas_access import read_access
✗ import pandas_access
Importing pandas_access alone does not expose read_access; must import the function explicitly.

Read a table from a Microsoft Access database file into a pandas DataFrame. Requires the database file path and table name. Depends on mdbtools being installed on the system.

from pandas_access import read_access df = read_access('/path/to/database.mdb', table='my_table') print(df.head())
Debug
Known issues
deprecatedThis library is unmaintained and no longer recommended. It relies on subprocess calls to mdbtools, which may not be installed or available on all systems.
fix
Consider using pyodbc with the Microsoft Access ODBC driver on Windows, or mdbtools directly on Linux.
affects: all
breakingRequires external system dependency mdbtools. Not installed automatically; must be installed separately (e.g., apt-get install mdbtools on Debian/Ubuntu).
fix
Install mdbtools: on Linux: 'sudo apt-get install mdbtools'; on macOS: 'brew install mdbtools'; on Windows not supported.
affects: all
gotchaOnly works on Windows if mdbtools is installed via Cygwin or similar, which is non-trivial. Not natively compatible with Windows.
fix
Use pyodbc with MS Access ODBC driver on Windows instead of this library.
affects: all
Upgrade
Version history
0.0.1latest on PyPI · released Jun 7, 2016
Audit
Dependencies
pandasrequiredRequired for DataFrame output
Agent activity
6 hits · last 30 days
node
6
Resources
githubhttps://github.com/jbn/pandas_access ↗
packagehttps://pypi.org/project/pandas-access/ ↗
pandas-access — pip install pandas-access · libregistry