how to get data into pandas dataframe in python

<code python>
import matplotlib.pyplot as plt
import pandas as pd
import sqlalchemy as al

engine = al.create_engine('mysql://system:xxx9@trd3.raudys.com/trading')
connection = engine.connect();

c = pd.read_sql(
    'select ts_to as date, sum(pnl) as pnl from rt_strat_profits_id_view where ts_to > 20100101 group by ts_to order by ts_to',
    con=connection);

c['cpnl'] = c.pnl.cumsum()
c.plot(x='date', y='cpnl', grid=True)
plt.show()


</code>

kodas kad veiktu mysql, gali padeti naudojant anaconda distribucija nes ji turi jau sukompiliuotas bibliotekas

<code python>
import pymysql
pymysql.install_as_MySQLdb()
</code>