BestHub
Sign in
Tagged articles
110 articles
Page 1 of 2
Node.js Tech Stack
Node.js Tech Stack
Feb 11, 2026 · Artificial Intelligence

Draw.io launches official MCP server – a surprisingly smooth AI‑powered diagram experience

Draw.io (now diagrams.net) has released an official MCP server that lets AI‑enabled editors like Cursor generate and edit diagrams instantly by converting AI‑produced Mermaid, CSV, or XML data into a Draw.io link, offering a seamless, editable workflow with privacy‑preserving URL‑based rendering, though limited by URL length.

AI diagramsCSVCursor
0 likes · 7 min read
Draw.io launches official MCP server – a surprisingly smooth AI‑powered diagram experience
Data STUDIO
Data STUDIO
Nov 25, 2025 · Big Data

Why Parquet Is the Faster, Lighter, Safer Alternative to CSV in Python

The article explains why CSV becomes a bottleneck for large‑scale data, demonstrates how Parquet’s columnar, typed, and compressed format dramatically reduces storage, speeds up reads, and improves data safety, and provides step‑by‑step Python code for migrating and benchmarking the switch.

CSVDuckDBParquet
0 likes · 18 min read
Why Parquet Is the Faster, Lighter, Safer Alternative to CSV in Python
php Courses
php Courses
Nov 18, 2025 · Backend Development

Convert CSV to HTML in PHP with a Free Cloudmersive API – Step-by-Step Guide

This guide explains how to use the free Cloudmersive Document Convert API in PHP to transform CSV files into well‑structured HTML, covering prerequisite Composer installation, API key configuration, sample code, and error handling, enabling developers to automate the conversion efficiently.

CSVCloudmersiveComposer
0 likes · 3 min read
Convert CSV to HTML in PHP with a Free Cloudmersive API – Step-by-Step Guide
Open Source Tech Hub
Open Source Tech Hub
Nov 9, 2025 · Backend Development

Master Reading CSV Files into PHP Arrays: 6 Proven Methods

This guide explains six practical techniques for loading CSV data into PHP arrays, covering the classic fgetcsv() approach, associative mapping with headers, using file() and str_getcsv(), handling custom delimiters, skipping empty lines, streaming large files, and a reusable csvToArray function.

ArrayCSVFile I/O
0 likes · 8 min read
Master Reading CSV Files into PHP Arrays: 6 Proven Methods
Code Mala Tang
Code Mala Tang
Jun 4, 2025 · Fundamentals

10 Powerful CSV Module Tricks Every Python Developer Should Know

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.

CSVTipsdata-processing
0 likes · 8 min read
10 Powerful CSV Module Tricks Every Python Developer Should Know
php Courses
php Courses
Apr 11, 2025 · Fundamentals

Handling Exceptions When Processing CSV and JSON Files in Python

This article explains how to use Python's try‑except and with statements to safely read and process CSV and JSON files, covering common errors such as missing files, permission issues, format problems, and providing best‑practice examples for robust error handling.

CSVJSONexception-handling
0 likes · 7 min read
Handling Exceptions When Processing CSV and JSON Files in Python
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Dec 31, 2024 · Backend Development

Master CSV Processing in Spring Boot 3 with Super CSV – Full Code Guide

This article provides a comprehensive tutorial on using the Super CSV library in Spring Boot 3, covering Maven dependencies, core APIs for reading and writing CSV files, cell processors, handling irregular data, and a complete Spring MVC controller example for CSV download, all illustrated with code snippets and screenshots.

CSVFile I/OSpring Boot
0 likes · 14 min read
Master CSV Processing in Spring Boot 3 with Super CSV – Full Code Guide
Test Development Learning Exchange
Test Development Learning Exchange
Nov 2, 2024 · Big Data

Python Data Parsing and Large‑Scale Data Processing Techniques

This article introduces Python's built‑in modules and popular libraries for parsing CSV, JSON, and XML files, demonstrates advanced data manipulation with pandas, and presents multiple strategies—including chunked reading, Dask, PySpark, HDF5, databases, Vaex, and NumPy memory‑mapping—for efficiently handling very large datasets.

