Batch Processing Excel Files and Importing Data into SQL Server with Python
Requirements Analysis
Excel data porcessing typically involves:
Converting Excel serial date numbers to standard date formats (e.g., 44567 → 2022/1/6)
Removing duplicates based on order IDs (SOID), keeping only the most recent records by date
Converting date strings with English month names to numeric formats (e.g., 06/Jan/2022 12:27 → 2022-1- ...
Posted on Fri, 08 May 2026 09:32:27 +0000 by m2babaey
Age Calculation from National ID Numbers in Hive
Age Calculation from National ID Numbers in Hive
In many enterprise applications, determining user age from national identification numbers is essential for compliance, age verification, and personalized services. This technical guide demonstrates how to implement age calculation from Chinese ID numbers using Hive SQL.
Understanding ID Number ...
Posted on Fri, 08 May 2026 04:02:33 +0000 by simonb