This article explains the MySQL client‑server handshake, details the sequence of packets exchanged during a TCP connection, and provides a complete Python implementation that builds a raw TCP socket to connect, authenticate, and communicate with a MySQL server without using a high‑level driver.
This guide demonstrates how to create a complete GitLab CI pipeline for a Python Flask application, covering dependency installation, code compilation, testing, static analysis, Docker image building, and Kubernetes deployment, with detailed configuration snippets and a sample Dockerfile.
This article explains the limitations of Python's GIL, compares synchronous and asynchronous execution models, introduces asyncio and aiohttp, provides concrete code examples for single and multiple concurrent HTTP requests, and offers solutions for common concurrency errors such as too many file descriptors.
This article presents ten practical Python tricks—including string reversal, variable unpacking, itertools usage, slicing, grouping adjacent items, generator next(), Counter, and deque operations—demonstrating how to leverage built‑in functions and standard‑library modules to write cleaner, more efficient code.
TextShot is a Python-based OCR utility that captures a screen region and instantly converts the image into editable text, leveraging Tesseract and optional language parameters, with installation steps, hotkey integration, and guidance on image preprocessing for improved accuracy.
Explore eight distinct methods for importing Python modules—from the simple 'import' statement to advanced techniques like __import__, importlib, imp, execfile, exec, the import_from_github_com package, and custom remote importers—providing practical code examples and guidance for both everyday developers and framework creators.
This guide walks you through building a Python web‑scraping project that overcomes common anti‑scraping defenses, extracts QQ numbers from a target site, and saves the results into structured Excel files, while highlighting required libraries, request headers, and AJAX handling techniques.
This tutorial demonstrates how to use Python's platform module and /proc filesystem to gather Linux system and hardware information, format it into a report, extend the script to send the report via SMTP email, add timestamps, and schedule periodic execution with cron.
This article introduces several powerful pure‑Python features—lambda functions, list comprehensions, and the zip function—demonstrating how they can simplify data cleaning, feature engineering, and iterative processing with concise code examples, helping programmers reduce reliance on external libraries while improving productivity.
This tutorial walks you through creating a Python web scraper that fetches image URLs from 51miz.com using requests and lxml, filters them with regular expressions, downloads the images, and demonstrates the complete workflow with code snippets and screenshots.
This article provides a comprehensive guide to Python's multiprocessing module, covering how to create and manage processes, use join for synchronization, configure daemon processes, and employ synchronization primitives such as Lock, Semaphore, Event, and Queue for safe inter‑process communication, with complete code examples.
This article introduces the community‑maintained SpaceX REST API that aggregates all launch, vehicle, and payload data, explains how to query it using tools like Postman or Python, and provides deployment options via Docker or local npm setup for developers.
Learn how to set up a Python environment on an Ubuntu ECS, install the presto‑python‑client and PyHive libraries, configure Kerberos and SSL credentials, run sample queries against a Presto coordinator, and avoid typical errors such as NTP, SSL and authentication issues.
This tutorial walks through building a Python web scraper that fetches anime torrent links from the Mikan Project site, handles pagination, bypasses anti‑scraping measures, parses pages with lxml, and saves the .torrent files locally, complete with code snippets and screenshots.
This article examines the implementation details of Python's == and is operators, showing how both are compiled to COMPARE_OP bytecode with different opcodes, exploring the underlying C functions like cmp_outcome and object_richcompare, and explaining the rich comparison protocol and its default behavior.
This tutorial explains how to create a Python CLI application named tickets that parses command-line arguments, retrieves station codes, queries the 12306 railway API for ticket data, and displays the results in a formatted table using libraries such as docopt, requests, and prettytable.
This guide walks through building a Python web‑scraper that fetches house names, prices and popularity from Lianjia, formats the data into a Word template, and generates individual Word documents while demonstrating key libraries, URL handling, HTML parsing, and best‑practice considerations.
This guide walks you through setting up Python 3.6.9 on Ubuntu 18.04, installing virtualenv and virtualenvwrapper, configuring the shell, and using common commands to create, activate, list, and delete isolated Python environments, complete with step‑by‑step code snippets and screenshots.
This tutorial introduces Python's official IDLE editor for version 3.8.2, guiding users through launching the environment, configuring key options, creating and saving a new .py file, writing a simple 'Hello World' program, and executing it while explaining the interpreter's behavior.
This article explains how Tubi Data Runtime (TDR) streamlines data access on JupyterHub by introducing an optimized Redshift connector, custom SQL cell magic, and JupyterLab extensions for data exploration, reducing latency and resource usage while enhancing collaboration and usability for data scientists and engineers.
This guide explains how to install the Elasticsearch Python client, build a wrapper class for index management and CRUD operations, import data from MongoDB, use a Celery‑based crawler to harvest Baidu Baike content, and expose search functionality through Flask or other Python web frameworks.
This article demonstrates how to employ Pandas' read_html function to quickly fetch, parse, and analyze the Wikipedia table of the world's richest billionaires, covering basic usage, ranking by net worth, selective column extraction, and advanced parameter options.
The article explains how MySQL Shell 8.0.17+ can be extended using JavaScript or Python to build reusable reports and plugins, describes the directory layout, provides a complete example of registering a report and a plugin that list tables without primary keys, and shows how to invoke them via \show, \watch or direct function calls.
This tutorial demonstrates how to use Python's requests, threading, and queue modules to build a multithreaded crawler that extracts game names, download links, and execution time from the Xiaomi App Store, complete with code examples and performance tips.
This article explains the LeetCode 88 problem of merging two sorted integer arrays, presents two solution approaches—simple concatenation with sorting and an optimal two‑pointer technique—and provides implementation examples in C++, Python, and Java to illustrate the concepts.
This article introduces Python's re module, explains core regex functions such as match, search, replace, and compile, demonstrates practical code examples with images, and shows how to apply regular expressions for web‑scraping tasks.
This article walks you through updating pip on Ubuntu, listing fast domestic mirrors, configuring pip to use a new source, and demonstrates the dramatic download speed improvement you can achieve with a simple command-line change.
This article demonstrates how Python's pandas library can replace manual Excel operations by reading, calculating, sorting, filtering, and visualizing data, offering efficient solutions for large datasets and showcasing code examples for automatic column filling, price adjustments, and student score analysis.
The article demonstrates how to solve a sixth‑grade geometry problem by programmatically drawing the figure with Python, randomly sampling points inside a rectangle, and estimating the shaded region's area through Monte‑Carlo simulation, achieving results close to the exact answer.
This tutorial demonstrates how to automate Excel report generation using Python libraries xlwt, xlrd, and xlutils, covering installation, creating workbooks, writing and merging cells, reading data, applying formulas, and saving files to specific directories with complete code examples.
This guide walks you through setting up and managing Python virtual environments on Linux Ubuntu 18.04 using virtualenv and virtualenvwrapper, covering installation, configuration, common commands, and tips for handling multiple project dependencies, illustrated with step‑by‑step commands and screenshots.
This article provides a comprehensive, step‑by‑step guide to using pandas for data preprocessing, merging, indexing, sorting, grouping, extraction, filtering, sampling, and statistical analysis, complete with clear code examples and visual results to help readers master essential data manipulation in Python.
This tutorial shows how to install PaddlePaddle and PaddleHub, then use a concise Python script to batch‑remove backgrounds from multiple photos, automatically saving the segmented results, and includes sample code and before‑after images to illustrate the process.
This article explains Python's threading module, demonstrating how to import it, create and manage single and multiple threads, use thread locks (Lock and RLock), condition variables, semaphores, events, thread‑local storage, and timers, providing complete code examples for each concept.
This tutorial shows how to celebrate 520 with Python by drawing hearts, roses, and a starry‑sky confession using turtle graphics, pygame, and image‑processing code, providing beginner, intermediate, and advanced examples complete with source code and visual results.
This article explains how to create a counter using Python closures, explores three different implementations—including mutable objects, generators, and the nonlocal keyword—while clarifying the behavior of immutable vs. mutable objects and demonstrating the practical use of nonlocal in nested functions.
This tutorial walks through essential pandas operations—including importing modules, building a sample shopping dataset, reading and writing CSV files, inspecting data structures, and performing thorough data cleaning such as handling missing values, trimming spaces, case conversion, replacements, deletions, duplicate removal, type casting, and column renaming—complete with code snippets and visual results.
This guide walks through setting up a private Kubernetes environment, configuring namespaces and service accounts, modifying Eureka for IP registration, preparing Docker and Harbor authentication, creating StatefulSet and Service manifests, and automating continuous deployment with a Python script, enabling a fully functional Spring Cloud Eureka service in a resource‑constrained cluster.
This tutorial explains how to build a Python web‑scraper that searches Baidu Tieba by keyword, bypasses anti‑crawling measures, extracts image and video URLs with XPath, and saves the media files locally, complete with code examples and setup instructions.
This guide walks through setting up a complete CI/CD pipeline for a SpringBoot micro‑services project using Jenkins, Docker, Harbor, GitLab, and Python scripts to build, package, and deploy containers onto a Kubernetes cluster, covering environment installation, configuration, and testing steps.
This article introduces Python’s fundamental data types—including numbers, strings, lists, tuples, sets, and dictionaries—explains their mutability, demonstrates variable assignments, type checking, and common built‑in functions with clear code examples, helping beginners quickly grasp and apply these essentials in their programs.
This article introduces Python's set collection, covering its definition, unique characteristics, creation methods, common operations such as adding, updating, deleting, immutable frozenset usage, and set mathematics, while comparing it with lists, tuples, and dictionaries to highlight proper data‑structure selection.
The article demonstrates how a programmer can replace tedious manual Excel operations by using Python and pandas to batch‑process 128 sales spreadsheets, calculate brand‑level revenue, and dramatically reduce processing time from hours to seconds, illustrating a practical data‑analysis workflow.
This article explains Python closures and decorators, illustrating how closures capture free variables and how decorators can wrap functions to log calls, handle parameters, and preserve metadata, with clear code examples and step‑by‑step explanations.
This tutorial walks through a complete Python workflow for analyzing a month of Taobao mobile app data, covering data import, cleaning, feature engineering, traffic and behavior metrics, funnel conversion, RFM segmentation, and visualizations to reveal user patterns and business performance.
This tutorial shows how to turn a loved one's photo into a heart‑shaped mosaic made of the phrase “I love you” using Python, OpenCV, and PIL by extracting pixel colors and drawing colored text onto a new image.
Bruce Eckel suggested removing the explicit 'self' parameter from Python class methods, but this article explains why keeping 'self' is essential for clear instance referencing, error messages, method types, decorators, and language compatibility, arguing that the proposal would introduce ambiguity and break existing conventions.
This article demonstrates how to build a Python web scraper for Toutiao that leverages a multiprocessing pool, identifies AJAX endpoints, fetches JSON data, extracts titles and image URLs, handles Unicode encoding, and downloads images into organized folders.
This article introduces Python’s core data structures—lists, tuples, and dictionaries—explaining their definitions, indexing, slicing, iteration, modification, and common operations, and provides clear code examples for creating, accessing, updating, and deleting elements, helping beginners deepen their programming fundamentals.
This article explains the concept of Python decorators, demonstrates how they can replace repetitive input‑type checks in multiple string‑manipulation functions, and shows both the explicit decorator implementation and the concise @ syntax with clear code examples.
This tutorial explains Python 3.6's f‑string formatting, covering basic usage, expression evaluation, lambda functions, quoting rules, brace escaping, padding, numeric specifiers, width/precision control, date formatting, and a complete multiplication‑table case with code samples.
This article examines Douban ratings and 500 user comments for the Chinese web drama "Dragon Tomb Cave", visualizes rating distribution, comment timing, geographic origins, and compares sentiment with other series using Python web‑scraping and data‑visualization techniques.
This article presents a combinatorial fish‑division puzzle solved by exhaustive search with Python code, followed by clear explanations and Python implementations of three fundamental sorting algorithms—merge sort, selection sort, and bubble sort—illustrating their core ideas and step‑by‑step processes.
This tutorial compares static Matplotlib/Seaborn visualizations with interactive Plotly charts for stock price data, explains when to choose each library, and provides step‑by‑step Python code for fetching data, creating scatter and 3D surface plots, and installing Plotly in offline mode.
The article details how a data analyst scraped comments from Zhihu, Weibo, and Bilibili about the 2020 Youth Day video “后浪”, applied Baidu AI sentiment analysis and Python word‑cloud generation, and compared the differing emotional tones across platforms.
This article introduces Boa, a Node.js library that bridges CPython, enabling JavaScript developers to import and use Python packages—especially machine‑learning libraries like PyTorch—seamlessly within Node.js, complete with practical code examples and API explanations.
This article demonstrates how Python functions can receive list arguments, modify them permanently, and how to pass a copy to prevent changes, illustrating the effects with clear code examples and output results.
This article examines Python execution speed by benchmarking simple arithmetic, logical checks, built‑in functions like max, and three class‑based point‑in‑rectangle implementations, revealing that straightforward if‑statements are often fastest while highlighting practical tips for writing performant Python code.
This article introduces several Python iteration tricks—including zip for parallel loops, C‑style range loops, filter for selective processing, enumerate for indexed iteration, and sorted for ordering data—providing concise code examples that make loops more efficient and readable.
This article introduces Python's basic syntax, execution order, coding conventions, common operators, input/output handling, conditional statements, ternary expressions, and loop structures, and demonstrates a simple dice‑guessing game that highlights the use of break and continue.
This tutorial walks you through creating the classic green WeChat logo with Python's Matplotlib library, covering canvas setup, logo component analysis, and step‑by‑step code for ellipses, eyes, and arrows to produce a complete graphic.
This guide walks you through setting up a Python environment, installing required libraries, writing a FilmSky class with request handling, parsing HTML using regular expressions, and saving movie titles and download links, providing a practical example of web crawling for movie sites.
Using a dataset of over 9 million baby records and 30 000 transaction entries, this analysis explores market trends, seasonal sales patterns, product popularity, and user demographics in China’s mother‑baby e‑commerce sector, revealing the impact of holidays, promotional events, and low repeat‑purchase rates on overall performance.
Discover ten powerful PyCharm shortcuts and features—from automatic imports and batch refactoring to quick navigation and code cleanup—that can dramatically boost your Python development efficiency, streamline workflow, and help you write cleaner code with fewer keystrokes.
This tutorial walks through creating a PyQt5 desktop program in Python 3.7 that connects to a MySQL 5 database, displays table contents, enables editing, custom right‑click menus, and scroll‑position control, providing a complete example for beginners and intermediate developers.
This tutorial walks you through extracting image URLs from a webpage using XPath, constructing full URLs, and automating batch downloads with Python's requests, lxml, and fake_useragent libraries, including code snippets and practical tips for handling files and headers.
An experienced Python engineer shares three indispensable tools—Kite for AI‑powered code completion, Mypy for static type checking, and SonarLint for real‑time linting—explaining their benefits, usage examples, and how they improve coding speed, reliability, and error detection.
This guide demonstrates how to programmatically pull date, title, and document number fields from thousands of similarly structured Word tables, normalize the dates, and export the data into a formatted Excel spreadsheet using Python's docx, datetime, and openpyxl libraries.
On April 20, 2020, the Python core team released Python 2.7.18, the last official version of Python 2, concluding a two‑decade release history that began with Python 2.0 in 2000 and marking the end of maintenance for the legacy language.
This article provides a comprehensive step‑by‑step guide to installing Scrapy, understanding its core components and processing flow, creating a weather‑data crawling project, writing items, settings, middlewares, spiders, running the crawler, exporting results, and storing the scraped data into MongoDB.
This article explains the two key properties of recursive functions, demonstrates Python's default recursion depth limit and how to adjust it, discusses the drawbacks of recursion, and presents a programming task to implement a recursive Fibonacci‑triangle generator with sample code.
This tutorial demonstrates how to read an Excel file with pandas, convert an 8‑digit birthdate column to datetime, calculate age, and then use groupby to produce aggregated statistics by age and gender, including combined summaries for all students and females only.
This article introduces Python's core concepts and hierarchy, highlights ten frequent beginner mistakes, and walks through building a basic web scraper that extracts book information from Douban, processes it with pandas, and displays the resulting data, providing a practical learning path for Python fundamentals.
This article explains how to implement a priority queue in Python using the built‑in heapq module, demonstrates extracting smallest and largest elements from price lists, and provides a full PriorityQueue class with push, pop, and is_empty methods, illustrated with stock portfolio examples.
This guide explains how to configure an Android project, write Python scripts for uploading APKs to Fir.im and Pgyer, create a Jenkinsfile with checkout, build, and upload stages, and set up Jenkins global variables and pipeline parameters for automated CI/CD deployment.
This tutorial walks you through creating a desktop Python chatbot using the Turing API, covering required libraries, authentication, code implementation for both basic and Selenium‑enhanced versions, and packaging the final program into an executable.
This tutorial walks through multiple Python approaches for downloading files—including simple requests and wget calls, handling redirects, large and multi‑file downloads, proxy usage, urllib/urllib3 methods, and asynchronous techniques—providing complete code snippets and practical tips for each scenario.
This tutorial shows how to fetch restaurant review data from online platforms, clean and structure it in Python, and then use pyecharts along with Python's Counter to create bar and pie visualizations that reveal overall impressions and star‑rating distributions.
This guide walks you through using Python to crawl proxy server data, extract city names with the cpca library, count occurrences per city, and create an interactive heat‑map of nationwide proxy distribution using the Pyecharts visualization toolkit.
This article compiles essential readings on Python programming, covering functional programming, performance optimization, testing practices, and coding standards to help developers become proficient and write high‑quality, maintainable code.
After months of trial and error, I share my step‑by‑step journey of creating a Python web scraper that collects Zhihu and Weibo hot‑list data, exposing it via a Django REST API, and integrating the results into a functional WeChat mini‑program, while outlining the challenges and future improvements.
This tutorial walks through analyzing a proxy‑listing website’s structure, building a Python scraper using requests, Scrapy, regular expressions and BeautifulSoup, extracting IP, port, location and type fields across multiple pages, and saving the collected data to files, illustrating key web‑crawling techniques.
This article explains Python's variable scope rules, demonstrates how local variables shadow globals, and shows how the global keyword enables functions to modify global variables, illustrated with clear examples and visual results.
This tutorial explains how to overcome common anti‑scraping defenses of a proxy‑listing website by capturing legitimate HTTP headers with Fiddler, configuring the Python requests library, and building a dynamic proxy pool to keep your crawler running smoothly.
Learn how to create a practical employee smart‑check‑in tool with just 12 lines of Python code by capturing mobile MAC addresses via a USB Wi‑Fi adapter, using scapy and pandas on Ubuntu, and automatically logging attendance without expensive hardware.
This article explains how the Mars framework enables parallel and distributed execution of core Python data‑science libraries—Numpy, Pandas, and Scikit‑Learn—while integrating with RAPIDS for GPU acceleration, and demonstrates its performance advantages through code examples and benchmark results.
This article walks through the complete engineering workflow for building an image‑search system, covering CNN‑based feature extraction with VGG16, vector normalization, image preprocessing, black‑edge removal, and practical deployment of the Milvus vector database including hardware requirements, capacity planning, collection/partition design, and search result handling.
This article benchmarks several Linux techniques—including rm, find, rsync, Python, and Perl—for deleting 500,000 small files, measuring execution times and revealing that rsync with the --delete option completes the task in under 20 seconds, far outpacing traditional commands.
This article explains why iterating over Pandas DataFrames with iterrows() is slow, demonstrates the performance gain of using itertuples()—often over a hundred times faster—and provides a simple example to help Python data‑analysis practitioners write more efficient code.
This tutorial walks you through creating a web‑based employee management system that demonstrates MongoDB CRUD operations using Python, Flask, and Pipenv, covering project setup, environment configuration, code implementation for querying, adding, updating, and soft‑deleting records, and how to run the application.
This article completes a FastAPI series by detailing middleware usage, request redirection, trusted host and CORS settings, background task handling, custom HTTP status responses, and multiple deployment options—including Uvicorn, Gunicorn, Docker, and Nginx—accompanied by full code examples.
This article explains how to create a JetBrains IntelliJ plugin that parses MySQL DDL statements, performs lexical analysis to extract table and column information, and automatically generates corresponding Python ORM model classes, illustrating the underlying state‑machine lexer, recursive parsing logic, and sample code.
This article explains why Python dictionary keys with numeric values can overwrite each other, how a return statement inside a try block is overridden by a return in a finally block, and why object identity (is) and hash values behave as they do, illustrating each point with code examples.
This article demonstrates how to create a custom Python SDK for Pinduoduo's order-related APIs, covering request signing, parameter assembly, URL encoding, and example calls to retrieve order lists, details, status, and incremental updates, complete with sample code and usage screenshots.
This tutorial explains how to install PyMongo, connect to local or remote MongoDB instances, choose databases and collections, and perform all common CRUD operations—including inserts, queries, updates, deletions, and special cases—using Python code examples and practical tips.
This article examines the severe time‑critical pain points of bank database operations, explains why AI‑based intelligent ops are needed, describes the platform architecture, unsupervised algorithms (3σ, Isolation Forest, DBSCAN, Pearson, Apriori), and presents a real‑world case study that demonstrates anomaly detection, root‑cause analysis, and practical optimization recommendations.
DeepMatch is an open‑source Python library that implements several mainstream deep‑learning based recall‑matching algorithms, provides easy installation via pip, detailed usage examples with code, and supports exporting user and item vectors for ANN search, making it ideal for rapid experimentation and learning in recommendation systems.
This article explains the fundamentals of Python class inheritance, covering five typical ways to use parent class attributes and methods—including direct calls, super() for private members, method overriding, invoking __init__, and passing initialization parameters—accompanied by clear code examples.
This article demonstrates how to import Bitcoin price data, preprocess it, and use Matplotlib's fill_between, bar, and FuncAnimation functions to generate static and animated area charts, including code snippets, parameter explanations, and tips for exporting the animation as GIF or MP4.
This tutorial walks through using Python to fetch QQ Music song rankings, lyrics, and hot comments, then iterates through comment pages to collect data and generate a word‑cloud visualization, illustrating the required libraries, code snippets, and key parameters.
