本分析数据集采用Kaggle的E-commerce data,数据导入部分详见此处:数据分析初阶——数据导入
数据结构分析
计算各字段空值(null)或空字符串('')数
SELECT
sum(CASE WHEN
id = '' OR id IS NULL THEN 1 ELSE 0 END) AS ID,
sum(CASE WHEN
InvoiceNo = '' OR InvoiceNo IS NULL THEN 1 ELSE 0 END) AS InvoiceNo,
sum(CASE WHEN
StockCode = '' OR StockCode IS NULL THEN 1 ELSE 0 END) AS StockCode,
sum(CASE WHEN
Description = '' OR Description IS NULL THEN 1 ELSE 0 END) AS Description,
sum(CASE WHEN
Quantity = '' OR Quantity IS NULL THEN 1 ELSE 0 END) AS Quantity,
sum(CASE WHEN
InvoiceDate = 0 OR InvoiceDate IS NULL THEN 1 ELSE 0 END) AS InvoiceDate,
sum(CASE WHEN
UnitPrice IS NULL THEN 1 ELSE 0 END) AS UnitPrice,
sum(CASE WHEN
CustomerID &