Class 1 in-class exercise

Class 1 in-class exercise#

We’ll be doing calculations on 2021 Yellow Taxi Trips data. We’ll live-code this together.

Step 0#

The data needs to available on the machine where Python is running in order to process it, so let’s download from the NYC Open Data site directly:

!wget -O 2021_yello_taxi_trips.csv --no-verbose https://data.cityofnewyork.us/resource/m6nq-qud6.csv

2023-10-21 20:09:31 URL:https://data.cityofnewyork.us/resource/m6nq-qud6.csv [136065] -> "2021_yello_taxi_trips.csv" [1]

This is using a command-line program to do the downloading. We’ll download data ourselves manually later.

If you open the Files view in the sidebar of JupyterHub and refresh, you should see 2021_yello_taxi_trips.csv there.

Step 1#

Print out the trip distances.

# your code here

Step 2#

Calculate the average ride distance.

# your code here

Step 3#

Your turn! Calculate the percent of trips that were paid for by credit card. The data dictionary will be helpful - see the Attachment on the dataset page.

# your code here