Storing pandas DataFrames in SQLAlchemy models Storing pandas DataFrames in SQLAlchemy models flask flask

Storing pandas DataFrames in SQLAlchemy models


Go towards the JSON and PostgreSQL solution. I am on a Pandas project that started with the Pickle on file system, and loaded the data into to an class object for the data processing with pandas. However, as the data became large, we played with SQLAlchemy / SQLite3. Now, we are finding that working with SQLAlchemy / PostgreSQL is even better. I think our next step will be JSON.Have fun! Pandas rocks!