Verification table, demo data
Cleaning a 274,062-row database of dissolved companies
274,062rows checked by tax ID against the tax registry and DaData, dissolved ones removed
What the client received. Two files: 98,460 and 274,062 rows; in the second one 217,854 companies with a tax ID were checked and labelled. Delivered for 5,000 RUB.
Task and solution
Task. The company list exported from a directory was full of dissolved legal entities and closed sole proprietors: sales reps wasted time on clients that no longer exist.
Solution. Automatic status check of every company by tax ID against the tax registry and DaData, removal of dissolved ones, a daily automatic build of the result in Excel with a report to a Telegram bot. Both client files were processed end to end, no manual sorting.
- Python
- Tax registry
- DaData API
- openpyxl
- Telegram Bot API