小组国内汽车销量分析 数据表清洗与处理部分

UPDATE car2m SET price = REPLACE(price, ' ', ''); UPDATE car2m SET name = REPLACE(name, ' ', ''); UPDATE car2m SET price = 0 WHERE price = '暂无报价'; UPDATE car2m SET price = CAST(REPLACE(SUBSTRING_INDEX(price, '-', 1), '万', '') AS DECIMAL(10, 2)); UPDATE suv2m SET price = REPLACE(price, ' ', ''); UPDATE suv2m SET name = REPLACE(name, ' ', ''); UPDATE suv2m SET price = 0 WHERE price = '暂无报价'; UPDATE suv2m SET price = CAST(REPLACE(SUBSTRING_INDEX(price, '-', 1), '万', '') AS DECIMAL(10, 2)); UPDATE mpv2m SET price = REPLACE(price, ' ', ''); UPDATE mpv2m SET name = REPLACE(name, ' ', ''); UPDATE mpv2m SET price = 0 WHERE price = '暂无报价'; UPDATE mpv2m SET price = CAST(REPLACE(SUBSTRING_INDEX(price, '-', 1), '万', '') AS DECIMAL(10, 2)); UPDATE car_pingfen SET price = CAST(REPLACE(SUBSTRING_INDEX(price, '-', 1), '万', '') AS DECIMAL(10, 2)); UPDATE cars_like SET price = 0 WHERE price = '暂无报价'; UPDATE cars_like SET price = CAST(REPLACE(SUBSTRING_INDEX(price, '-', 1), '万', '') AS DECIMAL(10, 2));