Zip Code Correction and Addition

Job ID: 38688422

Budget: $10 – $30 USD

I have an Excel file containing around 10,000 addresses with both missing and incorrect zip codes. I need a professional to either correct or append the appropriate zip codes using automated geocoding techniques.

The available information is:
- facility name
- street address
- city (not available for all)
- state

Therefore the search criteria should include facility name to easily find the zipcode.

Your tasks will include:
- Utilizing Python or APIs like Google Geocoding API or OpenStreetMap's Nominatim API to process the addresses
- Running the Python code provided by me
- Using your Google Geocoding API key

Ideal candidates should have:
- Proficiency in Python and experience with geocoding APIs
- Ability to work with Excel files and handle large datasets
- Attention to detail to ensure accuracy in zip code correction and addition

If you can find the zipcodes of 10,000 addresses using another automated method, feel free to bid and describe your technique in the bid.