/sql_vs_pandas

A comparison of SQL vs pandas for speed and scaling

Primary LanguageJupyter NotebookApache License 2.0Apache-2.0

This code runs a basic comparison of sqlite and pandas.

To install, please run

pip install -r requirements.txt

You will need pandas installed (which usually can't be installed from pip. Consider using conda).

To run the file, run

./driver.sh results/run1

to output the results. More results can be found in memory.sh.

An ipython notebook analysis can be found in the folder analysis.