2025-04-16 00:13:35 - INFO - Loading CIQ and IBES datasets...
2025-04-16 00:13:35 - INFO - Loaded CIQ dataset with 1095149 rows.
2025-04-16 00:13:35 - INFO - Loading CIQ and IBES datasets...
2025-04-16 00:13:37 - INFO - Loaded IBES dataset with 933825 rows.
2025-04-16 00:13:37 - INFO - Testing name parsing functions with sample names.
2025-04-16 00:13:37 - INFO - Error processing CIQ name 'Jason L.;Loews Corporation;Analyst': list index out of range
2025-04-16 00:13:37 - INFO - Error processing CIQ name 'Jason L.;Loews Corporation;Analyst': list index out of range
2025-04-16 00:13:37 - INFO - CIQ test names (last names): ['BRAND', 'POPESCU', 'FRISCH', 'DIJINSON', 'WACHTEL', 'ONEIL', 'JOHN', 'GULLEY', 'JUVEKAR', 'FORKIN', 'AMBRECHT', 'ESSI', 'BAILEY', 'MCALLISTER', 'NADOL', 'GRUBELICH', 'MCCARTHY', 'VANRHEE', 'MAIDEN', 'YURNING', 'DEPAOLI', 'SMITH', 'OCALLAGHAN', 'OSULLIVAN', 'SHELTON', 'CABRERA', 'ELRADJAKOBY', 'PENALA', 'DITULLIO', 'OPERATOR', 'VN', 'TREMBOVOLSKY', 'WANG', 'WIDJAJA', 'LATE', 'VANDENBROEK', 'Error']
2025-04-16 00:13:37 - INFO - IBES test names: [('PRICE', 'PRICE'), ('GARCIACANTER', ''), ('DEVERTEUIL', ''), ('DEATHERAGE', 'MASSICK'), ('BOSSHARD', ''), ('MCALENNEY', ''), ('WELLS', ''), ('NICKLIN', ''), ('LEISURETOURI', ''), ('HUNTERBYRNE', ''), ('WOLFENBERGER', ''), ('VANDENBROEK', ''), ('YOUNG', 'C. BARN'), ('OBRIEN', ''), ('WARNERWILKE', ''), ('MOUSSATOS', '')]
2025-04-16 00:13:37 - INFO - Extracting names from CIQ and IBES datasets...
2025-04-16 00:13:54 - INFO - Error processing CIQ name 'Jason L.;Loews Corporation;Analyst': list index out of range
2025-04-16 00:13:55 - INFO - Error processing CIQ name 'Ramesh L.;Nirmal Bang;Manager Sales': list index out of range
2025-04-16 00:14:11 - INFO - Writing formatted name files to CSV...
2025-04-16 00:14:24 - INFO - CIQ column lengths:
2025-04-16 00:14:24 - INFO - IBES column lengths:
2025-04-16 00:14:25 - INFO - Number of CIQ names that failed to parse: 2
2025-04-16 00:14:25 - INFO - Number of IBES names that failed to parse: 0
2025-04-16 00:14:25 - INFO - Total runtime: 00:00:49
