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 days33 USD
414 1 0 2 days33 USD
Hello, I will do it literally in a day or two, feel free to reach out!........
-
1 day33 USD
1831 46 3 1 day33 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
2240 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 days33 USD
1312 37 0 2 days33 USD
Hello.
I look forward to collaborating.
****************************************************************************
-
2 days33 USD
792 9 1 2 days33 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
A specialist in Telegram promotion is required.
29 USD
Tasks: invite real users from the username database to new chats and send messages to the target database. Only quality traffic and work with a live audience are of interest — performers using bots, fake engagement, or low-quality methods are requested NOT TO DISTURB. Work… Data Parsing, Social Media Marketing (SMM) ∙ 3 days 20 hours back ∙ 8 proposals |
Collection of B2B database of companies in Germany
40 USD
Goal: To obtain a list of potential employers (clients) for B2B mailing. Region: Munich (München) + radius of 50 km. Required niches: Construction companies (Bauunternehmen) Food enterprises (Lebensmittelhersteller, meat processing plants, bakeries) Logistics and… Data Parsing, Lead Generation & Sales ∙ 3 days 23 hours back ∙ 34 proposals |
Consultation on parsing Instagram account subscribersHello. It is necessary to conduct a preliminary assessment of the feasibility of the following task. I have a list of Instagram accounts. The goal is to obtain contact information (primarily email addresses) of users who follow these accounts. Previously, I encountered companies… Data Parsing ∙ 7 days 15 hours back ∙ 13 proposals |
A specialist is needed to find contacts of decision-makers in Ukraine.It is necessary to gather a database (or ready database) of contacts of decision-makers (DMs) in companies in Ukraine. Information Gathering, Data Parsing ∙ 7 days 20 hours back ∙ 21 proposals |
Need to scrape data from LinkedIn
We need to scrape data from LinkedIn based on our list. For each entry, we need to find and collect available data if it exists on the LinkedIn profile, including the profile picture on the LinkedIn social network, email address, links to social media, company website, and… Data Parsing ∙ 8 days 2 hours back ∙ 28 proposals |
Kyiv