From the course: Faster pandas

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Challenge: Join and query

Challenge: Join and query

From the course: Faster pandas

Start my 1-month free trial

Challenge: Join and query

“

(pleasant electronic music) - What is the median trip duration in 2017 only in active kiosks? The trip data is in the austin-bike.csv.xz, which has a trip ID membership and more information including the checkout kiosk ID and the return kiosk ID. The kiosk status is in the austin-kiosk.csv, which has the kiosk ID, the name, and the kiosk status.

Contents