https://wiki.raudys.com/ 2026-11-02T02:42:47+00:00 https://wiki.raudys.com/ https://wiki.raudys.com/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2018-07-18T06:22:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.raudys.com/doku.php?id=data:mysql_pandas&rev=1531894926&do=diff 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: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() text/html 2018-03-12T14:41:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.raudys.com/doku.php?id=data:pandas_groupby&rev=1520865666&do=diff how to group dataframe by date on multiple cplumns df1 = a.groupby(['date'])['price'].agg(['first','max', 'min', 'last']) df2 = a.groupby(['date'])['volume'].agg(['sum']) df3 = pd.concat([df1, df2[['sum']]], axis=1) df3.head() df3a = a.groupby('date').agg({'price': ['first','max', 'min', 'last'],'volume': ['sum']}) text/html 2018-03-10T12:05:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.raudys.com/doku.php?id=data:start&rev=1520683535&do=diff data analysis with python