Big DataCSVData Parsing
0 likes · 14 min read
Python Data Parsing and Large‑Scale Data Processing Techniques
Python Crawling & Data Mining
Python Crawling & Data Mining
Oct 26, 2024 · Databases

Export MongoDB Data to CSV, Excel, JSON and More with mongo2file

This article introduces the mongo2file Python library that converts MongoDB collections into various table formats such as CSV, Excel, JSON, Pickle, Feather, and Parquet, explains its PyArrow dependency, shows installation and usage examples, discusses performance bottlenecks, and provides API reference details.

CSVData ExportExcel
0 likes · 11 min read
Export MongoDB Data to CSV, Excel, JSON and More with mongo2file
Python Programming Learning Circle
Python Programming Learning Circle
Sep 21, 2024 · Fundamentals

Python Essentials: CSV Handling, itertools, collections, Debugging, and Performance Tips

This article provides a comprehensive guide to Python fundamentals, covering CSV file reading and writing, powerful iterator utilities from itertools, advanced collection types like Counter, defaultdict and OrderedDict, techniques for error and warning output, code debugging, style checking, profiling, and practical performance‑optimisation principles.

CSVCollectionsPython
0 likes · 10 min read
Python Essentials: CSV Handling, itertools, collections, Debugging, and Performance Tips
php Courses
php Courses
May 21, 2024 · Backend Development

Converting CSV Files to HTML Using PHP and Cloudmersive API

This article explains how to use PHP and the free Cloudmersive Document Convert API to transform CSV files into HTML, covering installation of the API client via Composer, configuring the API key, and executing the conversion with sample code.

APICSVCloudmersive
0 likes · 3 min read
Converting CSV Files to HTML Using PHP and Cloudmersive API
Python Programming Learning Circle
Python Programming Learning Circle
Apr 25, 2024 · Fundamentals

Introducing CleverCSV: A Smart Python Library for Intelligent CSV Parsing

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.

CSVclevercsvdata-processing
0 likes · 6 min read
Introducing CleverCSV: A Smart Python Library for Intelligent CSV Parsing
Python Crawling & Data Mining
Python Crawling & Data Mining
Apr 18, 2024 · Backend Development

How to Scrape GDP Data with Python and Save to CSV in Minutes

This article demonstrates how to use Python's requests, lxml, and pandas libraries to crawl GDP data from a website, parse the HTML tables, and efficiently write the extracted rankings, regions, GDP values, and years into a CSV file, providing a complete, runnable example for web scraping beginners.

CSVPythonWeb Scraping
0 likes · 8 min read
How to Scrape GDP Data with Python and Save to CSV in Minutes
360 Quality & Efficiency
360 Quality & Efficiency
Mar 8, 2024 · Fundamentals

Using Python Pandas for Data Comparison Between Files and Databases

This article demonstrates how testers can ensure large‑scale data accuracy by leveraging Python’s Pandas library to compare and match data across files and databases, presenting a reusable class, field‑mapping techniques, code examples, and a comparison of Pandas with other data‑handling libraries.

CSVPythondata analysis
0 likes · 5 min read
Using Python Pandas for Data Comparison Between Files and Databases
Java Tech Enthusiast
Java Tech Enthusiast
Feb 14, 2024 · Backend Development

Generic Excel Export for Arbitrary Java Objects via Reflection

The article shows how to generically export any Java object's data to an Excel‑compatible CSV file by using reflection to convert objects into maps, building headers (optionally via a @JcExcelName annotation) and writing the result with a reusable utility class and Maven‑managed Apache POI, FastJSON, and Commons‑IO dependencies, illustrated through SpringBoot controller and main‑method examples.

CSVReflectionannotation
0 likes · 10 min read
Generic Excel Export for Arbitrary Java Objects via Reflection
Java Backend Technology
Java Backend Technology
Jan 24, 2024 · Backend Development

How to Export Any Java Object List to Excel Using Reflection and CSV

This article demonstrates a step‑by‑step method for exporting a list of unknown Java objects to an Excel/CSV file by leveraging reflection to dynamically generate headers and rows, complete with Maven dependencies, utility code, usage examples, and an extensible annotation‑based approach.

