You mean something like SELECT origin, dest, month, AVG(arr_delay), AVG(dep_dela... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

kgwgk on Jan 16, 2022 | parent | context | favorite | on: Statistical Rethinking (2022 Edition)

You mean something like

    SELECT
    origin, dest, month, AVG(arr_delay), AVG(dep_delay)
    FROM flights
    WHERE carrier == 'AA'
    GROUP BY origin, dest, month

and

    flights[flights.carrier == 'AA'].groupby(['origin', 'dest', 'month'])[['arr_delay', 'dep_delay']].mean()

bckygldstn on Jan 16, 2022 [–]

Yep thanks, you can tell I use a "guess and check" approach to writing sql and pandas...

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact