From 65bb71c5a7d3ee60edc2cc33c6608ab8add0fdce Mon Sep 17 00:00:00 2001 From: CoprDistGit Date: Mon, 10 Apr 2023 17:19:22 +0000 Subject: automatic import of python-pandas-access --- .gitignore | 1 + python-pandas-access.spec | 216 ++++++++++++++++++++++++++++++++++++++++++++++ sources | 1 + 3 files changed, 218 insertions(+) create mode 100644 python-pandas-access.spec create mode 100644 sources diff --git a/.gitignore b/.gitignore index e69de29..fcc92a3 100644 --- a/.gitignore +++ b/.gitignore @@ -0,0 +1 @@ +/pandas_access-0.0.1.tar.gz diff --git a/python-pandas-access.spec b/python-pandas-access.spec new file mode 100644 index 0000000..b383f12 --- /dev/null +++ b/python-pandas-access.spec @@ -0,0 +1,216 @@ +%global _empty_manifest_terminate_build 0 +Name: python-pandas_access +Version: 0.0.1 +Release: 1 +Summary: A tiny, subprocess-based tool for reading a MS Access database(.rdb) as a Pandas DataFrame. +License: License :: OSI Approved :: MIT License +URL: https://github.com/jbn/pandas_access +Source0: https://mirrors.nju.edu.cn/pypi/web/packages/04/5d/019eb5f99b8d5ebee3e1e8f046482fd5b7c35ba2d02b8e8553798d01cfe9/pandas_access-0.0.1.tar.gz +BuildArch: noarch + + +%description +# What is this? + +A tiny, `subprocess`-based tool for reading a +[MS Access](https://products.office.com/en-us/access) +database (`.rdb`) as a [Pandas](http://pandas.pydata.org/) +[DataFrame](http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.html). + +## Installation + +To read the database, this package (thinly!) wraps +[MDBTools](http://mdbtools.sourceforge.net/). Since I assume you're already +using Pandas, it should be your only installation requirement. + +If you are on `OSX`, install it via [Homebrew](http://brew.sh/): + +```sh +$ brew install mdbtools +``` +Then, do, +```sh +$ pip install pandas_access +``` + +## Usage + +```python +import pandas_access as mdb + +# Listing the tables. +for tbl in mdb.list_tables("my.mdb"): + print(tbl) + +# Read a small table. +df = pandas_access.read_table("my.mdb", "MyTable") + +# Read a huge table. +accumulator = [] +for chunk in pandas_access.read_table("my.mdb", "MyTable", chunksize=10000): + accumulator.append(f(chunk)) +``` + +If you need more power than this, see: +[pyodbc](https://github.com/mkleehammer/pyodbc). + +## Testing + +I needed this code in a quick pinch -- I had no access to MS Access, and I had +a single `.mdb` file. If someone with Access would like to create a tiny +database for unit-testing purposes, I'd be much obliged. + +%package -n python3-pandas_access +Summary: A tiny, subprocess-based tool for reading a MS Access database(.rdb) as a Pandas DataFrame. +Provides: python-pandas_access +BuildRequires: python3-devel +BuildRequires: python3-setuptools +BuildRequires: python3-pip +%description -n python3-pandas_access +# What is this? + +A tiny, `subprocess`-based tool for reading a +[MS Access](https://products.office.com/en-us/access) +database (`.rdb`) as a [Pandas](http://pandas.pydata.org/) +[DataFrame](http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.html). + +## Installation + +To read the database, this package (thinly!) wraps +[MDBTools](http://mdbtools.sourceforge.net/). Since I assume you're already +using Pandas, it should be your only installation requirement. + +If you are on `OSX`, install it via [Homebrew](http://brew.sh/): + +```sh +$ brew install mdbtools +``` +Then, do, +```sh +$ pip install pandas_access +``` + +## Usage + +```python +import pandas_access as mdb + +# Listing the tables. +for tbl in mdb.list_tables("my.mdb"): + print(tbl) + +# Read a small table. +df = pandas_access.read_table("my.mdb", "MyTable") + +# Read a huge table. +accumulator = [] +for chunk in pandas_access.read_table("my.mdb", "MyTable", chunksize=10000): + accumulator.append(f(chunk)) +``` + +If you need more power than this, see: +[pyodbc](https://github.com/mkleehammer/pyodbc). + +## Testing + +I needed this code in a quick pinch -- I had no access to MS Access, and I had +a single `.mdb` file. If someone with Access would like to create a tiny +database for unit-testing purposes, I'd be much obliged. + +%package help +Summary: Development documents and examples for pandas_access +Provides: python3-pandas_access-doc +%description help +# What is this? + +A tiny, `subprocess`-based tool for reading a +[MS Access](https://products.office.com/en-us/access) +database (`.rdb`) as a [Pandas](http://pandas.pydata.org/) +[DataFrame](http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.html). + +## Installation + +To read the database, this package (thinly!) wraps +[MDBTools](http://mdbtools.sourceforge.net/). Since I assume you're already +using Pandas, it should be your only installation requirement. + +If you are on `OSX`, install it via [Homebrew](http://brew.sh/): + +```sh +$ brew install mdbtools +``` +Then, do, +```sh +$ pip install pandas_access +``` + +## Usage + +```python +import pandas_access as mdb + +# Listing the tables. +for tbl in mdb.list_tables("my.mdb"): + print(tbl) + +# Read a small table. +df = pandas_access.read_table("my.mdb", "MyTable") + +# Read a huge table. +accumulator = [] +for chunk in pandas_access.read_table("my.mdb", "MyTable", chunksize=10000): + accumulator.append(f(chunk)) +``` + +If you need more power than this, see: +[pyodbc](https://github.com/mkleehammer/pyodbc). + +## Testing + +I needed this code in a quick pinch -- I had no access to MS Access, and I had +a single `.mdb` file. If someone with Access would like to create a tiny +database for unit-testing purposes, I'd be much obliged. + +%prep +%autosetup -n pandas_access-0.0.1 + +%build +%py3_build + +%install +%py3_install +install -d -m755 %{buildroot}/%{_pkgdocdir} +if [ -d doc ]; then cp -arf doc %{buildroot}/%{_pkgdocdir}; fi +if [ -d docs ]; then cp -arf docs %{buildroot}/%{_pkgdocdir}; fi +if [ -d example ]; then cp -arf example %{buildroot}/%{_pkgdocdir}; fi +if [ -d examples ]; then cp -arf examples %{buildroot}/%{_pkgdocdir}; fi +pushd %{buildroot} +if [ -d usr/lib ]; then + find usr/lib -type f -printf "/%h/%f\n" >> filelist.lst +fi +if [ -d usr/lib64 ]; then + find usr/lib64 -type f -printf "/%h/%f\n" >> filelist.lst +fi +if [ -d usr/bin ]; then + find usr/bin -type f -printf "/%h/%f\n" >> filelist.lst +fi +if [ -d usr/sbin ]; then + find usr/sbin -type f -printf "/%h/%f\n" >> filelist.lst +fi +touch doclist.lst +if [ -d usr/share/man ]; then + find usr/share/man -type f -printf "/%h/%f.gz\n" >> doclist.lst +fi +popd +mv %{buildroot}/filelist.lst . +mv %{buildroot}/doclist.lst . + +%files -n python3-pandas_access -f filelist.lst +%dir %{python3_sitelib}/* + +%files help -f doclist.lst +%{_docdir}/* + +%changelog +* Mon Apr 10 2023 Python_Bot - 0.0.1-1 +- Package Spec generated diff --git a/sources b/sources new file mode 100644 index 0000000..731f68c --- /dev/null +++ b/sources @@ -0,0 +1 @@ +82e333b28e9a4bd4af96763c7ccd882b pandas_access-0.0.1.tar.gz -- cgit v1.2.3