Skip to content

Automate postal code search and address details differentiation ๐Ÿ“ฎ๐Ÿ”

License

Notifications You must be signed in to change notification settings

movemin03/postal_code_bulk_search

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

19 Commits
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

Postal Code Bulk Search (์šฐํŽธ๋ฒˆํ˜ธ ๋Œ€๋Ÿ‰ ๊ฒ€์ƒ‰)

postal_code_bulk_search.py ํ”„๋กœ๊ทธ๋žจ์€ ๋ฐ›๋Š” ๋ถ„, ์ฃผ์†Œ ๋ฐ ์—ฐ๋ฝ์ฒ˜ ํ•„๋“œ์™€ ํ•จ๊ป˜ ์—‘์…€ ํŒŒ์ผ ๊ฒฝ๋กœ๋ฅผ ์ž…๋ ฅํ•˜์—ฌ ์šฐํŽธ๋ฒˆํ˜ธ๋ฅผ ์ž๋™์œผ๋กœ ๊ฒ€์ƒ‰ํ•˜๊ณ  ์ผ๋ฐ˜ ๋ฐ ์ƒ์„ธ ์ฃผ์†Œ๋ฅผ ๊ตฌ๋ถ„ํ•˜๋ฉฐ ํœด๋Œ€์ „ํ™” ๋ฐ ์ผ๋ฐ˜ ์ „ํ™” ๋ฒˆํ˜ธ๋ฅผ ๊ตฌ๋ถ„ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

์‚ฌ์šฉ ๋ฐฉ๋ฒ•:

postal_code_bulk_search.py ์Šคํฌ๋ฆฝํŠธ๋ฅผ ์‹คํ–‰ํ•ฉ๋‹ˆ๋‹ค. Excel ํŒŒ์ผ์„ ์ œ๊ณตํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค. Excel ํŒŒ์ผ์˜ ์—ด ์ด๋ฆ„์€ ๊ฐ๊ฐ "๋ฐ›๋Š” ๋ถ„", "์ฃผ์†Œ", "์—ฐ๋ฝ์ฒ˜"์—ฌ์•ผ ํ•ฉ๋‹ˆ๋‹ค.

๊ธฐ๋Šฅ:

ํ”„๋กœ๊ทธ๋žจ์€ ์ž๋™์œผ๋กœ ๋‹ค์Œ์„ ์ˆ˜ํ–‰ํ•ฉ๋‹ˆ๋‹ค.

  1. ์šฐํŽธ๋ฒˆํ˜ธ ๊ฒ€์ƒ‰
  2. ์ผ๋ฐ˜ ๋ฐ ์ƒ์„ธ ์ฃผ์†Œ ๊ตฌ๋ถ„
  3. ํœด๋Œ€์ „ํ™” ๋ฐ ์ผ๋ฐ˜ ์ „ํ™” ๋ฒˆํ˜ธ ๊ตฌ๋ถ„

์š”๊ตฌ ์‚ฌํ•ญ:

pip install requests, lxml, xml.etree.ElementTree

Pyinstaller ์‚ฌ์šฉ ์‹œ:

pyinstaller postal_code_bulk_search.py --hidden-import requests --hidden-import lxml --hidden-import xml.etree.ElementTree


Postal Code Bulk Search (English)

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.

Usage:

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.

Feature:

The program will automatically

  1. search for postal codes
  2. distinguish between regular and detailed addresses
  3. differentiate between mobile and landline phone numbers

Requirements:

pip install requests, lxml, xml.etree.ElementTree

To use Pyinstaller:

pyinstaller postal_code_bulk_search.py --hidden-import requests --hidden-import lxml --hidden-import xml.etree.ElementTree


postal_code_bulk_search.py

์†Œ๊ฐœ

postal_code_bulk_search.py๋Š” ์šฐ์ฒด๊ตญ ํ™ˆํŽ˜์ด์ง€์—์„œ ์‚ฌ์šฉ์ž์˜ ๋ฐœ์†ก ์ด๋ ฅ์„ ์ž๋™์œผ๋กœ ์ˆ˜์ง‘ํ•˜๊ณ  ์ €์žฅํ•˜๋Š” ํ”„๋กœ๊ทธ๋žจ์ž…๋‹ˆ๋‹ค. ๊ธฐ๋ณธ ๋ฐœ์†ก ์ •๋ณด์™€ ์ƒ์„ธ ๋ฐฐ์†ก ์ •๋ณด๋ฅผ ๋ชจ๋‘ ์ˆ˜์ง‘ํ•˜์—ฌ ์—‘์…€ ํŒŒ์ผ๋กœ ์ €์žฅํ•ฉ๋‹ˆ๋‹ค.

