Recap: Car Listings

A used car site preps listings for a price model. listings.csv has fuel, condition (fair, good, excellent), km and price. The program reads a fuel.

1. Add condition_score: fair 1, good 2, excellent 3.
2. Add mileage: low up to 50000 km, mid up to 120000, high up to 300000.
3. One-hot encode fuel into cars (dtype=int).
4. Print the shape, cars per mileage band, and the read fuel's count, mean price and mean condition (2 decimals).

Five other listings become this table:

With the input hybrid, they print:

Shape: (5, 8)
mileage
low     1
mid     3
high    1
Name: count, dtype: int64
hybrid listings: 3
Mean price: 10500.0
Mean condition: 2.0