data:mysql_pandas
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()
kodas kad veiktu mysql, gali padeti naudojant anaconda distribucija nes ji turi jau sukompiliuotas bibliotekas
import pymysql pymysql.install_as_MySQLdb()
data/mysql_pandas.txt · Last modified: by aistis