3.1 处理缺失值(填充)
#计算price列的均值
SELECT ROUND(AVG(price),2) AS avg_price
FROM data1;
#使用均值填充0值
UPDATE data1
SET price=2199.67
WHERE price=0;
3.2 清理空格
#清理字符中的空格
UPDATE data1
SET city=TRIM(city);
select city from data1;
3.3 数值修改及替换
#修改和替换
UPDATE data1
SET city=REPLACE(city,'SH','shanghai');
SELECT city FROM data1;
3.4 大小写转换
#大小写转换
UPDATE data1
SET city=LOWER(city);
select city from data1;