plzCrawler

Python command line tool which finds topographical addresses based on spreadsheet data and adds postal codes automatically

Version Date: 2021-07-01

pace: approximately 1 second/row

Live Usage (Sample Application)

149321073-ea311b45-3d7a-4d35-bcc9-80df0c651c82.mp4

Installation & Execution (English 🇺🇸 🇬🇧 Windows 10)

Installation & Preparation

1. if necessary, install Python on the PC if you have not already done so

2. (If necessary, prepare an Excel sheet according to the general conditions - if not already done)

   1. .xlsx-Format

   2. Table columns:

      Name

      Straße (english: street; format: street name house number)

      PLZ (english: zip code (empty column))

      Stadt (english: city)

Execution

Note: While the program is working best do not open any of the tables

Navigate to software files

1. Open "Command Prompt" (CMD).

   1. Press Windows key + R > type "cmd" > press Enter

2. Navigate in CMD to path where crawler files ("plzCrawler_en.py" & "plzMaker.py") and the requirements.txt are located

   1. Enter text according to the following pattern: cd C:\Users\Username\Documents\plzcrawler

Create virtual environment (venv)

1. Type the following text in CMD & press Enter (to create a virtual environment named "venv"): py -m venv venv

activate venv

1. Type the following text in CMD & press Enter: venv\Scripts\activate.bat

install requirements.txt in venv

1. Type the following text in CMD & press Enter: pip install -r requirements.txt

Run the executable file ("plzMaker.py") and follow the instructions

1. Type the following text in CMD & press Enter: py plzMaker.py

find finished spreadsheet

The finished spreadsheet is in the folder of the original spreadsheet. It can be recognized by the '+PLZ' ending. The new document looks very similar to the original document and now includes the postcodes found. It may also contain information as to why individual postcodes could not be found. This project will help you to find the zipcode.