CSVReflectionSpring Boot
0 likes · 11 min read
How to Export Any Java Object List to Excel Using Reflection and CSV
Python Programming Learning Circle
Python Programming Learning Circle
Nov 11, 2023 · Fundamentals

Python Weather Data Scraping, CSV Storage, and Visualization with Matplotlib

This article demonstrates how to use Python's requests and BeautifulSoup libraries to scrape current and 14‑day weather data from China Weather, store the results in CSV files, and perform comprehensive visual analysis with pandas, numpy, and matplotlib, including temperature, humidity, AQI, wind radar, and correlation plots.

CSVData visualizationMatplotlib
0 likes · 24 min read
Python Weather Data Scraping, CSV Storage, and Visualization with Matplotlib
JD Retail Technology
JD Retail Technology
Nov 7, 2023 · Backend Development

Practical Cases of Using ChatGPT for Backend Development Tasks

This document presents a series of real‑world examples showing how ChatGPT can assist cloud‑trading developers with backend tasks such as resource scheduling, regex interpretation, CSV generation, JavaBean‑to‑JSON conversion, Spring IoC learning, JSON formatting, Java 8 stream processing, and CI pipeline error analysis.

CSVChatGPTJava8 Streams
0 likes · 5 min read
Practical Cases of Using ChatGPT for Backend Development Tasks
Python Programming Learning Circle
Python Programming Learning Circle
Aug 9, 2023 · Fundamentals

Comprehensive Guide to Python File Operations: Opening, Reading, Writing, Paths, Modes, CSV, and Serialization

This tutorial presents a complete overview of Python file handling, covering opening and closing files, absolute and relative paths, various access modes, reading and writing techniques, pointer control, file copying, CSV processing, in‑memory streams, sys redirection, and JSON/pickle serialization, all illustrated with practical code examples.

CSVJSONPickle
0 likes · 19 min read
Comprehensive Guide to Python File Operations: Opening, Reading, Writing, Paths, Modes, CSV, and Serialization
FunTester
FunTester
Apr 10, 2023 · Industry Insights

How to Map China’s Qingming Rainfall Using Free Weather APIs and Python

This guide shows how to collect nationwide weather data for the Qingming Festival via the free QWeather API, process it with Python to generate a CSV file, and visualize the rainfall distribution across China using a desktop data‑visualization tool.

CSVData visualizationPython
0 likes · 6 min read
How to Map China’s Qingming Rainfall Using Free Weather APIs and Python
Programmer DD
Programmer DD
Mar 31, 2023 · Backend Development

Build a Java CSV Processor in Minutes with GitHub Copilot

This tutorial shows how to use GitHub Copilot in VS Code to quickly generate a Java application that loads, parses, and prints data from CSV files, including creating example CSV content, adding column‑name output, and downloading CSVs from a URL.

CSVGitHub Copilotbackend-development
0 likes · 7 min read
Build a Java CSV Processor in Minutes with GitHub Copilot
Architect's Guide
Architect's Guide
Mar 30, 2023 · Backend Development

Universal Java Class-to-Excel Export Using Reflection and CSV Formatting

This article explains how to build a generic Java utility that exports any list of objects to an Excel‑compatible CSV file by using reflection to extract field names for headers and values for rows, includes Maven dependencies, custom annotations, and practical usage examples.

CSVReflectionannotations
0 likes · 9 min read
Universal Java Class-to-Excel Export Using Reflection and CSV Formatting
Architect
Architect
Mar 17, 2023 · Backend Development

Million‑Scale Data Export with JPA and MyBatis in Spring Boot

This article explains how to export tens of millions of rows from MySQL using Spring Boot by streaming data with JPA or MyBatis, avoiding OutOfMemoryError, switching to CSV format, and provides complete code examples, performance comparison, and tips for generating test data.

CSVDataExportMyBatis
0 likes · 12 min read
Million‑Scale Data Export with JPA and MyBatis in Spring Boot
Python Programming Learning Circle
Python Programming Learning Circle
Nov 25, 2022 · Fundamentals

