Session Ready
Exercise

Use EDA to find impossible scenarios

Calculate how many YellowTripData records have each type of error discovered during EDA.

Instructions
100 XP
  • Use CASE and COUNT to understand how many records contain the following errors:
  • DropOffDate before PickupDate, DropOffDate before today, PickupDate before today, TripDistance is zero.