Python Data Analysis

Pony ORM

Pony ORM is another Python ORM package. Pony ORM is written in pure Python and has automatic query optimization and a GUI database schema editor. It also supports automatic transaction management, automatic caching, and composite keys. Pony ORM uses Python generator expressions, which are translated in SQL. Install it as follows:

$ sudo pip install pony
$ pip freeze|grep pony
pony==0.5.1

Import the packages we will need in this example. Refer to the pony_ride.py file in this book's code bundle:

from pony.orm import Database, db_session 
from pandas.io.sql import write_frame
import statsmodels.api as sm

Create an in-memory SQLite database:

db = Database('sqlite', ':memory:')

Load the sunspots data and write it to the database with the pandas ...