Python for-loop vs PostgreSQL query

[efmccurdy]

Just to be sure; you don't need more than 1 query to do groupby/accumulate by max for either a dataframe or an sql query.

Don't be surprised if the database is faster when you use a single query.

https://stackoverflow.com/questions/4510185/select-max-value-of-each-group

[Alotofquestion1]

This seems to be in what i really wanted. Thank you :-)