postal_code_bulk_search.py
ํ๋ก๊ทธ๋จ์ ๋ฐ๋ ๋ถ, ์ฃผ์ ๋ฐ ์ฐ๋ฝ์ฒ ํ๋์ ํจ๊ป ์์
ํ์ผ ๊ฒฝ๋ก๋ฅผ ์
๋ ฅํ์ฌ ์ฐํธ๋ฒํธ๋ฅผ ์๋์ผ๋ก ๊ฒ์ํ๊ณ ์ผ๋ฐ ๋ฐ ์์ธ ์ฃผ์๋ฅผ ๊ตฌ๋ถํ๋ฉฐ ํด๋์ ํ ๋ฐ ์ผ๋ฐ ์ ํ ๋ฒํธ๋ฅผ ๊ตฌ๋ถํ ์ ์์ต๋๋ค.
postal_code_bulk_search.py ์คํฌ๋ฆฝํธ๋ฅผ ์คํํฉ๋๋ค. Excel ํ์ผ์ ์ ๊ณตํด์ผ ํฉ๋๋ค. Excel ํ์ผ์ ์ด ์ด๋ฆ์ ๊ฐ๊ฐ "๋ฐ๋ ๋ถ", "์ฃผ์", "์ฐ๋ฝ์ฒ"์ฌ์ผ ํฉ๋๋ค.
ํ๋ก๊ทธ๋จ์ ์๋์ผ๋ก ๋ค์์ ์ํํฉ๋๋ค.
- ์ฐํธ๋ฒํธ ๊ฒ์
- ์ผ๋ฐ ๋ฐ ์์ธ ์ฃผ์ ๊ตฌ๋ถ
- ํด๋์ ํ ๋ฐ ์ผ๋ฐ ์ ํ ๋ฒํธ ๊ตฌ๋ถ
pip install requests, lxml, xml.etree.ElementTree
pyinstaller postal_code_bulk_search.py --hidden-import requests --hidden-import lxml --hidden-import xml.etree.ElementTree
The postal_code_bulk_search.py
program allows you to automatically search for postal codes, distinguish between regular and detailed addresses, and differentiate between mobile and landline phone numbers by simply inputting recipient information, address, and contact fields, along with the Excel file path.
Run the postal_code_bulk_search.py script. You must provide an Excel file containing recipient information, address, and contact details. The column names in the Excel file must be "๋ฐ๋ ๋ถ", "์ฃผ์", and "์ฐ๋ฝ์ฒ" respectively.
The program will automatically
- search for postal codes
- distinguish between regular and detailed addresses
- differentiate between mobile and landline phone numbers
pip install requests, lxml, xml.etree.ElementTree
pyinstaller postal_code_bulk_search.py --hidden-import requests --hidden-import lxml --hidden-import xml.etree.ElementTree