Call Detail Record Analyzer «MINUTKA»

An application for automated analysis of call detail records supplied as spreadsheets (Excel). It cuts data processing time from hours to seconds.

Key features:

• Call analysis: duration totals, first/last contact detection
• Grouping by base stations with geographic data
• Comparison of phone number lists across files
• Export to Excel with automatic formatting

Technologies:

Python, pandas, openpyxl, numpy

Result:

File processing time reduced from 3–4 hours to 2–3 minutes.