#!/usr/bin/env python2.7
# -*- coding: utf-8 -*-

import psycopg2
import pandas as pd

DBHOST = 'host'
DBNAME = 'db'
DBPORT = 'port'
DBUSER = 'user'
DBPWD = 'pwd'

# Setup database connexion
con = psycopg2.connect(
        dbname = DBNAME,
        host = DBHOST,
        port = DBPORT,
        user = DBUSER,
        password = DBPWD)
cur = con.cursor()

# Query database
cur.execute("SELECT * FROM chi_tebla;")
d = cur.fetchall()
df = pd.DataFrame(d)

# Close connexion
cur.close()
con.close()

# TADAAAAAAAAAAAA !!!
df.describe()