In [2]:

    

import pandas as pd
import numpy as np
import seaborn as sns


    

In [3]:

    

%matplotlib notebook
df = pd.DataFrame.from_dict(dict(x=np.random.rand(1200)))
df.plot();


    

In [4]:

    

import odo


    

In [10]:

    

!pip uninstall psycopg2


    

    




Uninstalling psycopg2-2.6.1:
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2-2.6.1-py3.4.egg-info
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/__init__.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/__pycache__/__init__.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/__pycache__/_json.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/__pycache__/_range.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/__pycache__/errorcodes.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/__pycache__/extensions.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/__pycache__/extras.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/__pycache__/pool.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/__pycache__/psycopg1.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/__pycache__/tz.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/_json.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/_psycopg.so
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/_range.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/errorcodes.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/extensions.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/extras.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/pool.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/psycopg1.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__init__.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/__init__.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/dbapi20.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/dbapi20_tpc.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_async.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_bugX000.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_bug_gc.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_cancel.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_connection.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_copy.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_cursor.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_dates.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_extras_dictcursor.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_green.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_lobject.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_module.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_notify.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_psycopg2_dbapi20.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_quote.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_transaction.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_types_basic.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_types_extras.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/test_with.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/testconfig.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/__pycache__/testutils.cpython-34.pyc
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/dbapi20.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/dbapi20_tpc.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_async.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_bugX000.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_bug_gc.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_cancel.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_connection.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_copy.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_cursor.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_dates.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_extras_dictcursor.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_green.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_lobject.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_module.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_notify.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_psycopg2_dbapi20.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_quote.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_transaction.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_types_basic.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_types_extras.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/test_with.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/testconfig.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tests/testutils.py
  /usr/local/anaconda/lib/python3.4/site-packages/psycopg2/tz.py
Proceed (y/n)? ^COperation cancelled by user

In [12]:

    

# odo.odo(df, 'postgresql://localhost::aaaa')
odo.odo('../../osqf2015/data/db.bcolz/', 'postgresql://localhost::risk_factors')


    

    
Out[12]:





Table('risk_factors', MetaData(bind=Engine(postgresql://localhost)), Column('Open', Float(precision=53), table=<risk_factors>, nullable=False), Column('High', Float(precision=53), table=<risk_factors>, nullable=False), Column('Low', Float(precision=53), table=<risk_factors>, nullable=False), Column('Close', Float(precision=53), table=<risk_factors>, nullable=False), Column('Volume', Float(precision=53), table=<risk_factors>, nullable=False), Column('Dividend', Float(precision=53), table=<risk_factors>, nullable=False), Column('Split', Float(precision=53), table=<risk_factors>, nullable=False), Column('Adj_Open', Float(precision=53), table=<risk_factors>, nullable=False), Column('Adj_High', Float(precision=53), table=<risk_factors>, nullable=False), Column('Adj_Low', Float(precision=53), table=<risk_factors>, nullable=False), Column('Adj_Close', Float(precision=53), table=<risk_factors>, nullable=False), Column('Adj_Volume', Float(precision=53), table=<risk_factors>, nullable=False), schema=None)