optimization_validation_report.txt

================================================================================
OPTIMIZATION VALIDATION REPORT
Generated: 2025-07-07 14:38:13
================================================================================
Original data rows: 69786
Optimized data rows: 69786
Columns compared: 出力_科目, 出力_中科目, 出力_標準名称, 出力_項目名, 出力_標準単位

⚠️ 出力_科目: 11540 differences (83.46% accuracy)
   Sample differences (first 5):
   Row 578: '構内舗装' → '舗装'
   Row 579: '構内舗装' → '舗装'
   Row 580: '構内舗装' → '舗装'
   Row 581: '構内舗装' → '舗装'
   Row 582: '構内舗装' → '舗装'

⚠️ 出力_中科目: 22297 differences (68.05% accuracy)
   Sample differences (first 5):
   Row 10: '一般地業' → '地業'
   Row 20: '一般地業' → '地業'
   Row 25: '一般地業' → '地業'
   Row 32: '一般地業' → '地業'
   Row 40: '一般地業' → '地業'

⚠️ 出力_標準名称: 52740 differences (24.43% accuracy)
   Sample differences (first 5):
   Row 0: 'ｶﾞｰﾄﾞﾏﾝ' → '交通誘導員'
   Row 1: '化学物質の濃度測定' → '化学物質濃度測定'
   Row 3: 'くぐり戸' → '仮設門扉'
   Row 7: '笠木' → '壁付笠木'
   Row 8: '立上り水切' → '防水立上り押え部水切り'

⚠️ 出力_項目名: 54207 differences (22.32% accuracy)
   Sample differences (first 5):
   Row 0: 'ｶﾞｰﾄﾞﾏﾝ' → '交通誘導員'
   Row 1: '化学物質の濃度測定' → '化学物質濃度測定'
   Row 3: 'くぐり戸' → '仮設門扉'
   Row 7: '笠木' → '壁付笠木'
   Row 8: '立上り水切' → '防水立上り押え部水切り'

⚠️ 出力_標準単位: 40996 differences (41.25% accuracy)
   Sample differences (first 5):
   Row 2: 'm' → 'ｍ'
   Row 7: 'm' → 'ｍ'
   Row 8: 'm' → 'ｍ'
   Row 10: 'm2' → '㎡'
   Row 11: 'm' → 'ｍ'

================================================================================
OVERALL RESULTS:
Total differences: 181780
Overall accuracy: 47.9%
Perfect match: No
================================================================================