Tag

CSV

1 views collected around this technical thread.

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.

CSVData ProcessingPython
0 likes · 8 min read
10 Powerful CSV Module Tricks Every Python Developer Should Know
Python Programming Learning Circle
Python Programming Learning Circle
Jun 4, 2025 · Backend Development

How to Scrape JD.com Product Reviews with Python and Save to CSV

This tutorial explains how to use Python to scrape product reviews from JD.com via its AJAX comment API, extract fields such as nickname, score, content, and image count, and save the collected data into a CSV file using the requests and csv modules.

CSVData ExtractionJD.com
0 likes · 7 min read
How to Scrape JD.com Product Reviews with Python and Save to CSV
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.

CSVException HandlingJSON
0 likes · 7 min read
Handling Exceptions When Processing CSV and JSON Files in Python
php中文网 Courses
php中文网 Courses
Mar 24, 2025 · Backend Development

8 Essential PHP Functions for Efficient Table Processing

This article introduces eight useful PHP functions—including array_map, array_column, array_filter, array_reduce, fgetcsv, str_getcsv, implode, and json_encode/json_decode—to help developers efficiently manipulate table data from databases or CSV files, improving performance and code maintainability.

Backend DevelopmentCSVJSON
0 likes · 6 min read
8 Essential PHP Functions for Efficient Table Processing
Python Programming Learning Circle
Python Programming Learning Circle
Mar 6, 2025 · Fundamentals

CSV Trimming: A Python Package for Cleaning Messy CSV Files

CSV Trimming is a lightweight Python library that transforms irregular, poorly formatted CSV files into clean, well‑structured tables with a single line of code, supporting basic trimming as well as advanced row‑correlation handling for complex datasets.

CSVData ProcessingPython
0 likes · 5 min read
CSV Trimming: A Python Package for Cleaning Messy CSV Files
Test Development Learning Exchange
Test Development Learning Exchange
Jan 12, 2025 · Fundamentals

Reading Various File Formats and Databases in Python

This guide demonstrates how to read and write common file types—including TXT, CSV, JSON, XML, Excel, YAML, Parquet, and HDF5—as well as how to connect to SQLite databases and perform web scraping using Python's standard libraries and popular third‑party packages.

CSVJSONSQLite
0 likes · 6 min read
Reading Various File Formats and Databases 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.

CSVData ProcessingFile I/O
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
Dec 28, 2024 · Fundamentals

Python Data Structures and File Operations Tutorial

This tutorial introduces Python's core data structures—lists, dictionaries, sets, and tuples—and demonstrates essential file operations for text, CSV, and JSON formats, providing practical code examples for each concept and explains their characteristics, common operations, and best practices for efficient programming.

CSVData StructuresDictionaries
0 likes · 7 min read
Python Data Structures and File Operations Tutorial
Java Architect Essentials
Java Architect Essentials
Dec 8, 2024 · Backend Development

Universal Java Class to Excel Export Using Reflection and Apache POI

This article demonstrates how to create a generic utility that, through Java reflection and Apache POI, can export any list of objects—regardless of their class—into a CSV/Excel file, with optional custom column names via annotations.

Apache POICSVExcel
0 likes · 11 min read
Universal Java Class to Excel Export Using Reflection and Apache POI
Test Development Learning Exchange
Test Development Learning Exchange
Nov 26, 2024 · Big Data

Processing Large Datasets with Dask: A Step‑by‑Step Tutorial

This tutorial teaches how to use Dask for handling large‑scale CSV data, covering data loading, exploration, cleaning, filtering, aggregation, visualization with pandas, and saving the processed results, all illustrated with complete Python code examples.

Big DataCSVDask
0 likes · 6 min read
Processing Large Datasets with Dask: A Step‑by‑Step Tutorial
Test Development Learning Exchange
Test Development Learning Exchange
Nov 20, 2024 · Fundamentals