Python File I/O, CSV Handling, and Data Serialization Tutorial

This tutorial explains Python's file opening and closing methods, various file path formats, reading and writing techniques including with‑open, pointer manipulation, copying files, CSV read/write operations, in‑memory streams with StringIO/BytesIO, sys.stdin/stdout usage, and data serialization/deserialization using JSON and pickle.

CSVJSONPickle
0 likes · 15 min read
Python File I/O, CSV Handling, and Data Serialization Tutorial
MaGe Linux Operations
MaGe Linux Operations
Nov 21, 2022 · Backend Development

Build a Python-Based Electronic Attendance System: Step-by-Step Guide

This article outlines a student project to create a Python-powered electronic attendance system, detailing required CSV data formats, core functions such as loading data, login, record writing, and querying, along with task requirements, additional features, and complete code examples.

CSVStudent Projectattendance system
0 likes · 8 min read
Build a Python-Based Electronic Attendance System: Step-by-Step Guide
Python Programming Learning Circle
Python Programming Learning Circle
Nov 10, 2022 · Fundamentals

Comprehensive Guide to Python File Operations, CSV Handling, and Data Serialization

This article provides a thorough tutorial on Python file I/O, covering opening and closing files, mode flags, absolute and relative paths, reading and writing techniques, file copying, CSV read/write, in‑memory streams, sys module redirection, and serialization with JSON and pickle, including code examples and best practices.

CSVJSONPickle
0 likes · 20 min read
Comprehensive Guide to Python File Operations, CSV Handling, and Data Serialization
Python Programming Learning Circle
Python Programming Learning Circle
Sep 28, 2022 · Backend Development

Python-Based Student Attendance System – Project Description and Implementation Guide

This article outlines a Python-driven electronic attendance system project, detailing required CSV data structures, core functions for loading student information, user login, attendance recording, and query features, along with code snippets and step-by-step instructions for students to complete and test the application.

AttendanceCSVfile-io
0 likes · 8 min read
Python-Based Student Attendance System – Project Description and Implementation Guide
Python Programming Learning Circle
Python Programming Learning Circle
Jul 5, 2022 · Fundamentals

12 Essential Python Code Snippets for Everyday Programming

This article presents twelve practical Python code snippets—including regular‑expression validation, list slicing, swapping without a temporary variable, f‑strings, dictionary inversion, multithreading, most‑common element detection, CSV parsing, and more—to help developers write concise, efficient code without lengthy boilerplate.

CSVcode snippetslist slicing
0 likes · 9 min read
12 Essential Python Code Snippets for Everyday Programming
FunTester
FunTester
May 29, 2022 · Fundamentals

How to Download and Visualize Kweichow Moutai Stock Data with Python

This guide shows how to download historical Kweichow Moutai stock data from NetEase Finance as a CSV file, handle encoding issues, and use Python's pandas and matplotlib libraries to filter the data and create both volume and OHLC line charts for a selected month.

CSVData visualizationMatplotlib
0 likes · 6 min read
How to Download and Visualize Kweichow Moutai Stock Data with Python
Sohu Tech Products
Sohu Tech Products
Oct 27, 2021 · Backend Development

Using PrettyTable in Python to Create Formatted Command‑Line Tables

This article introduces the PrettyTable Python library, explains how to install it, demonstrates creating tables with headers, adding rows and columns, importing data from CSV, databases, or HTML, and shows various output formats and styling options for clear command‑line presentation.

CSVData PresentationPython
0 likes · 13 min read
Using PrettyTable in Python to Create Formatted Command‑Line Tables
Laravel Tech Community
Laravel Tech Community
Aug 26, 2021 · Backend Development

Using Laravel Excel to Import and Export Excel/CSV Files in Laravel

This tutorial explains how to integrate the Laravel‑Excel package into a Laravel 5 project, covering Composer installation, service provider and alias configuration, publishing the configuration file, creating a controller with export and import methods, and handling CSV, XLS, and XLSX files both for download and server storage.

