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
postal_code_bulk_search.py๋ ์ฐ์ฒด๊ตญ ํํ์ด์ง์์ ์ฌ์ฉ์์ ๋ฐ์ก ์ด๋ ฅ์ ์๋์ผ๋ก ์์งํ๊ณ ์ ์ฅํ๋ ํ๋ก๊ทธ๋จ์ ๋๋ค. ๊ธฐ๋ณธ ๋ฐ์ก ์ ๋ณด์ ์์ธ ๋ฐฐ์ก ์ ๋ณด๋ฅผ ๋ชจ๋ ์์งํ์ฌ ์์ ํ์ผ๋ก ์ ์ฅํฉ๋๋ค.
- ๊ธฐ๋ณธ ๋ฐ์ก ์ ๋ณด ์์ง (๋ฐ์ ์ธ, ์์ ์ธ, ์ ์๋ฒํธ ๋ฑ)
- ๊ฐ ๋ฐ์ก๊ฑด์ ์์ธ ๋ฐฐ์ก ์ ๋ณด ์์ง
- ์์ง๋ ๋ฐ์ดํฐ ์๋ ์์ ์ ์ฅ
- Chrome ์น ๋ธ๋ผ์ฐ์
- ChromeDriver (Chrome ๋ฒ์ ๊ณผ ํธํ๋๋ ๋ฒ์ )
- ํ์ํ Python ํจํค์ง:
- selenium
- pandas
- datetime
- ์ฐ์ฒด๊ตญ ํํ์ด์ง ๋ก๊ทธ์ธ
- ํ๋ก๊ทธ๋จ์ด ์๋์ผ๋ก ๋ก๊ทธ์ธ ํ์ด์ง๋ก ์ด๋ํฉ๋๋ค
- ๋ก๊ทธ์ธ์ ์๋ฃํ ํ ์ํฐํค๋ฅผ ๋๋ฌ์ฃผ์ธ์
- ๋ฐ์ดํฐ ์์ง
- ๊ธฐ๋ณธ ๋ฐ์ก ์ ๋ณด๊ฐ ์๋์ผ๋ก ์์ง๋ฉ๋๋ค
- ํ์ด์ง ์ด๋์ด ํ์ํ ๊ฒฝ์ฐ ์๋ด์ ๋ฐ๋ผ ์งํํด์ฃผ์ธ์
- ์์ธ ์ ๋ณด๋ ์๋์ผ๋ก ์์ง๋ฉ๋๋ค
- ๊ฒฐ๊ณผ ํ์ธ
- ์์ง๋ ๋ฐ์ดํฐ๋ ๋ฐํํ๋ฉด์ ๋ ๊ฐ์ ์์
ํ์ผ๋ก ์ ์ฅ๋ฉ๋๋ค
- ๊ธฐ๋ณธ ์ ๋ณด: "์ฐ์ฒด๊ตญ_๋ฐฐ์ก์กฐํ_[๋ ์ง์๊ฐ].xlsx"
- ์์ธ ์ ๋ณด: "์ฐ์ฒด๊ตญ_๋ฐฐ์ก์์ธ์ ๋ณด_[๋ ์ง์๊ฐ].xlsx"
- ๋คํธ์ํฌ ์ํ์ ๋ฐ๋ผ ์์ง ์๊ฐ์ด ๋ฌ๋ผ์ง ์ ์์ต๋๋ค
- ๋ง์ ์์ ๋ฐ์ดํฐ๋ฅผ ํ ๋ฒ์ ์์งํ ๊ฒฝ์ฐ ์๊ฐ์ด ์ค๋ ๊ฑธ๋ฆด ์ ์์ต๋๋ค
postal_code_bulk_search.py is a program that automatically collects and saves dispatch history from the Korea Post website. It collects both basic shipping information and detailed delivery information, saving them to Excel files.
- Collection of basic shipping information (sender, receiver, receipt numbers, etc.)
- Collection of detailed delivery information for each shipment
- Automatic Excel file generation for collected data
- Chrome web browser
- ChromeDriver (compatible with your Chrome version)
- Required Python packages:
- selenium
- pandas
- datetime
- Login to Korea Post website
- Program will automatically navigate to the login page
- Complete the login and press Enter to continue
- Data Collection
- Basic shipping information will be collected automatically
- Follow the prompts if page navigation is needed
- Detailed information will be collected automatically
- Check Results
- Collected data will be saved as two Excel files on your desktop
- Basic info: "์ฐ์ฒด๊ตญ_๋ฐฐ์ก์กฐํ_[datetime].xlsx"
- Detailed info: "์ฐ์ฒด๊ตญ_๋ฐฐ์ก์์ธ์ ๋ณด_[datetime].xlsx"
- Collection time may vary depending on network conditions
- Collecting large amounts of data may take considerable time