dfsql - SQL interface to Pandas.
Installation
pip install dfsql
Example
>>> import pandas as pd
>>> from dfsql import sql_query
>>> df = pd.DataFrame({
... "animal": ["cat", "dog", "cat", "dog"],
... "height": [23, 100, 25, 71]
... })
>>> df.head()
animal height
0 cat 23
1 dog 100
2 cat 25
3 dog 71
>>> sql_query("SELECT animal, height FROM animals_df WHERE height > 50", animals_df=df)
animal height
0 dog 100
1 dog 71
Quickstart/Tutorial
Head over to the testdrive notebook to see all available features.
Configuring Modin usage
dfsql supports executing queries using Modin for enchanced performance.
By default Modin will be used if it's installed.
To override this behavior and use Pandas set the USE_MODIN environment variable to False or 0 before importing dfsql:
(venv) user:~/mindsdb/dfsql$ export USE_MODIN=0
(venv) user:~/mindsdb/dfsql$ python
Python 3.8.5 (default, Jan 27 2021, 15:41:15)
[GCC 9.3.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import dfsql
>>> dfsql.config.Configuration.as_dict()
{'USE_MODIN': 0}