agude
commented
3 years ago This should be easy to fix by adding a mapping in value_maps.py and then adding that map to the vehicle_make row.
Closed agude closed 3 years ago
agude
commented
3 years ago This should be easy to fix by adding a mapping in value_maps.py and then adding that map to the vehicle_make row.
agude
commented
3 years ago Here is the list of makes and the count of how many times they appear (unique entries removed to meat the character limit):
agude
commented
3 years ago Here is the following query:
SELECT vehicle_make, count(1) as make_count
FROM parties
GROUP BY 1
HAVING make_count > 5
ORDER BY 1 ASC, 2 DESC
For example
HARLEY-DAVIDSONshows up asHARL,HD,HARLE,HARLEY DAVIDSON,HARLEY D,HARLEY-D, andHARLEY.There should be one and only one string for each manufacturer.