๊ธฐ๋Šฅ

  • ๊ธฐ๋ณธ ๋ฐœ์†ก ์ •๋ณด ์ˆ˜์ง‘ (๋ฐœ์‹ ์ธ, ์ˆ˜์‹ ์ธ, ์ ‘์ˆ˜๋ฒˆํ˜ธ ๋“ฑ)
  • ๊ฐ ๋ฐœ์†ก๊ฑด์˜ ์ƒ์„ธ ๋ฐฐ์†ก ์ •๋ณด ์ˆ˜์ง‘
  • ์ˆ˜์ง‘๋œ ๋ฐ์ดํ„ฐ ์ž๋™ ์—‘์…€ ์ €์žฅ

ํ•„์š” ์‚ฌํ•ญ

  • Chrome ์›น ๋ธŒ๋ผ์šฐ์ €
  • ChromeDriver (Chrome ๋ฒ„์ „๊ณผ ํ˜ธํ™˜๋˜๋Š” ๋ฒ„์ „)
  • ํ•„์š”ํ•œ Python ํŒจํ‚ค์ง€:
    • selenium
    • pandas
    • datetime
  1. ์šฐ์ฒด๊ตญ ํ™ˆํŽ˜์ด์ง€ ๋กœ๊ทธ์ธ
  • ํ”„๋กœ๊ทธ๋žจ์ด ์ž๋™์œผ๋กœ ๋กœ๊ทธ์ธ ํŽ˜์ด์ง€๋กœ ์ด๋™ํ•ฉ๋‹ˆ๋‹ค
  • ๋กœ๊ทธ์ธ์„ ์™„๋ฃŒํ•œ ํ›„ ์—”ํ„ฐํ‚ค๋ฅผ ๋ˆŒ๋Ÿฌ์ฃผ์„ธ์š”
  1. ๋ฐ์ดํ„ฐ ์ˆ˜์ง‘
  • ๊ธฐ๋ณธ ๋ฐœ์†ก ์ •๋ณด๊ฐ€ ์ž๋™์œผ๋กœ ์ˆ˜์ง‘๋ฉ๋‹ˆ๋‹ค
  • ํŽ˜์ด์ง€ ์ด๋™์ด ํ•„์š”ํ•œ ๊ฒฝ์šฐ ์•ˆ๋‚ด์— ๋”ฐ๋ผ ์ง„ํ–‰ํ•ด์ฃผ์„ธ์š”
  • ์ƒ์„ธ ์ •๋ณด๋Š” ์ž๋™์œผ๋กœ ์ˆ˜์ง‘๋ฉ๋‹ˆ๋‹ค
  1. ๊ฒฐ๊ณผ ํ™•์ธ
  • ์ˆ˜์ง‘๋œ ๋ฐ์ดํ„ฐ๋Š” ๋ฐ”ํƒ•ํ™”๋ฉด์— ๋‘ ๊ฐœ์˜ ์—‘์…€ ํŒŒ์ผ๋กœ ์ €์žฅ๋ฉ๋‹ˆ๋‹ค
    • ๊ธฐ๋ณธ ์ •๋ณด: "์šฐ์ฒด๊ตญ_๋ฐฐ์†ก์กฐํšŒ_[๋‚ ์งœ์‹œ๊ฐ„].xlsx"
    • ์ƒ์„ธ ์ •๋ณด: "์šฐ์ฒด๊ตญ_๋ฐฐ์†ก์ƒ์„ธ์ •๋ณด_[๋‚ ์งœ์‹œ๊ฐ„].xlsx"

์ฃผ์˜์‚ฌํ•ญ

  • ๋„คํŠธ์›Œํฌ ์ƒํƒœ์— ๋”ฐ๋ผ ์ˆ˜์ง‘ ์‹œ๊ฐ„์ด ๋‹ฌ๋ผ์งˆ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค
  • ๋งŽ์€ ์–‘์˜ ๋ฐ์ดํ„ฐ๋ฅผ ํ•œ ๋ฒˆ์— ์ˆ˜์ง‘ํ•  ๊ฒฝ์šฐ ์‹œ๊ฐ„์ด ์˜ค๋ž˜ ๊ฑธ๋ฆด ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค


postal_code_bulk_search.py

Introduction

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.

Features

  • 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

Requirements

  • Chrome web browser
  • ChromeDriver (compatible with your Chrome version)
  • Required Python packages:
    • selenium
    • pandas
    • datetime
  1. Login to Korea Post website
  • Program will automatically navigate to the login page
  • Complete the login and press Enter to continue
  1. Data Collection
  • Basic shipping information will be collected automatically
  • Follow the prompts if page navigation is needed
  • Detailed information will be collected automatically
  1. Check Results
  • Collected data will be saved as two Excel files on your desktop
    • Basic info: "์šฐ์ฒด๊ตญ_๋ฐฐ์†ก์กฐํšŒ_[datetime].xlsx"
    • Detailed info: "์šฐ์ฒด๊ตญ_๋ฐฐ์†ก์ƒ์„ธ์ •๋ณด_[datetime].xlsx"

Cautions

  • Collection time may vary depending on network conditions
  • Collecting large amounts of data may take considerable time

About

Automate postal code search and address details differentiation ๐Ÿ“ฎ๐Ÿ”

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages