3 ms·
You mean something like SELECT origin, dest, month, AVG(arr_delay), AVG(dep_delay) FROM flights WHERE carrier == 'AA' GROUP BY origin, dest
by kgwgk 5y ago
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 5y agoYep thanks, you can tell I use a "guess and check" approach to writing sql and pandas...