This article explains why Chinese characters become garbled when a CSV file is opened in Excel and provides a simple Python solution—using the UTF‑8‑SIG encoding—to ensure the text displays correctly, along with additional tips for handling CSV data.
This article explains how Python can efficiently read and write both XLS and XLSX Excel files using built‑in modules xlrd/xlwt and the third‑party openpyxl library, provides six reusable functions for common operations, and demonstrates testing procedures to verify correct data handling.
This article introduces JDFrame/SDFrame, a JVM‑level DataFrame‑style library that provides semantic, chainable APIs for Java 8 streams, covering quick start, dependency setup, example use cases, and detailed API categories such as matrix view, filtering, aggregation, distinct, grouping, sorting, joining, slicing, parameter settings, percentage conversion, partitioning, row‑number generation, and data replenishment, all illustrated with concise code snippets.
This guide reveals ten powerful and often overlooked techniques for Python’s built‑in csv module, covering automatic delimiter detection, header detection, custom dialects, DictWriter usage, selective column reading, generator‑based streaming, special‑character escaping, safe appending, CSV‑JSON conversion, and explicit Unicode handling to boost data‑processing efficiency.
This article walks through a real‑world Pandas question, showing the original dataset, the expected output, and two concise code solutions—one using groupby with unique strings and another with set conversion—plus a performance comparison.
This article introduces fifteen widely used open‑source Python frameworks—including Django, Flask, Tornado, Dpark, and Scrapy—covering web development, data analysis, asynchronous I/O, and distributed computing, and briefly describes each framework’s main features and typical use cases.
This article introduces Python’s built‑in itertools module, explains its infinite, finite, and combinatorial iterator utilities, demonstrates advanced techniques like grouping and pipeline construction, and compares its lazy evaluation memory benefits to traditional list comprehensions for large‑scale data processing.
This article demonstrates three efficient Python techniques—list unpacking, NumPy aggregation, and functional reduction—to sum corresponding elements across sub‑lists in a two‑dimensional list, complete with code examples and visual explanations for beginners and seasoned developers alike.
CSV Trimming is a lightweight Python library that transforms irregular, poorly formatted CSV files into clean, well‑structured tables with a single line of code, supporting basic trimming as well as advanced row‑correlation handling for complex datasets.
This article introduces Python list comprehensions, explaining their concise syntax, basic and advanced usage patterns such as filtering, nested loops, dictionary and set comprehensions, and demonstrates numerous practical examples with code snippets for tasks like generating squares, filtering even numbers, combining lists, and processing files.
This article provides a collection of practical Python code snippets covering file and directory management, data processing, network requests, automation tasks, document handling, image manipulation, system monitoring, visualization, cleaning, logging, and web scraping, all presented with clear explanations and ready-to-use examples.
This article demonstrates how to use Python to read and write Excel files, extract birth dates from Chinese ID numbers, and compute the time interval between dates, providing a practical example for automating HR data handling.
This article walks through a Python automation issue where a pandas DataFrame fails to match rows by prefix, shows the original code, explains the mistake, and provides a corrected implementation to extract the desired column values from Excel sheets.
This article walks through a Python community member's Excel automation issue, explains how to build a pandas mask to target specific rows, and provides a reusable function that writes a custom value into the desired cell based on flexible keyword arguments.
Learn how to use Python to scrape hero equipment data from the King of Glory website, download images via multithreaded requests, and automatically generate comprehensive Markdown and Excel reports, complete with code snippets and troubleshooting tips for a seamless data extraction workflow.
This article introduces the ten most commonly used Pandas functions—read_csv, head, tail, info, describe, dropna, fillna, groupby, merge, and to_csv—explaining their purposes and providing clear Python code examples for each in practical data analysis tasks.
The article surveys the 22 most downloaded Python packages on PyPI, explaining each library's main purpose, typical use cases, download counts, and providing concise code examples to illustrate how they simplify tasks such as HTTP requests, compatibility, AWS interaction, data parsing, and encryption.
This guide introduces and compares several Python libraries—including csv, openpyxl, pandas, xlsxwriter, pyexcel, xlrd/xlwt, xlutils, tablib, ezodf, xlwings, and readxl—detailing their purposes, key features, typical use cases, installation commands, and example code for reading and writing CSV and Excel files.
This article explains how to use Python's openpyxl and pandas libraries to read, write, style, and merge Excel files, covering installation, basic operations, advanced cell formatting, data manipulation, and techniques for combining multiple sheets or workbooks into a single DataFrame.
This article explains why Pandas' str.extract returns a DataFrame by default, when you must use .loc and an index to assign extracted values to a column, and clarifies the differences between Series and DataFrame assignments in various scenarios.
This article provides a series of Python pandas code snippets that demonstrate how to read, filter, sort, merge, remove duplicates, create pivot tables, perform statistical analysis, generate charts, apply formatting, and add conditional formatting to Excel files.
This article explains why Pandas displays a large numeric code like 420113000000 in scientific notation and provides step‑by‑step code to convert the column to string and replace the value correctly, avoiding unwanted formatting.
This article walks through a common PermissionError encountered when using pandas and openpyxl to write to an Excel file, explains why it occurs, and provides a concise code solution that safely appends data without keeping the file open.
This article explains a Python‑based solution for splitting an Excel workbook into multiple files based on a column, preserving original formatting and inserting a summary sheet using pandas for data handling and openpyxl for format‑aware operations.
This article presents seventeen versatile Python scripts that automate tasks such as file management, web scraping, email handling, database interaction, system monitoring, and image processing, providing clear code examples and explanations to help developers and analysts streamline workflows and boost productivity.
This article explains how to create and use a Python JSONPath decorator to simplify extracting data from JSON, covering installation, basic and advanced use cases such as list handling, filtering, aggregation, asynchronous processing, API parsing, validation, dynamic path generation, and nested data extraction, with full code examples.
This article explains how Python decorators can enhance Excel data handling by providing use‑cases such as validation, error handling, logging, performance optimization, multithreading, and permission checks, and demonstrates each scenario with clear, runnable code examples.
This article explains how to use Python's parameterized approach to efficiently read, clean, transform, summarize, visualize, and export Excel data through reusable functions and code snippets, enabling flexible and automated data workflows.
This guide demonstrates how to use Python's openpyxl and pandas libraries to automatically sort Excel columns by sales amount, filter rows exceeding a threshold, and extend functionality with regex, providing complete code examples for efficient data processing.
This article examines a pandas DataFrame grouping issue where, after using concat, only the first group's row label appears, provides the original code snippet, discusses why the problem occurs, and suggests writing each group directly to Excel as a solution.
This article explains how the underscore character in Python can be used to capture the last console result, ignore unwanted values during unpacking, denote protected or private members in classes, and improve numeric readability, offering practical tips to write cleaner and more efficient code.
This article demonstrates how to use Python, pandas, and python‑docx to read sales data from Excel, compute necessary metrics, and automatically generate formatted Word daily‑report documents in bulk, turning a repetitive manual task into an efficient automated workflow.
CleverCSV is a Python library that uses machine‑learning to automatically detect CSV dialects, offering a more flexible alternative to the standard csv module, with installation instructions, basic and advanced usage examples, and a complete script demonstrating generation, detection, manipulation, and writing of complex CSV files.
This article walks through a common issue where pandas cannot read encrypted Excel files, explains why a password is required, and provides a concise openpyxl‑based code snippet to load such files into a pandas DataFrame for further processing.
This article explains how to group a dataset by multiple columns, sort each group by an end‑time column, and keep only the first record when consecutive timestamps differ by less than 20 seconds, using a concise Pandas solution.
This article walks through how to combine twelve distinct pandas DataFrames into a single Excel worksheet, inserting two blank rows between each table, by determining the current sheet’s last occupied row and appending data accordingly, complete with code snippets and visual guidance.
This article walks through a practical solution for combining twelve distinct pandas DataFrames into a single Excel worksheet, inserting two blank rows between each table, and offers alternative approaches using CSV intermediate files, complete with code snippets and visual examples.
This article walks through a real‑world Pandas tutorial where a single‑column Excel file is reshaped into 13 columns, duplicate rows are removed, column headers are set, and timestamps from a second workbook are merged, highlighting the challenges of aligning data without a unique key.
This article introduces Python's xlwt, xlrd, and openpyxl libraries for Excel data processing, explains how to install them, and provides step‑by‑step code examples for writing and reading .xls and .xlsx files, making it a practical guide for data‑handling tasks.
This article explains how to extract a particular key from each JSON object in a list, optionally filter out unwanted entries, and download images from URLs using Python's requests and os modules, providing complete example code for both tasks.
This article introduces the Python tqdm library, explains how to install it, provides multiple practical code examples for adding progress bars to loops, file processing, and data handling, and details various customization options to tailor the progress display to specific needs.
This article demonstrates how to use Python's pandas library to read an Excel file, define a function that matches specific brand keywords in a column, assign corresponding labels such as “automobile brand” or “sports brand” to a new column, and output the results, while also providing the full code example and tips for sharing data and seeking help.
This article walks through a Pandas data‑processing question where a user needs to retrieve the column names with a value of 1 for each record, presenting iterative, optimized, and apply‑based Pythonic approaches along with practical tips for sharing code and data.
This article demonstrates how to extract specific keys from a list of JSON objects and download images to a local folder using Python, providing reusable functions, example code, and an extended version that filters out items based on a type field.
This tutorial explains how to read and write Excel files in Python using xlrd/xlwt for .xls, openpyxl for .xlsx, and pandas for high‑level data handling, including installation commands, code examples, and a practical case of processing a tab‑separated car‑listing file.
This article demonstrates how to use Python and pandas to automatically read a text‑based question bank, parse questions and options, and export the data to an Excel file, providing complete code examples and a step‑by‑step explanation of the process.
This article explains how to retrieve data from an Oracle database with cx_Oracle, convert it to a pandas DataFrame, and correctly write the results to an Excel file with column headers, providing a complete code example and a practical solution to a common data‑processing issue.
This article walks through a Python pandas solution for processing Excel data, showing how to compute row‑wise minimums across multiple columns with concise code snippets, including a loop with f‑strings, and explains the implementation details for readers to apply to similar data‑analysis tasks.
This article shows how to handle irregular JSON strings exported from a database by using a concise Pandas lambda expression that replaces empty actor lists with a default ID, providing a quick data‑cleaning solution for Python developers.
This article walks through a community‑sourced solution for reshaping a nested Python list into a cleaner structure, presenting multiple approaches, detailed code snippets, and visual examples that illustrate how to extract and reorganize list elements effectively.
This guide presents a curated collection of Python libraries that enable automation of Excel, Word, PowerPoint, ODF, PDF, email, and general file handling tasks, providing official links and key features for each library to help developers streamline office workflows.
This article explains how to use Python to copy a specific area of an Excel worksheet together with its formatting, walks through the provided code solution, highlights common pitfalls, and offers a concise, refined implementation for seamless Excel automation.
This tutorial demonstrates how to use the Python openpyxl library to create, open, modify, and save Excel workbooks, covering worksheet management, cell operations, row and column handling, insertion and deletion, as well as read‑only and streaming techniques for efficient data processing.
This article shows how to use Pandas to group rows by multiple columns, collect the values of another column into a list, and then join them into a comma‑separated string, providing two concise code solutions and a performance comparison.
This guide explains how to add new rows to a text file—creating the file if it doesn't exist—while ensuring both the incoming data and the combined file contain no duplicate entries, using Python's set operations and appropriate file modes.
This tutorial shows how to merge multiple Excel files using pandas in Python and enhance the process with a live progress bar by integrating the tqdm library, complete with code examples and visual results.
This article demonstrates how to use Python 3.7 with the xlrd and xlwt libraries to read data from an Excel workbook, process cell values, write new data, apply styles, and adjust cell dimensions, providing practical code examples for handling Excel files in everyday tasks.
This article documents a Python parking lot management application, detailing its project directory layout, describing each module such as button handling, OCR, and time utilities, and presenting key pygame-based code that renders parking statistics and vehicle information from an Excel file.
This tutorial demonstrates how to install Python and Pandas, use Pandas to read and write Excel files, handle common issues with xlrd and openpyxl, and provides a complete script for automating weekly Excel report updates.
This article demonstrates how to use pandas groupby, list aggregation, sorting, deduplication, and explode (or a custom apply function) to retrieve each user's top‑priority tag while preserving other tag columns, comparing two practical implementations and their performance trade‑offs.
This article presents a curated list of fifteen widely used open‑source Python frameworks, covering full‑stack web development, lightweight micro‑frameworks, event‑driven I/O, OLAP, distributed computing, continuous integration, and web crawling, each with a brief functional overview.
This article demonstrates how to use Python's xlrd and xlwt libraries to read, manipulate, and write large Excel workbooks, replacing tedious manual column operations with a concise script that processes multiple sheets and aggregates data automatically.
This article explains how to use pandas' json_normalize function to transform different JSON formats—including simple objects, nested objects, lists, and deeply nested structures—into DataFrames, covering parameters such as record_path, meta, max_level, sep, errors, and prefix handling, with practical code examples.
This tutorial demonstrates two pandas approaches to retrieve each user's highest‑priority label based on ordered tags, covering data preparation, grouping, custom sorting with key functions, deduplication, and the explode method, complete with code snippets and performance considerations.
This article walks through two common Excel‑automation tasks—merging a named sheet from two workbooks and consolidating the second sheet of every file in a folder—using concise pandas code, complete with step‑by‑step explanations and runnable examples.
This tutorial demonstrates how to read, write, and convert CSV, JSON, and XML data using Python's built‑in modules and popular libraries such as pandas and dicttoxml, providing clear code examples for each format and showing how to interconvert them efficiently.
This article walks through extracting latitude and longitude pairs from a CSV file into separate Excel columns using pandas, explains each processing step, and presents an optimized chunk‑based solution that handles tens of thousands of rows in seconds.
Learn how to use Python to send real-time progress updates and completion alerts via email for long-running tasks such as model training, data processing, and financial modeling, by leveraging the email, smtplib, and MIME libraries to build customizable notifications with images and attachments.
This tutorial introduces Python's openpyxl library for reading, writing, and manipulating Excel files, covering installation, basic methods, and four practical examples including creating multiplication tables, inserting rows, transposing data, and importing text files into spreadsheets.
This tutorial demonstrates how to use Python and pandas to read CSV and Excel files, merge them on a key column, and export the combined result, offering a faster, more reliable alternative to Excel's VLOOKUP for large datasets.
This article demonstrates a step‑by‑step Python workflow for reading two Excel sheets, calculating haversine distances between latitude‑longitude pairs, identifying the nearest point for each record, and exporting the results, complete with code snippets, progress display, and performance advantages over traditional GIS tools.
This article walks through several pandas performance‑boosting methods—from naive for‑loops and iterrows to apply, .isin, pd.cut, and NumPy digitize—showing timing results and demonstrating how vectorized operations can accelerate hourly tariff calculations by hundreds of times.
This tutorial walks through a real‑world Python office‑automation task: extracting rows for a specific archive name from dozens of Excel worksheets and consolidating them into a new workbook, complete with step‑by‑step analysis and full code examples.
This article demonstrates how to use Python's xlwt, xlrd, and xlutils libraries to create an Excel file with a multiplication table, read its contents, and modify the data by copying the workbook, providing step‑by‑step code examples and screenshots.
This guide presents a collection of practical Python snippets covering image manipulation with Pillow, video downloading via youtube-dl, object introspection, music bot usage, financial data retrieval with Tushare, vulnerability lab setup, Beijing bus API queries, article extraction, QR code generation, fake user agents, HTTP request statistics, shell commands, Chinese text sentiment analysis, proxy handling, Zhihu API access, password breach checking, Nginx log analysis, and train ticket queries.
xlrd is a Python module for reading Excel files, and this guide explains how to install it, locate its documentation, and demonstrates basic operations such as opening a workbook, accessing sheets, retrieving rows, columns, and cell values with example code snippets.
This guide compiles essential Python snippets for tasks such as image manipulation with Pillow, video downloading via youtube‑dl, inspecting request objects, accessing NetEase Cloud Music, retrieving financial data with Tushare, running Docker‑based vulnerability labs, querying Beijing bus real‑time info, extracting articles with Goose, performing sentiment analysis, generating fake user agents, and more.
Meituan’s settlement and reconciliation platform was rebuilt from a single‑threaded, month‑end batch system into a distributed, multi‑threaded, real‑time service that abstracts core models, uses lock‑free processing, sharding, and dedicated Kafka topics, achieving millisecond latency for millions of daily bills across 17 business lines.
