How to convert SQL select statement with particular fields and where clause to pandas dataframe

Question

I am trying to convert fallowing SQL statement into pandas dataframe in python

SELECT sum(money) from df where sex='female'

I am unable to get this in pandas

Thanks in advance

score 1 · Accepted Answer · answered Apr 06 '17 at 18:52

1

df.loc[df.sex=='female','money'].sum()

answered Apr 06 '17 at 18:52

Jay

1 Answers1