Data Plumbing #2: Turn Google Autocomplete suggestions into keyword clustersNormalize, dedupe and group by head term — 166 real suggestions from 20 seeds become 24 clusters9 min read·hsinghsien-chen.hashnode.devNov 2
Data Plumbing #1: Compare 50 Google Trends keywords on one scaleAnchors, rounding error, and the 8-term Explore limit — with a simulation that measures what breaks9 min read·hsinghsien-chen.hashnode.devOct 26
How to Compare a Long Keyword List in Google Trends on One 0-100 ScaleWhy separate Trends requests can't be compared, the anchor-term rescaling fix, a runnable pandas implementation, and the pitfalls.11 min read·hsinghsien-chen.hashnode.devOct 18
Full-Page Screenshots of Chinese, Japanese and Emoji Pages with Headless Chromium (No Tofu Boxes)If you take website screenshots with headless Chromium for visual QA, monitoring or archiving, two problems show up the moment the pages aren't plain English: Tofu boxes. Chinese, Japanese, Korean an13 min read·hsinghsien-chen.hashnode.devOct 18
How to Build a B2B Contact List from Company Websites Responsiblyrobots.txt and Crawl-delay, contact-page discovery, E.164 phone normalisation (Taiwan formats included), LINE links, de-duplication and GDPR/PDPA, with a runnable Python example.11 min read·hsinghsien-chen.hashnode.dev1OOct 17
