This tutorial walks Python developers through using the built‑in sqlite3 library to create, query, and manage SQLite databases, demonstrates how to connect with SQL clients like DBeaver, and shows seamless integration with Pandas data frames for advanced data handling.
This article uses Python to scrape and analyze Douban ratings, user comments, and Tencent video danmu for the TV drama “30 Only”, revealing the show’s explosive popularity, the most discussed characters, and audience sentiment through statistical charts and word‑cloud visualizations.
This article analyzes the intermittent “Instance XXX is not bound to a Session” error that occurs after converting a Flask‑SQLAlchemy endpoint from serial to multithreaded/gevent concurrency, reproduces the issue with test code, explains the root cause in session handling, and provides a concrete fix by patching gevent before session initialization.
Discover four practical Python techniques—list/dict/set comprehensions, namedtuple structures, enumerate/zip iteration, and f-string formatting—that boost code readability and efficiency, helping beginners transition from a simple “Hello World” to writing clean, maintainable scripts in their development journey.
This article explains why Python's ctypes returns incorrect values when invoking Go-compiled shared libraries, shows how to map C types correctly, and provides step‑by‑step code examples for handling both integer and string return values using proper restype declarations.
This article examines the prevalence of SQL injection attacks, presenting Imperva’s recent statistics, common attack vectors, real-world examples, and practical defenses such as prepared statements, input sanitization, and web application firewalls, while also offering Python code illustrations of secure and insecure database queries.
This article introduces chatbots, explains rule‑based and self‑learning types, describes how AI‑driven bots work, and provides a complete Python tutorial using the ChatterBot library—including environment setup, installation, and full source code for a functional chatbot.
Grid Studio is a web‑based spreadsheet that integrates Python, allowing users to read, write, and visualize Excel data with just a few lines of code, offering seamless installation, custom functions, and powerful data‑science tools like Plotly and Matplotlib for efficient data processing.
This article introduces eight essential Python libraries—Gensim, TensorFlow, SciPy, NumPy, Matplotlib, Pandas, Scikit‑Learn, and Keras—that empower developers to clean, prepare, merge, and accurately analyze data for effective data mining.
This article explains the fundamentals of ensemble learning and bagging, details the random forest algorithm, answers common questions, and provides a complete Python walkthrough—including data exploration, decision‑tree baseline, random‑forest modeling with grid‑search tuning, and practical insights for handling imbalanced and missing data.
This tutorial explains four practical methods—PyExecJS, js2py, Node.js, and PyV8—to execute JavaScript code from Python, providing code examples and tips for handling encrypted parameters during web crawling.
The article examines the challenges of creating a Python implementation for WebAssembly, questioning what core features—such as a REPL, dynamic compilation, sys.settrace, and frame inspection—are essential for a language to be recognized as Python, and how much compatibility can be sacrificed for performance.
Learn how to overcome Python's GIL limitations by compiling Go code into a shared .so library, invoking it from Python, and comparing performance gains, with step‑by‑step instructions, code examples, and troubleshooting tips for faster computation‑intensive tasks.
This article explores the career bottlenecks faced by programmers over 30, presents three practical transition paths—including project management, tech evangelism, and AI development—and provides a detailed, no‑code tutorial for building a facial‑recognition model with Huawei Cloud ModelArts.
This article provides a comprehensive overview of Python's three core time modules—datetime, time, and calendar—explaining their design, key concepts like epoch, UTC, DST, and demonstrating essential APIs for retrieving, converting, and manipulating dates and times.
PEP 618 proposes adding an optional strict flag to Python's built‑in zip function to raise errors when iterables have mismatched lengths, preventing silent data loss and making debugging of common zip‑related bugs easier.
This comprehensive tutorial walks you through installing PyCharm Community or Professional, creating and configuring Python projects, writing and running code, debugging, unit testing, version control integration, using plugins, and leveraging advanced features such as remote development and profiling, all illustrated with screenshots for macOS, Windows, and Linux.
This tutorial walks you through creating a Flask‑based search engine powered by Elasticsearch, covering configuration files, logging setup, blueprint routing with pagination, project startup using Flask‑Script, and production deployment with Gunicorn, complete with code examples and essential tips.
This tutorial walks you through creating a Flask‑based search engine backed by Elasticsearch, covering configuration files, a reusable logging setup, blueprint routing with pagination, and both Flask‑script and Gunicorn deployment options.
This article details the 2020 Tencent Advertising Algorithm Competition, describing the user profiling task, data fields, feature engineering, Python code for ID mapping and Word2Vec training, multiple model architectures (LSTM, CNN-Inception, transformer), and the final performance results achieved by the team.
This guide walks you through creating a Django project, configuring uWSGI and an INI file, setting up Nginx as a reverse proxy, enabling HTTPS with SSL certificates, collecting static files, and scaling the deployment for high availability, all with clear command‑line examples.
This tutorial walks you through creating a Python web scraper that extracts images from a target site, handles anti‑scraping measures, saves them into categorized folders, and logs the download results, while explaining the required libraries, code structure, and best practices.
This article reviews eight essential Python tools—including IDLE, Scikit‑learn, Theano, Selenium, TestComplete, BeautifulSoup, Pandas, and PuLP—explaining their main features, typical use cases, and why they are valuable for developers and students across web, data science, automation, and optimization tasks.
Explore essential Python tricks—from dictionary and set comprehensions to using Counter for counting, pretty‑printing JSON, and building a quick XML‑RPC file service—showcasing concise code snippets that illustrate the language’s clean syntax and powerful standard library.
This article presents a curated set of twenty NumPy exercises covering array creation, searching, calculations, processing, conversion, and storage, each accompanied by concise Python code solutions to help readers deepen their understanding of matrix manipulation in Python.
This article explains why Python lacks the ++/-- increment operators, covering the immutable nature of Python integers and how its powerful iterable constructs provide a cleaner alternative for iteration and value updates.
Learn how to build a Python web scraper that fetches upcoming movie details from Maoyan.com, covering environment setup, URL pagination, random User‑Agent handling, HTML parsing with XPath, data extraction, and result display, while highlighting best practices and limitations.
This article explains how to perform static analysis of Android APK files with Python, covering environment preparation, unpacking the APK, extracting basic metadata, analyzing classes and methods using the Androguard library, and generating a method call graph for deeper reverse‑engineering insights.
This article compares five popular Python visualization libraries—Matplotlib, Pyecharts, Seaborn, Plotly, and Bokeh—by drawing identical multi‑series bar charts, evaluating interactivity, aesthetics, code complexity, documentation quality, and assigning a subjective score to each.
This guide explains how to automate the creation of Jenkins jobs using Hubot plugins, shell scripts, and a Python‑jenkins library, detailing required parameters, installation steps, example scripts, and a help command for users.
This guide explains three ways to send emails using Python—built‑in smtplib, the third‑party zmail library, and the lightweight yagmail package—covering setup, code examples for constructing messages with attachments, and best practices for reliable email delivery.
This tutorial walks through building a simple Python web crawler that searches the Pansou site, handles AJAX‑loaded JSON data, extracts file links, and enables interactive downloading, illustrating core backend techniques such as HTTP GET requests, JSON parsing, and user‑driven pagination.
This guide walks you through setting up Anaconda, preparing UI component images, training a SimpleVGGNet model on macOS, and deploying the model as a Docker‑based service that can be queried via an HTTP API.
This article provides a comprehensive tutorial on Prophet's key parameters, their meanings, and practical tips for tuning them—including growth, changepoints, seasonalities, holidays, and Bayesian settings—along with Python code examples for grid search and cross‑validation to improve forecasting accuracy.
This tutorial explains how to use Baidu AI's Portrait Anime API with Python, covering token acquisition, API key setup, request formation, and code examples for generating both plain anime portraits and masked versions, complete with sample images and usage limits.
This tutorial walks through the test environment and demonstrates how InnoDB Cluster's built‑in functions—such as get_cluster, describe, list_routers, set_option, options, set_instance_option, set_primary_instance, switch_to_multi_primary_mode, switch_to_single_primary_mode, status, and dissolve—simplify the deployment, monitoring, and administration of MySQL group replication, complete with code snippets and visual results.
This tutorial shows how to fetch ten years of stock fundamentals using Tushare, compute a probabilistic "temperature" metric with NumPy and SciPy, and visualize the temperature alongside closing prices in Matplotlib, providing a complete end‑to‑end Python data‑analysis workflow.
This guide explains the essential HTTP request header fields—Accept, Accept‑Encoding, Accept‑Language, User‑Agent, Connection, and Host—detailing their meanings, typical values, and how to use them to disguise a Python crawler and reliably fetch web pages.
This guide walks through creating a browser‑based face login system by capturing video with getUserMedia, processing frames with Baidu's facial analysis API and the Python face_recognition library, and integrating the workflow with front‑end HTML/JavaScript and back‑end handling of image data.
This article uses Python to scrape and analyze over 2,900 Chinese university and major data points, revealing trends in Gaokao participation, provincial enrollment, university types, popularity rankings, and public curiosity about majors, all illustrated with charts and code examples.
The article argues that Go+, by preserving Go's concise syntax while adding Python‑like type inference and tensor support, can address Python's flexibility‑induced code‑quality and performance issues, making it a viable front‑end language for data‑science, deep‑learning libraries, and compiler ecosystems.
This article introduces the fundamentals of object‑oriented programming in Python, contrasting procedural and OOP approaches, explaining classes, objects, their attributes and methods, and provides step‑by‑step code examples—including class definition, object creation, method invocation, and property manipulation—to help beginners grasp OOP concepts.
After years of using Python for AI and data science, the author examines its flexibility drawbacks and argues that Go+, with its static typing and concise syntax, can address Python’s limitations, offering comparable ease for tensor operations, potential for a new deep‑learning front‑end language.
This tutorial explains how to analyze Meituan food page URLs, use browser developer tools to locate AJAX JSON responses, construct Python requests with proper headers, extract restaurant information via regular expressions, and save the results to a local file.
The article explains the historical and technical reasons why most programming languages adopt zero‑based indexing for arrays and loops, illustrating the concept with C, Python and early languages, and showing how zero‑based offsets simplify pointer arithmetic and enable elegant slice syntax.
This article analyzes 13,966 Chinese operations‑engineer job postings scraped from 51job, cleaning the data with Python and Pandas, then visualizing industry demand, city concentration, salary ranges, education requirements, company size distribution, and keyword trends to guide job seekers and recruiters.
This guide walks through preparing the environment, configuring the master and slave MySQL servers, and using Python's Paramiko library to automate SSH commands, edit configuration files, restart services, and verify replication, all while handling common pitfalls.
This tutorial walks through building a Python program that uses OpenCV to reduce colors and enhance edges for cartoon‑style conversion, then wraps the process in a simple Flask web app for uploading images and displaying the resulting cartoons.
This article analyzes 13,966 Chinese operations engineering job postings collected from 51job, detailing scraping methods, data cleaning steps, and visualizations that uncover top hiring industries, city demand, salary ranges, required education, company size distribution, and keyword trends for the ops market.
The article explains why programming has become essential for software testers, compares Java and Python for automation, and offers practical ways—continuous coding, problem‑solving on OJ platforms, and project practice—to steadily improve coding ability.
This tutorial shows why learning Python is valuable and walks you through four fun projects—drawing Peppa Pig with the turtle library, changing image backgrounds using OpenCV, splitting images into a 3×3 grid with Pillow, and creating dynamic QR codes with MyQR—complete with code examples and visual results.
This tutorial explains how to crawl 58.com job listings with Python, extract location, company, and salary information, handle anti‑scraping defenses using realistic headers and random User‑Agents, and save the results into a text file.
This guide shows pandemic graduates how to create AI‑generated personalized graduation photos with Huawei ModelArts, locate optimal rental housing using Python‑driven web scraping and Gaode maps, and accelerate job preparation through Huawei Cloud Classroom courses and coding practice, turning a challenging season into a tech‑enabled opportunity.
This tutorial introduces Python’s Requests library, covering installation, core methods like GET, POST, PUT, PATCH, DELETE, detailed parameters, session handling, exception management, header customization, proxy usage, and practical code examples to empower effective web scraping.
Python 3.9.0b4, the fourth beta of the upcoming 3.9 release, introduces several new language features and standard‑library updates—including PEP 584 dict union operator, PEP 585 generic types, new PEG parser, enhanced Unicode support, and various performance and security improvements—providing the community an opportunity to test and prepare for the final version.
This guide introduces Django, a Python-based open‑source web framework, covering its definition, installation commands, key advantages, architecture, and the MVT design pattern to help developers decide if it fits their projects in modern development.
Using Python, the author analyzes Shandong’s 2020 Gaokao simulation scores, visualizing distribution patterns, pass rates, subject selection ratios, top‑student combinations, and double‑first‑class university admission thresholds, providing data‑driven insights for students and educators.
This guide explains how to configure an Android project, write Python upload scripts for Fir.im and Pgyer, create a Jenkinsfile with checkout, build, and upload stages, set up Jenkins global variables and pipeline parameters, and run a full build‑test cycle to publish APKs via QR codes.
This tutorial walks you through building a Python script that scans a given directory, extracts all files, and automatically organizes them into separate folders based on their file extensions, demonstrating practical use of the os, glob, and shutil standard libraries.
After mastering basic software testing, this article analyzes why learning a programming language—especially Java or Python—is essential for test automation engineers, compares their strengths, career prospects, and practical usage, and offers guidance on choosing the right language for beginners and career transitions.
This tutorial demonstrates how to use Python's OpenCV library to read and display images, perform resizing, convert to HSV, apply binary thresholding, execute erosion and dilation, and replace specific pixel colors, providing step-by-step code examples and visual results for each operation.
This article introduces Python’s magic methods, explains their purposes and usage, provides a comprehensive table of common dunder methods, and demonstrates practical examples—including object creation, attribute handling, container behavior, and context management—to help developers master these powerful language features.
This guide walks through Python file I/O by comparing manual Windows text handling to code, explains file handles, demonstrates reading and writing with various modes, clarifies read vs. readline vs. readlines, and shows how to efficiently process large files without exhausting memory.
This article presents a complete data‑analysis workflow that scrapes Bilibili video metrics from January 2019 to March 2020, cleans and preprocesses 50,130 records, and extends the classic RFM model into an IFL framework—calculating interaction, frequency and like rates—to score and rank up‑creators across multiple categories, with code and datasets provided for replication.
This tutorial demonstrates how to combine Excel’s interactive features with Python’s Pandas library to perform comprehensive data operations—including reading, generating, filtering, sorting, handling missing values, deduplication, merging, grouping, calculation, statistics, visualization, sampling, pivot tables, and VLOOKUP—showing when each tool excels.
This article describes Suning's Python‑based automation framework that bridges web applications and SAP systems using keyword‑driven testing, socket communication, and remote agents, dramatically reducing manual testing time, improving coverage, and achieving a ten‑fold reduction in labor while maintaining robust, configurable automation.
This article explains Python's import system, covering absolute and relative import syntax, package structure, execution contexts, and typical errors, while providing clear code examples and practical guidelines for correctly organizing and running modules.
The article demonstrates how to scrape over 200,000 iQiyi danmu comments for the drama “The Bad Kids” using Python, then analyzes user activity, episode popularity, top comments, actor mentions, and visualizes the results with word clouds and charts.
This guide walks you through creating a Python Flask project, manually building and running its Docker image, configuring GitLab runners, writing a .gitlab-ci.yml pipeline for style checks, tests, deployment, and release, and managing a private Docker registry for versioned releases.
This article demonstrates how to scrape bullet comments from iQiyi for the first episode of a popular mystery series, decode the binary files, extract the text, and use Python's jieba and wordcloud libraries to clean the data and generate a visual word cloud of audience sentiments.
This article presents a Python-based method for quickly profiling dozens of large database tables by generating and executing column‑wise SQL queries, avoiding full table reads, and exporting the results to an Excel file for easy analysis.
This article introduces Python’s struct module, explaining how it converts between bytes and other binary data types, detailing its functions, format strings, alignment options, and practical examples of packing, unpacking, and size calculation for efficient binary data handling.
This article surveys the rise of microservices, explains their advantages, and provides a concise overview of the most popular Java, .NET, Node.js, Go, and Python frameworks that enable developers to build scalable, loosely‑coupled services.
This article explains how to unpack Power BI .PBIX files, parse the layout JSON to retrieve widget positions, used fields, and settings, and then use Python and Pandas to generate a concise data frame of all unique fields, ultimately building a Flask‑based web tool for easy visualization.
This article demonstrates how to scrape BI engineer job listings from Zhaopin.com using Python, clean and enrich the data, and create visual analytics with FineBI to reveal salary trends, city distribution, experience levels, and education requirements in the Chinese job market.
PyDebloatX is a lightweight Python‑based GUI tool that lists and uninstalls pre‑installed Windows 10 apps such as Clock, Calendar, Maps, Weather, and Photos, offering simple shortcuts, clear prompts, and a GitHub repository for further customization.
Using Python to scrape 4,277 Zhihu answers about changing WeChat IDs, this article shows how the data was collected, presents the extraction code, and uncovers six surprising patterns in users' chosen usernames, illustrating social trends behind the recent feature update.
This tutorial shows how to fetch historical stock data from Yahoo Finance using pandas, compute moving averages and returns, explore correlations among major tech stocks, engineer features, train linear, polynomial, and K‑Nearest‑Neighbour models with scikit‑learn, evaluate their accuracy, and visualize both historical prices and future forecasts, all in a concise, step‑by‑step guide.
This tutorial explains how to use Python, Appium, and OpenCV to automatically perform WeChat’s “punch” (拍一拍) action by locating a friend’s avatar via image recognition and simulating a double‑tap, all within roughly 30 lines of code.
This article explains how Python stores every value as an object in memory, how reference counting works to track object usage, and how the garbage collector frees objects when their reference count drops to zero, illustrated with interactive code examples.
Job listings often demand “proficient in Java or Python,” but the term’s true meaning varies by role; it simply indicates the ability to solve the problems you’ll face, with the required depth depending on the specific technical demands of the position.
A Bilibili creator named NyeJu generated 120,000 lines of compilable C++ code that, through precise color‑coded patterns, animates a singing, dancing, rap‑performing version of Cai Xukun, detailing the workflow from theme selection to frame‑by‑frame color mapping and automated code generation.
The article provides a comprehensive guide to Python libraries essential for data analysis, detailing tools for data acquisition (Selenium, Scrapy, Beautiful Soup), cleaning (spaCy, NumPy, pandas), visualization (Matplotlib, Pyecharts), modeling (scikit‑learn, PyTorch, TensorFlow), model inspection (LIME), audio (Librosa), image processing (OpenCV, scikit‑image), database access (PyMongo) and web deployment (Flask, Django).
This article introduces Python’s built‑in interpreter, popular text editors such as Geany and Sublime Text, powerful IDEs like PyCharm and Jupyter Notebook, demonstrates code refactoring techniques, and explains how to integrate these tools with public cloud services such as Huawei ModelArts for seamless local‑cloud development.
This tutorial walks through building a PyQt5 desktop interface with Python 3.7 and MySQL 5 that connects to a local database, displays its tables, allows inline editing, manages table scrolling, and provides a custom right‑click menu for row insertion and deletion.
This article explains Python error handling using try...except...finally, demonstrates how to interpret tracebacks, and introduces debugging techniques such as print statements, assertions, and the pdb module, providing code examples and practical guidance for developers.
This article surveys the 22 most downloaded Python packages on PyPI, explains their primary functions, shows typical usage examples, and discusses why they are so popular across various development scenarios, providing practical insights for Python developers.
This guide shows how to route Zabbix alarm messages through a Kafka cluster and then deliver them to Enterprise WeChat using Python scripts, covering host configuration, Kafka/Zookeeper startup, topic creation, alert‑sending scripts, and Zabbix action setup.
This tutorial demonstrates how to convert PDF admission lists into Excel, extract and filter candidate information using Python, compute score segment statistics, and generate bar and pie charts with pyecharts for clear visual insight into graduate enrollment data.
This article walks through a Python‑based exploratory analysis of a public heart‑disease dataset, loading the data, describing its 14 clinical features, visualizing gender, age, heart‑rate, blood‑pressure and cholesterol relationships, and presenting correlation insights to help understand patterns of disease prevalence.
This article walks through using Python's os and shutil modules to obtain the system drive, list and delete files, create a startup entry, and force a Windows shutdown, illustrating a lightweight, educational example of a hacking‑style tool.
This tutorial introduces the Python tqdm library, shows how to install it, explains its three usage modes, and provides clear code examples for displaying real-time progress bars during long loops, helping developers monitor elapsed time effectively.
This tutorial walks through creating a Python script that scrapes video URLs from a web page, downloads them in batches with proper buffering, and displays a real‑time progress bar, covering page analysis, code implementation, and practical tips.
This article presents a collection of concise Python one‑liner techniques covering integer summation, list deduplication, list comprehensions, value swapping, length‑based sorting, character counting, whitespace removal, Chinese character regex, element doubling, and generating a multiplication table, each illustrated with brief explanations and code snippets.
This tutorial walks you through building a Python web scraper that extracts recipe names, ingredients, and download links from the XiaChuFang cooking website, handling anti‑scraping measures with custom headers and fake user agents, and saves the collected data into a Word document for future use.
This guide outlines why manual testing can’t fully replace automation, then walks you through seven concrete steps—including data preparation, API testing, and web UI automation using tools like MySQL, Redis, SOAP UI, Postman, and Selenium with Java or Python—to become a proficient automation test engineer.
This article explains the classic Dutch National Flag problem, describes the three‑way partition algorithm with pointer analysis, and provides concise Python and Go implementations that sort an array of red, white, and blue elements in linear time and constant space.
The article explains why Python developers often swap the arguments of datetime.strptime, analyzes the naming and semantics of strptime and strftime, demonstrates correct usage with code examples, and discusses the source‑to‑destination pattern and related special cases such as regex and string methods.
The article recounts three technical interview problems—a list‑index extraction using a hash map, a tree‑path reconstruction from parent identifiers, and a minimum‑path‑sum dynamic‑programming challenge—providing Python code solutions and brief explanations for each.
This tutorial demonstrates how to import Excel data into Pandas, reproduce IF and VLOOKUP functionality, and generate pivot tables with Python, highlighting the differences between Excel and Pandas and showing why Python can be a more reusable and scalable solution for data analysis.
