Create a Python script for Excel to correct street addresses in a string to a unified format.
45 USD Processing Requirements
✅ Data Cleaning
- Remove unnecessary words:
поверх,парадне,пар. - Remove extra spaces and punctuation marks.
- Correct the case:
- Street Names — the first letter of each word should be uppercase.
- Type of street (
вул.,просп.,бульв., etc.) — always in lowercase.
- Convert letters after the house number to uppercase (
25а→25А). - If there is a
/and a letter after the house number (25/А), remove the/(25/А→25А). - If there is a
/and a number after the house number (7/15), leave it as is.
✅ Final Address Format
Example before processing:
АХМАТОВОЇ АННИ ВУЛ., 7/15,пар кв. 122пов24
Example after processing:
Ахматової Анни вул., 7/15, кв. 122
- Automatic processing of all lines without manual correction.
- Working with large files (10,000+ lines).
- Technologies used: Python (
pandas,re,openpyxl). - It is mandatory to test the finished work before submission!
💡 Result: All addresses in one style, readable and convenient for further work. 🚀
Applications 1
Client's review of cooperation with Danilo K.
Create a Python script for Excel to correct street addresses in a string to a unified format.Super fast! I plan to reach out again.. I also recommend!
Freelancer's review of cooperation with Alexfrance Espin
Create a Python script for Excel to correct street addresses in a string to a unified format.Great client. Provided everything necessary and responded quickly. I recommend for collaboration.
-
2 days34 USD
414 1 0 2 days34 USD
Hello, I will do it literally in a day or two, feel free to reach out!........
-
1 day34 USD
1850 46 3 1 day34 USD
Hello!
I have extensive experience working with various types of data and bulk processing (Openpyxl, RE, Pandas);
I will complete it within an hour, quickly and efficiently!
-
Winning proposal1 day45 USD
2264 82 1 2 Winning proposal1 day45 USD
Good evening, I am ready to provide you with the result within an hour or two. I can start now.
-
2 days34 USD
1314 37 0 2 days34 USD
Hello.
I look forward to collaborating.
****************************************************************************
-
2 days34 USD
792 9 1 2 days34 USD
Hello.
I will do it quickly and efficiently, I will provide the result within a day, and if necessary, we will make quick adjustments. I am currently available. I have the relevant experience. I am happy to discuss in private messages!
Current freelance projects in the category Data Parsing
Python / Network Engineer: Network optimization of the bot (WAF, Connection Pooling, Asyncio)Simplified version! Please respond only if you understand and are knowledgeable. About the project: An automated bot for sniping. The basic business logic (parsing, authorization, assembling JSON/XML packages) is already ready and works on Python. The target environment is Linux… Python, Data Parsing ∙ 9 hours 37 minutes back ∙ 14 proposals |
OpenCart — rental catalog of special equipment
135 USD
OpenCart — Equipment Rental Catalog Need to launch an equipment rental catalog on OpenCart. Theme: excavators cherry pickers forklifts generators cranes scaffolding other construction equipment. It is preferable that you already have a ready-made template or developments… Web Programming, Data Parsing ∙ 9 hours 46 minutes back ∙ 42 proposals |
Transfer the program - the server where the program was located has crashed (officially permitted parsing of government data)
47 USD
Hello! My client has encountered the case described below. We need help transferring to a new server and testing the program. It would be better to have a programmer who understands parsing. Software & Server Configuration, Data Parsing ∙ 13 hours 39 minutes back ∙ 22 proposals |
Parsing and classification of a large array of imagesIt is necessary to implement a project for collecting and structuring a large array of architectural images from open web sources.The task includes: automated collection of images; uploading files in the highest available quality; classification of images by categories:… Python, Data Parsing ∙ 14 hours 7 minutes back ∙ 30 proposals |
Parsing Resumes from Work.ua and Rabota.uaIt is necessary to download a database of current resumes from Work.ua and Rabota.ua in Excel format. It is preferable that the Excel file contains the following columns: Name Phone number (in the format +380...) Email Position (profession) Positions considered Category of… Information Gathering, Data Parsing ∙ 1 day 13 hours back ∙ 18 proposals |
Kyiv