python sqlite

# encoding=utf-8
import sqlite3
import pandas as pd

query = """
CREATE TABLE test
(
a VARCHAR(20),
b VARCHAR(20),
c REAL ,
d INTEGER 
);
"""
con = sqlite3.connect(':memory')
con.execute(query)

data = [
    ('Atlanta', 'Georgia', 1.25, 6),
    ('Tallahassee', 'Florida', 2.6, 3),
    ('Sacramento', 'California', 1.7, 5)
]
stmt = "INSERT INTO test VALUES(?,?,?,?)"
con.executemany(stmt, data)
con.commit()

cursor = con.execute('SELECT * FROM test')
rows = cursor.fetchall()
print 'rows:=\n', rows
cursor
print 'cursor.description:=\n', cursor.description
pdData = pd.DataFrame(rows, columns=zip(*cursor.description)[0])
print 'pdData:=\n', pdData
import pandas.io.sql as sql
sql.read_sql('select * from test',con)


print 'test'