CSVExcelImportExport
0 likes · 5 min read
Using Laravel Excel to Import and Export Excel/CSV Files in Laravel
php Courses
php Courses
May 8, 2021 · Backend Development

Efficient CSV Export in PHP for Large Datasets

This article explains how to efficiently export large datasets to CSV files using PHP, describing the CSV format, why a simple streaming approach outperforms PHPExcel, performance expectations for 200,000 rows, and provides a complete PHP function that handles encoding, buffering, and memory‑friendly output.

BackendCSVData Export
0 likes · 3 min read
Efficient CSV Export in PHP for Large Datasets
FunTester
FunTester
Apr 28, 2021 · Fundamentals

Convert JSON to CSV with jq: A Step‑by‑Step Tutorial

This tutorial demonstrates how to use the jq command‑line tool to extract an array of objects from a JSON file, reshape the data into a two‑column format, and output it as properly formatted CSV, including handling of quoting and raw output options.

CSVJSONShell
0 likes · 4 min read
Convert JSON to CSV with jq: A Step‑by‑Step Tutorial
php Courses
php Courses
Jan 26, 2021 · Backend Development

Reading and Writing CSV Files in PHP

This article provides PHP code examples for reading data from a CSV file and writing data to a new CSV file, including handling of locale settings, skipping headers, constructing headers, and appending rows using built‑in functions such as fgetcsv, fopen, and fwrite.

BackendCSVFile I/O
0 likes · 2 min read
Reading and Writing CSV Files in PHP
Python Crawling & Data Mining
Python Crawling & Data Mining
Dec 31, 2020 · Backend Development

How to Scrape Thousands of New‑House Listings in Python: A Step‑by‑Step Guide

This article demonstrates how to use Python's requests, fake_useragent, and lxml libraries to batch‑scrape nearly a thousand new‑house listings from the 惠民之家 website, extracting 41 fields such as name, price, layout, opening date, plot ratio and green ratio, while handling pagination and anti‑scraping measures.

CSVPythonReal Estate Data
0 likes · 9 min read
How to Scrape Thousands of New‑House Listings in Python: A Step‑by‑Step Guide
MaGe Linux Operations
MaGe Linux Operations
Oct 30, 2020 · Fundamentals

Master Python File I/O: From Basics to Advanced Serialization

This guide walks through Python file operations—including opening, closing, reading, writing, path handling, file copying, CSV handling, in‑memory streams, sys.stdin/stdout/stderr redirection, and JSON vs. pickle serialization—providing code examples and practical tips for each topic.

BytesIOCSVFile I/O
0 likes · 19 min read
Master Python File I/O: From Basics to Advanced Serialization
Laravel Tech Community
Laravel Tech Community
Sep 1, 2020 · Backend Development

Using PHP fputcsv() to Write CSV Files

This article explains how the PHP fputcsv() function formats an array as a CSV line and writes it to a file, detailing its parameters, return value, and providing a complete example with code and the resulting CSV output.

CSVFile I/OPHP
0 likes · 2 min read
Using PHP fputcsv() to Write CSV Files
Python Programming Learning Circle
Python Programming Learning Circle
May 18, 2020 · Backend Development

How to Retrieve Binance Trade Data with Python: A Step-by-Step Guide

This article explains why accurate trade data is essential for strategy backtesting, why Binance is chosen, and provides a detailed Python workflow—including argument parsing, using the Binance aggTrades endpoint, handling pagination with from_id, cleaning the resulting DataFrame, saving to CSV, and validating the data integrity.

Binance APICSVData Extraction
0 likes · 7 min read
How to Retrieve Binance Trade Data with Python: A Step-by-Step Guide
21CTO
21CTO
Apr 18, 2020 · Databases

How to Import FIFA18 Player Data from CSV into MySQL with Python

This step‑by‑step guide shows how to download the FIFA 18 player dataset from GitHub, create a MySQL database and table, read the CSV with Python’s csv.DictReader, generate INSERT statements, batch‑load the data efficiently, and query Argentine players, illustrating a complete end‑to‑end data‑import workflow.

CSVFIFA18data import
0 likes · 12 min read
How to Import FIFA18 Player Data from CSV into MySQL with Python