Life's short, I code in Python. This channel shares Python web crawling, data mining, analysis, processing, visualization, automated testing, DevOps, big data, AI, cloud computing, machine learning tools, resources, news, technical articles, tutorial videos and learning materials. Join us!
This article walks through a fan‑requested Python automation that replaces artistic watermark text in shipping‑bill DOCX files, detailing the initial python‑docx attempt, the shortcomings of win32com shape traversal, and the final reliable solution using zipfile‑based XML replacement.
The article outlines a fan's request to automate the replacement of header watermarks in dozens of foreign‑trade bill‑of‑lading .doc files using Python, explains the inefficiency of manual editing, describes converting .doc to .docx and applying python‑docx, and previews a detailed multi‑part walkthrough of the implementation challenges.
Even with 99 % accuracy, tens of thousands of errors remain in a 300 k‑row dataset, so the author builds a Python‑AI pipeline that preprocesses images, performs high‑precision OCR, merges data, applies custom validation rules, and automatically generates an error report, dramatically reducing manual effort.
This article demonstrates how to use Python and pandas to automatically structure, clean, and combine tens of thousands of OCR‑generated data rows from multiple files into a single Excel workbook, eliminating manual copy‑paste and ensuring uniform fields and formats.
The article explains why generic OCR struggles with structured tables, proposes a partition‑based fixed‑region recognition method using PaddleOCR, provides a complete Python script for batch processing, and demonstrates how this approach consistently achieves over 99% accuracy.
Faced with 30,000 report images containing 300,000 rows of tabular data, the author explains why WPS failed at scale, analyzes the OCR error sources, and shares a Python script that batch‑crops images to boost recognition accuracy before exporting everything to Excel.
The author details how they used AI‑assisted Python scripts to batch‑process over 30,000 report images, extract tables via OCR, crop noisy regions, merge results into a single Excel sheet with 99% accuracy, and automate validation, eliminating manual data entry.
This article demonstrates how to use Python to crawl 7,275 Douban short reviews of the film “Letter to Grandma”, clean the data, generate a word‑cloud and frequency bar chart, and perform sentiment analysis that reveals over 91% of comments are positive.
This guide walks you through using Doubao’s video‑generation feature, showing how to start a project, the daily free quota, common pitfalls like missing audio and short clip limits, and tips for obtaining better results.
This tutorial shows how to encode a JD.com search URL, fetch the page, and use XPath expressions in Python to reliably extract product names, links, images, and prices, offering a clearer alternative to regular‑expression or BeautifulSoup scraping.