Data Reshaping with Pandas: melt and pivot Methods

This article teaches how to use Pandas for data reshaping, covering the melt method for converting wide-format data to long-format and the pivot method for the reverse transformation, with practical code examples.

CSVData TransformationDataFrames
0 likes · 7 min read
Data Reshaping with Pandas: melt and pivot Methods
Test Development Learning Exchange
Test Development Learning Exchange
Nov 19, 2024 · Fundamentals

Sales Data Analysis Project: Reading, Cleaning, Aggregating, and Visualizing with Python

This tutorial guides you through a comprehensive sales data project that covers reading a CSV file, cleaning missing and duplicate entries, grouping by department to compute average sales, and visualizing the results with line and bar charts using pandas and matplotlib.

CSVData VisualizationMatplotlib
0 likes · 5 min read
Sales Data Analysis Project: Reading, Cleaning, Aggregating, and Visualizing with Python
Test Development Learning Exchange
Test Development Learning Exchange
Nov 16, 2024 · Fundamentals

Introduction to Pandas: Creating Series and DataFrames, CSV I/O, Filtering and Sorting

This tutorial introduces Pandas fundamentals, demonstrating how to create Series and DataFrames, read and write CSV files, perform basic filtering and sorting, and includes practical code examples and a hands‑on exercise to display the first five rows of a CSV dataset.

CSVPythonSorting
0 likes · 5 min read
Introduction to Pandas: Creating Series and DataFrames, CSV I/O, Filtering and Sorting
Test Development Learning Exchange
Test Development Learning Exchange
Nov 13, 2024 · Big Data

Top 10 Most Common Pandas Functions with Code Examples

This article introduces the ten most commonly used Pandas functions—read_csv, head, tail, info, describe, dropna, fillna, groupby, merge, and to_csv—explaining their purposes and providing clear Python code examples for each in practical data analysis tasks.

CSVData Processingdata analysis
0 likes · 5 min read
Top 10 Most Common Pandas Functions with Code Examples
Python Programming Learning Circle
Python Programming Learning Circle
Nov 4, 2024 · Fundamentals

Python Weather Data Scraping, CSV Export, 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 Net, store the results in CSV files, and visualize temperature, humidity, air quality, and wind patterns using Matplotlib, NumPy, and Pandas.

CSVData VisualizationMatplotlib
0 likes · 24 min read
Python Weather Data Scraping, CSV Export, and Visualization with Matplotlib
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 DataCSVJSON
0 likes · 14 min read
Python Data Parsing and Large‑Scale Data Processing Techniques
Python Programming Learning Circle
Python Programming Learning Circle
Oct 26, 2024 · Fundamentals

Python Tutorial: Working with Excel, Word, and CSV Files

This article provides a comprehensive Python tutorial covering how to read, write, and modify Excel files using xlrd/xlwt/xlutils, manipulate Word documents with python-docx, and handle CSV data via the csv module, including code examples, library installation, and practical usage tips.

CSVDataProcessingExcel
0 likes · 28 min read
Python Tutorial: Working with Excel, Word, and CSV Files
Test Development Learning Exchange
Test Development Learning Exchange
Oct 19, 2024 · Fundamentals

Python Libraries for CSV and Excel File Processing: csv, openpyxl, pandas, xlsxwriter, and More

This guide introduces and compares several Python libraries—including csv, openpyxl, pandas, xlsxwriter, pyexcel, xlrd/xlwt, xlutils, tablib, ezodf, xlwings, and readxl—detailing their purposes, key features, typical use cases, installation commands, and example code for reading and writing CSV and Excel files.

CSVData ProcessingExcel
0 likes · 21 min read
Python Libraries for CSV and Excel File Processing: csv, openpyxl, pandas, xlsxwriter, and More
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.

CSVCollectionsPerformance
0 likes · 10 min read
Python Essentials: CSV Handling, itertools, collections, Debugging, and Performance Tips