This article demonstrates how to automate the creation of Excel pivot tables using Python's pandas library, build a Tkinter GUI for user interaction, and package the solution into a standalone executable with PyInstaller, including steps for managing dependencies and reducing file size.
This article provides a detailed tutorial on Python's time‑related classes and functions, covering Unix timestamps, conversion tools, and the practical use of the calendar, time, and datetime modules with examples of formatting, timezone conversion, and common time‑conversion tricks for everyday programming tasks.
This tutorial walks you through creating a Fruit Ninja‑style game in Python using Pygame, covering required imports, window configuration, random fruit generation, drawing text and lives, handling game‑over screens, and implementing the main game loop with full source code examples.
The article explains how ORM bridges Python objects and relational databases, compares options, and justifies choosing the lightweight Peewee library, then details its workflow—model generation, inserting, updating, deleting, and querying records—showcasing how this approach reduces manual data‑creation time from hours to seconds.
This tutorial demonstrates how to rotate images in Pygame, correct the rotating center, implement boundary collision detection, and enhance the animation with dynamic background colors and multiple leaf objects, providing complete code examples for each stage.
This tutorial demonstrates how to split a master Excel rent ledger into per‑room Excel files, automatically adjust column widths and borders, capture each sheet as an image using xlwings and Pillow, and finally package the script into a standalone executable for distribution.
This article introduces the classic density‑based anomaly detection method Local Outlier Factor (LOF), explains its underlying concepts such as k‑distance, reachability distance, and local reachability density, outlines the algorithm steps, discusses its advantages and limitations, and provides practical Python examples using PyOD and scikit‑learn.
The macOS 12.3 update eliminates the bundled Python 2 interpreter, sparking developer reactions and prompting a discussion of Python’s popularity, its version incompatibilities, and the myriad environment‑management tools like pipenv that aim to tame the language’s historically chaotic setup.
This article walks through a puzzling Python list loop that produces no output, explains why the loop stops early, shows annotated code examples, and presents a second variant of the problem with detailed step‑by‑step analysis to help readers avoid similar bugs.
This article introduces Python's matplotlib 3D plotting capabilities, demonstrating how to create line, scatter, and surface visualizations with step-by-step code examples and animated GIFs that illustrate the impact of parameters such as learning rate and projection settings.
This article explores the AutoPPT system that automates PowerPoint presentation creation by integrating real-time data analysis, reducing manual effort, and enhancing efficiency through a structured workflow from data collection to final output.
This article introduces three Python terminal UI libraries—Curses, npyscreen, and Urwid—explaining their features, showing sample code, and demonstrating how they enable interactive text‑based interfaces on Unix/Linux and, with extra steps, on Windows.
This article introduces Python's turtle module, explains how to import it, configure the pen's speed, color, size, and use drawing functions such as forward, left, right, circle, dot, and goto, and provides several complete code examples for creating simple graphics.
This article walks through three frequent Selenium‑Python automation problems—missing test discovery due to method naming, incorrect URLs that break page data loading, and element‑location failures after window switches—explaining their causes and step‑by‑step solutions.
The article demonstrates how to build a digital twin for lithium‑ion batteries in Python by constructing a physics‑based model, augmenting it with experimental data using a simple Keras neural network, and visualizing predictions, illustrating the hybrid approach’s improved accuracy over purely empirical methods.
This tutorial demonstrates how to use Python's SMTP libraries to programmatically send plain‑text, HTML, and attachment emails, covering SMTP basics, service activation, configuration steps, and complete code examples for each email type.
This article walks through using the requests library’s stream=True parameter in Python to efficiently filter valid URLs during web scraping, presenting two practical methods, code examples, performance insights, and a clear explanation of how stream handling works.
This article explains the purpose of the self parameter in Python classes, using analogies and concrete code examples to show how self represents the instance itself, how it is passed automatically, and how different objects produce distinct self values when methods are invoked.
This article provides a detailed introduction to internal and external sorting, compares the time‑complexities and stability of classic algorithms such as bubble, selection, insertion, shell, merge, quick, heap, counting, bucket and radix sorts, and includes complete Python code examples for each.
This article explains the purpose and behavior of Python's __init__ constructor method, clarifies object-oriented concepts such as classes, instances, and attributes, and provides example code illustrating how __init__ is automatically invoked during object creation to initialize instance properties.
This article explains the common pitfall of deleting elements from a Python list while iterating, demonstrates how the list’s internal pointer causes skipped items, and presents several reliable techniques—such as copying, filtering, and slicing—to safely remove items without errors.
This article provides a detailed survey of face recognition evolution, key researchers, open‑source projects, datasets, the four‑stage processing pipeline, DeepFace architecture, training methods, experimental results, and practical Python installation and usage instructions.
This tutorial explains how to create a Python‑based stock monitoring bot that periodically fetches real‑time prices, compares them with preset thresholds, and sends alerts to a Feishu group via a custom webhook, including step‑by‑step setup and scheduling code.
This article introduces the open‑source WantWords reverse‑dictionary project, explains its token‑based processing pipeline, walks through Python implementation and model invocation with Hugging Face’s Transformers, reviews NLP’s historical evolution, and shows how front‑end developers can quickly integrate NLP models into products.
This article demonstrates how to transform a single Excel column containing semicolon‑separated values into separate rows using pandas' explode() function, offering both an openpyxl‑based method and a concise pandas solution with code examples and step‑by‑step screenshots.
This article demonstrates how to reverse‑engineer the NetEase Cloud Music web API to extract encrypted parameters, use Python to fetch song comments, and apply SnowNLP for sentiment analysis and word‑cloud visualization, providing a step‑by‑step guide with code examples.
This article explains the concept of lazy initialization in Python, reviews the @property decorator, and provides two complete implementations—a descriptor class and a decorator function—to create lazy properties that compute a value only once and then cache it for subsequent accesses.
This article translates a Google engineer's design document that explains how to build a Python‑based Selenium bot for automatically booking gym slots two days in advance, covering problem description, requirements, architecture choices, detailed implementation, and operational workflow.
This article presents a detailed engineering design document for a Python‑based automation tool that uses Selenium to reserve gym slots during the COVID‑19 pandemic, covering problem description, requirements, overview and detailed design, implementation specifics, and operational workflow.
This article explains Python variables, covering their definition as memory containers, naming conventions, assignment syntax, reassignment, using variables in expressions and functions, and illustrates Python's weak typing compared to strong‑typed languages with code examples.
The TIOBE index for March 2022 shows Python still at number one, Lua re‑entering the top‑20 while displacing Groovy, and several shifts among languages like Go, Delphi, R, and Swift, with detailed rankings and trends illustrated in accompanying charts.
This article introduces the Python library Folium, explains its installation, demonstrates basic map creation, marker and shape addition, and presents a practical case of visualizing parking lot geolocation data with interactive features and clustering, providing code snippets and usage guidance.
This article shows how to read a CSV file with pandas, sort its rows by a chosen column in descending order while preserving the header, and save the sorted data to a new CSV, providing a clear, step‑by‑step solution for Python automation tasks.
This post announces a free, beginner‑friendly Python tutorial that covers everything from installation and basic syntax to advanced topics like decorators and serialization, providing a detailed curriculum, video links, and downloadable courseware to help learners start coding without any prior experience.
This article explains common Python code smells in an employee‑management example, demonstrates why practices such as using raw strings for roles, duplicated search methods, excessive isinstance checks, and vague boolean flags are problematic, and provides a step‑by‑step refactor using Enums, abstract base classes, list comprehensions, custom exceptions, and clearer method separation.
This article explains how to accelerate Python array computations by using Numba, demonstrating the limitations of pure NumPy, providing step‑by‑step code examples, performance benchmarks, and discussing Numba’s advantages, compilation overhead, GPU support, and comparisons with other optimization approaches.
This article provides a detailed tutorial on plotnine, the Python implementation of the Grammar of Graphics, covering installation methods, data handling, aesthetic mappings, geometric objects, statistical transformations, scales, position adjustments, coordinate systems, faceting, themes, and multi‑panel plotting with code examples.
This article walks through a Python fan's question about storing JSON from web pages during crawling, presents four step‑by‑step code solutions—including regex, BeautifulSoup, and json.loads—and offers practical tips for clean extraction and reliable scraping.
This article explains the origins, principles, and interactions of CGI, FastCGI, PHP‑FPM, WSGI, uWSGI, and ASGI, detailing how they enable dynamic Python web applications to communicate with web servers such as Nginx and Apache while addressing performance and concurrency concerns.
The article explains how using the $PYTHONPATH environment variable and running Python from the Downloads folder can expose systems to code injection attacks, demonstrates exploit examples, and provides safe practices such as using virtualenv and proper path handling to protect Python execution.
This article walks through six practical Pandas techniques—using map, apply, replace, and dictionary look‑ups—to batch‑replace numeric codes with descriptive strings, complete with code snippets and visual results for each method.
The article explains why a fragile Shell script for comparing local RPM packages to a central repository was rewritten in Python using the rpm‑python library, demonstrates how to install and import the library, and showcases practical code examples for querying both installed and offline RPM packages.
This tutorial explains the fundamental concepts and parsing principles of XPath, shows how to set up the Python lxml environment, demonstrates instantiating etree objects, details XPath expression syntax, and provides multiple real‑world web‑scraping examples with complete code snippets.
This article walks through two practical methods for converting a Python list into the first column of an Excel file—first using openpyxl for direct cell writing, then leveraging pandas for a more concise DataFrame approach, plus additional pandas tricks for column manipulation.
This article introduces the renowned "awesome" GitHub repository, highlights its extensive sub‑lists for various domains, focuses on the awesome‑web‑scraping collection, and presents a newly created Chinese version that aggregates Python, JavaScript, Go, and other language‑specific web‑scraping tools and libraries.
This article walks through a fan's question about selecting the maximum of two DataFrame columns per row, presenting five concise Pandas solutions—including direct max, loc, apply, assign, and NumPy where—complete with code snippets and visual output.
MoviePy is an open‑source Python library licensed under MIT that enables cross‑platform video editing tasks such as cutting, concatenating, adding titles, compositing, and processing audio‑video files—including GIFs—through a simple API demonstrated with a complete code example.
This tutorial walks through creating a Python‑based local QR‑code login scraper for QQ Music, covering the extraction of dynamic parameters, handling of encrypted cookies, displaying and removing QR images, and ultimately obtaining a usable session for further automation.
The article introduces xeasy-ml, a Python machine‑learning framework, explains its installation requirements, demonstrates how to initialize a project, run training, view result artifacts, and provides detailed instructions for online prediction using configuration files and code examples.
This article provides a comprehensive overview of NumPy and pandas, covering ndarray basics, multi‑dimensional array creation, core array attributes, broadcasting, random number generation, reshaping, as well as pandas Series and DataFrame structures, data import/export, grouping, merging, and advanced data manipulation techniques for scientific and data‑analysis tasks.
This tutorial explains the origins and evolution of character encoding, covering early ASCII, Chinese GBK/GB18030, the universal Unicode standard, UTF‑8 variable‑length encoding, and practical differences between Python 2 and Python 3 with code examples.
This article walks through building a classic number‑guessing game in Python, explains two community‑sourced solutions with full source code, highlights common pitfalls, and shows how to enhance interactivity by narrowing the guessing range.
Learn how to generate traditional Chinese spring couplets as decorative images using a concise Python script—covering required modules, character image retrieval, background handling, layout generation, and sample outputs—with clear code snippets and usage examples.
This article presents a Python fan's arithmetic challenge—calculating the alternating sum 1‑2+3‑4+…+99—and walks through five distinct code solutions, from basic loops to concise itertools one‑liners, highlighting their logic and trade‑offs.
This article introduces the requests‑cache library, explains how to install it, demonstrates basic and advanced usage—including session patching, backend selection, expiration policies, request/response filtering, and cache‑control header handling—to efficiently avoid duplicate HTTP requests during Python web scraping.
This article shares practical experiments using Python libraries such as pandas_datareader, yfinance, tushare, and the JoinQuant platform to fetch historical stock data, highlighting connection requirements, limitations, and the ease of obtaining data without additional installations.
This article presents a curated collection of open‑source face recognition projects—including OpenFace, face_recognition, InsightFace, RetinaFace, SCRFD, FaceNet, Deepface, and CompreFace—detailing their features, GitHub stars, usage examples, and code snippets for Python and TensorFlow implementations.
This article walks through a Python fan's question about implementing algebraic functions, presenting two solutions—one using basic arithmetic operators and another leveraging the sympy library—complete with code snippets, explanations, and visual illustrations to help beginners understand the approach.
This article provides a detailed step‑by‑step tutorial on what Jupyter Notebook is, how to install it via Anaconda or pip, configure its settings, use its various interfaces, extend its functionality with extensions, manage kernels, employ shortcuts, and properly close and exit the application.
This article presents a Python script that reads seven judges' scores for a singer, removes the highest and lowest marks, then calculates and displays the total and average scores, illustrating the solution with a complete code example.
This article walks through a Python regex question, demonstrating how to use named and anonymous groups with clear code samples, visual output, and step‑by‑step explanations to help readers grasp pattern matching concepts effectively.
This article explains essential time series preprocessing techniques—including data sorting, handling missing values with interpolation methods, applying rolling averages, Fourier transform denoising, and detecting anomalies using rolling statistics, isolation forests, and K‑means clustering—illustrated with Python code on the AirPassengers and Google stock datasets.
This article walks through creating a Python program that simulates the popular Chinese card game ZhaJinHua, covering deck construction, random dealing to five players, hand‑type evaluation, scoring, and ranking, with complete source code and a concise explanation of each step.
This tutorial walks you through creating a simple aiohttp web application that fetches random Mars rover photos from the NASA API, validates image quality using Pillow, and serves the images directly, covering environment setup, async code, and deployment options.
This tutorial explains how to use Python, ADB commands, OpenCV image recognition, and Tencent OCR to automate weekly tasks in the Onmyoji mobile game, including boss battles, realm breakthroughs, and resource farming, while handling multi‑instance switching and random delays for stability.
This tutorial walks through building a simple Fruit Ninja‑style game in Python using Pygame, covering imports, window setup, random fruit generation, drawing text and lives, handling game over screens, and implementing the main loop with event processing and scoring.
This guide walks you through setting up a Windows environment with PyCharm, mitmproxy, and Appium to capture Douyin video URLs, filter them, and download the videos automatically using Python scripts that drive the mobile app and handle network traffic.
The article shares practical Python programming lessons, covering indentation errors, syntax differences between Python 2 and 3, multithreading pitfalls, the importance of planning code logic, leveraging built‑in functions, and focusing on clear objectives to write efficient, maintainable scripts.
The article reviews three notable 2022 machine‑learning advancements—CatBoost, Amazon SageMaker's DeepAR forecasting, and the low‑code PyCaret library—explaining their unique advantages, typical use‑cases, and why they are expected to gain traction among data scientists.
This article introduces several Python libraries—including Optuna, ITMO_FS, shap‑hypertune, PyCaret, floWeaver, Gradio, Terality, and torch‑handle—that simplify hyperparameter tuning, feature selection, model explainability, visualization, and low‑code ML workflows, providing code examples and key advantages for each tool.
This article curates ten essential Python learning resources—including websites, books, open‑source projects, and community platforms—to help programmers deepen their knowledge and practice Python in a structured, Pythonic way.
This article compiles a comprehensive list of essential PyCharm shortcut keys, covering code editing, navigation, searching, running, debugging, refactoring, and general operations, to help Python developers work more efficiently and boost productivity.
This tutorial introduces pyecharts, a Python wrapper for Echarts, covering installation (including Tsinghua mirror), Python 2 compatibility, and step‑by‑step code examples for creating Bar, Pie, Boxplot, Line, Radar, Scatter, Grid, and Overlap charts with rendering to HTML.
This article demonstrates eight practical ways to leverage Python's built‑in modules directly from the command line—such as testing ports, launching a web server, formatting JSON, creating a simple editor, building executable archives, encoding/decoding data, retrieving system metadata, and compressing files—without writing any Python code.
This tutorial demonstrates how to build an interactive fruit‑sales dashboard using Python's Dash framework together with Tailwind CSS for styling, covering data preparation with Pandas, chart creation with Plotly, layout design, and deployment on a local server.
The article introduces trypackage, a lightweight Python CLI utility that automatically creates a temporary virtual environment, installs a specified package, launches an interactive shell with the package pre‑imported, and offers various options for Python version, shell type, persistence, and configuration.
This article introduces four fundamental sorting algorithms—bubble sort, insertion sort, merge sort, and quick sort—explaining their concepts, step‑by‑step operations, and providing complete Python implementations to help readers understand and apply these techniques effectively.
This article outlines four key areas for modern Python development—type hinting, virtual environment and package management tools, recent syntax enhancements like pattern matching and the walrus operator, and testing frameworks—providing practical guidance for writing robust, up‑to‑date Python code.
The February TIOBE Programming Community Index shows Python reclaiming the top spot for the fifth time, highlights a shift from Alexa to Similarweb for data collection, and provides detailed rankings and trends for the top 100 programming languages, offering developers insight into language popularity and future considerations.
This article introduces three popular Python libraries for building text‑based terminal user interfaces—Curses, npyscreen, and Urwid—explaining their features, installation steps, key code examples, and practical tips for creating interactive command‑line applications.
This article presents a collection of thirteen Python game development examples, each with a brief description, gameplay illustration, and complete source code using libraries such as pygame and PyQt5, covering games like coin collector, ping‑pong, skiing, space shooter, whack‑a‑mole, dinosaur runner, match‑3, Tetris, snake, 24‑point puzzle, balance beam, alien invasion, and tic‑tac‑toe.
This article explains the difference between dynamic and static typed languages, illustrates how Python's simple assignment works at the memory level, describes shared references, and shows how to use the built‑in type() function to inspect object types.
This article describes how a Python‑based diff utility was created to compare old and new API responses during a promotion change‑record migration, detailing its implementation, handling of JSON structures, improvements over the first version, and plans for integration with an API testing platform.
This tutorial shows how to use Python, OpenCV, and Pillow to capture, process, and animate Wuhan University’s cherry blossom scenes, turning pixel data into a time‑lapse video with custom text overlays and frame‑by‑frame control.
This article introduces a complete Python ski game built with Pygame, explaining the game mechanics, displaying screenshots of the interface and animation, and providing the full source code along with required image assets for readers to understand and recreate the project.
This article outlines ten lesser‑known Python security pitfalls—from optimized‑away asserts and directory permission quirks to path traversal, regex misuse, Unicode normalization attacks, and IP address normalization—illustrating how subtle language features can lead to serious vulnerabilities in real‑world applications.
This article walks readers through creating a classic Sokoban-style game using Python 3.6.4 and the Pygame library, covering environment setup, sprite and map class definitions, UI handling, game loop logic, and final integration with start, transition, and end screens.
The article explains how Python determines the order of evaluation for multiple operators by using precedence rules and associativity, lists the full precedence table, illustrates left‑ and right‑associative operators with examples, and offers best‑practice tips for writing clear expressions.
This article compares the lookup speed of Python lists and sets on large datasets, presents benchmark code and results, and explains why sets are dramatically faster by examining the internal C‑level implementations of list (dynamic array) and set/dict (hash table) including resizing rules and collision‑resolution strategies.
This step‑by‑step guide shows how to use Huawei Cloud ModelArts and the U‑2‑Net AI model to create a personalized portrait for Valentine’s Day, covering account registration, environment configuration, data and code download, dependency installation, generation, and result display.
This article presents a collection of practical Python tricks, covering efficient input handling, condition evaluation with all/any, odd‑even checks, variable swapping, palindrome detection, inline conditional expressions, duplicate removal, frequency analysis, list comprehensions, flexible argument passing, enumeration, string joining, dictionary merging, sorting, and pretty‑printing, each illustrated with clear code examples.
This guide explains how to use Python's requests library to brute‑force DVWA login pages at low and medium security levels, detailing code snippets, request headers, payload construction, response handling, and result logging to CSV or TXT files.
This article introduces a collection of practical yet under‑utilized Python capabilities—including arbitrary‑argument functions, file searching with glob, debugging with inspect, unique ID generation, hashing, serialization, compression, and atexit shutdown hooks—providing code examples and explanations for each.
The TIOBE Index released its February 2022 ranking, showing the top‑20 programming languages with Python, C and Java each gaining over 1% and highlighting shifts such as PHP re‑entering the top ten, Go climbing to 11th, and detailed listings for positions 21‑100.
This article presents two straightforward music recommendation methods—content‑based filtering using audio features and collaborative filtering using playlist data—detailing their design ideas, key Python and Go code snippets, model training, evaluation, and possible improvements.
This article introduces the GerapyPlaywright package, explains how to install it, configure Scrapy to use Playwright via middleware and PlaywrightRequest, and provides a complete example spider with code snippets and logging output for JavaScript‑rendered page crawling.
This tutorial demonstrates how to programmatically obtain a QQ Music QR‑code login session using Python by fetching the QR image, extracting and decrypting the required cookies, handling dynamic parameters, and completing the login flow with detailed code examples and explanations.
This tutorial demonstrates how to use Python and Selenium to automatically log in, upload videos and cover images, set titles, descriptions, tags, and publish short videos on the Qutoutiao platform, providing complete source code and step‑by‑step instructions.
This article provides a step‑by‑step Python programming tutorial for the traditional Chinese two‑player game "Gan Zi Lao Hu Ji Chong", detailing numeric mappings, conversion functions, round evaluation, and probability simulation to help learners build and test the game logic.
This article explains how probabilistic programming languages work and walks through building a minimal PPL in Python, covering model definition, latent and observed variables, DAG traversal, log‑density computation, and extensions such as posterior grid approximation.
