How to convert mysql query in to dataframe

Question

How to convert my sql query to data frame

column names of PRODUCT data frame user_id,status,actual_cost,selling_price

Mysql query

SELECT user_id, count(*) as Count FROM PRODUCT WHERE status = 'SOLD' AND actual_cost>50 AND selling_price>60
group by user_id

Disclaimer. Please don't tell to use pymsql or pandassql since groupby is very large >50K rows, Data base wont have that TTL

ATL · Accepted Answer · 2019-12-31 06:59:54Z

1

Something like

PRODUCT.query("status == 'SOLD' 
    and actual_cost > 50 
    and selling_price > 60").groupby('user_id').size().reset_index(name='Count')

answered Dec 31, 2019 at 3:27

ATL

6015 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1