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!
The article explains a real‑world requirement to map numeric business levels to Chinese strings in Excel and provides two Python solutions—one using openpyxl for modern .xlsx files and another using win32com for legacy .xls files—complete with runnable code and execution results.
The author recounts a Python‑based workflow that automatically adds watermarks to foreign‑trade .doc documents, details client validation, unexpected .docx conversion issues, and the iterative debugging steps taken to ensure reliable batch processing.
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.
