data:mysql_pandas
This is an old revision of the document!
how to get data into pandas dataframe in python
import matplotlib.pyplot as plt import pandas as pd import sqlalchemy as al engine = al.create_engine('mysql://system:[email protected]/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()
data/mysql_pandas.1520683866.txt.gz · Last modified: by aistis