- baresql improves sql agility of python data science beginners by :
allowing sql over python objects (list, ranges, …) and SQL Tables,
requiring no special module except : pandas.
Inspiration :
pypi.python.org/pypi/pandasql : sqldf for pandas
pypi.python.org/pypi/ipython-sql : sql magic in Ipython
Features
query lists , tuple, dictionnaries, dataframes
result as a dataframe, list of records, or list
basic Common Table Expression support on old python3.3- versions
Installation
You can install, upgrade, uninstall sqlite_bro.py with these commands:
$ pip install baresql $ pip install --upgrade baresql $ pip uninstall baresql
or just launch it from IPython with %load https://raw.githubusercontent.com/stonebig/baresql/master/baresql/baresql.py
Basic Example
from __future__ import print_function, unicode_literals, division # if Python2.7 from baresql import baresql bsql = baresql.baresql(keep_log = True ) bsqldf = lambda q: bsql.df(q, dict(globals(),**locals())) users = ['Alexander', 'Bernard', 'Charly', 'Danielle', 'Esmeralda', 'Franz'] # We use the python 'users' list like a SQL table sql = "select 'Welcome ! ' , c0 from users$$" bsqldf(sql)
Examples
http://nbviewer.ipython.org/github/stonebig/baresql/blob/master/examples/baresql_with_cte.ipynb
Links
1 maintainer
Metadata
1 maintainer
Release files for baresql 1.0.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| baresql-1.0.0.tar.gz | 14.6 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| baresql-1.0.0-py2.py3-none-any.whl | Python 3, Python 2 | none | any | Details |
Total release size: 24.9 kB
Release files / baresql-1.0.0.tar.gz
| Download URL | baresql-1.0.0.tar.gz |
|---|---|
| Size | 14.6 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
88f9659e767fcf3d59667ed0667407b22e2a76a36e40ba66928bd5a378f555e9
|
|
BLAKE2b-256 checksum How to use checksums |
e981f437e6527f51d18ce229b92d694b502372aee10eb6261ede0740d48520fb
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.0.1 CPython/3.12.9
|
Release files / baresql-1.0.0-py2.py3-none-any.whl
| Download URL | baresql-1.0.0-py2.py3-none-any.whl |
|---|---|
| Size | 10.2 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
a24d17f46beb47c221f328f7e06710e3896c6203a8e1909788d7128f27b86f01
|
|
BLAKE2b-256 checksum How to use checksums |
d6d2fe24bcd99d97bddbbccdf191edf4e84c0fdfe894dfff9f54b05f36096ebb
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.0.1 CPython/3.12.9
|
