CSV
CSV is a plain-text format for tabular data, representing records as rows and fields as values separated by delimiters, conventionally commas, with quoting conventions for special content.
Pandas Workout: 200 exercises to make you a stronger data analyst
A delimited text file containing tabular data, typically encoded using the CSV format.
- How it is used
- Uses CSV as the main route for importing tabular data into DataFrames and exporting analysis results.
- How deep it goes
- Explains CSV’s ambiguous conventions through configurable parsing tasks, without prescribing one canonical file format.
- Examples
- Practices taxi-ride anomaly queries, cross-year taxi comparisons, passwd-file parsing, and college-scorecard analysis.
- What you can do after
- Apply it via pandas `pd.read_csv` to load varied delimited files and select the fields needed for analysis.
Read how Pandas Workout: 200 exercises to make you a stronger data analyst explains CSV →
Tiny Python Projects: Learn coding and testing with puzzles and games
A CSV file is a delimited text file that represents tabular records using rows and separators between fields.
- How it is used
- Deploys CSV parsing to build a workout generator that selects exercises and formats randomized repetitions.
- How deep it goes
- Explains manual parsing, DictReader, numeric conversion, testing, and malformed inputs, while deferring broader pandas use.
- Examples
- Uses exercise-and-repetition files, manual record lists, malformed input files, csvlook output, and a randomized text workout table.
- What you can do after
- Build it from scratch with Python’s csv module, test conversions, handle bad records, and produce formatted tabular output.
Read how Tiny Python Projects: Learn coding and testing with puzzles and games explains CSV →
Learn AI-Assisted Python Programming, Second Edition
CSV is a text-based tabular data format that represents records as lines and fields separated by delimiters, commonly commas.
- How it is used
- Uses CSV as a practical input format for exploring and processing tabular datasets.
- How deep it goes
- Defines headers, comma-separated fields, and line-separated records, then demonstrates reading and aggregating rows with Python.
- Examples
- Uses an NFL offensive-statistics dataset and quarterback passing-yard rankings as concrete examples.
- What you can do after
- Apply it via Python's csv module to read records, filter rows, total values, and sort results.
Read how Learn AI-Assisted Python Programming, Second Edition explains CSV →
Python Workout: 50 ten-minute exercises
CSV is a delimited text format in which records are typically represented as lines and fields are separated by a delimiter such as a comma.
- How it is used
- Uses CSV to exchange tabular information and translate Python data structures to and from files.
- How deep it goes
- Explains records, delimiters, reader and writer configuration, row filtering, and newline differences, but defers advanced variations to pandas.
- Examples
- Demonstrates vegetable rows, csv.writer output, and passwd conversion from colon-delimited input to tab-delimited output.
- What you can do after
- Apply CSV handling via Python’s csv module to read, write, filter, reformat, and selectively export delimited records.
Read how Python Workout: 50 ten-minute exercises explains CSV →
The Well-Grounded Python Developer: How the pros use Python and Flask
CSV (comma-separated values) is a delimited plain-text format for tabular data in which records are lines and fields are conventionally separated by commas.
- How it is used
- Uses human-readable CSV files to store and exchange simple tabular data in a filesystem.
- How deep it goes
- Defines records, fields, headers, and text-only values, then stops at redundancy and restructuring concerns.
- Examples
- Uses customer orders containing names, addresses, products, quantities, and repeated customer data.
- What you can do after
- Evaluate CSV layouts and recognize when repeated records call for restructuring or multiple files.
Read how The Well-Grounded Python Developer: How the pros use Python and Flask explains CSV →
Build Your Own Robot: Using Python, CRICKIT, and Raspberry Pi
CSV is a delimited text format for tabular data, with records represented as lines and fields commonly separated by commas.
- How it is used
- Supplies snack codes and icons that drive QR-code selection and web-interface choices.
- How deep it goes
- Works through header rows, file lines, DictReader parsing, dictionary access, and emoji conversion without detailing CSV grammar.
- Examples
- Uses items.csv containing grapes, carrots, candy, and lollipop codes paired with emoji short codes.
- What you can do after
- Apply it via Python’s DictReader to load named snack records for QR-driven robot functions.
Read how Build Your Own Robot: Using Python, CRICKIT, and Raspberry Pi explains CSV →
Python How-To
A CSV file is a text file that represents tabular data with records and fields separated according to comma-separated-value conventions.
- How it is used
- Uses CSV to exchange tabulated data and provide a simple data source for applications.
- How deep it goes
- Explains row iteration, header mapping, newline handling, and collection, but stops short of writing CSV files.
- Examples
- Demonstrates tasks.txt containing task IDs, titles, urgency levels, and optional headers.
- What you can do after
- Apply the csv module to read CSV rows as lists or header-based dictionaries in a Python application.
Building Web APIs with ASP.NET Core
CSV is a delimited text format that represents tabular data using records and comma-separated fields.
- How it is used
- Uses CSV as a board-game dataset input and as a large-data response format when bandwidth optimization matters.
- How deep it goes
- Defines CSV briefly and demonstrates obtaining, opening, and checking a concrete file, without detailing parsing implementation.
- Examples
- Uses Kaggle’s approximately 20,000-game bgg_dataset.csv and an excerpt showing its rows and columns.
- What you can do after
- Evaluate a CSV file by obtaining it, opening it, and confirming that required fields are present.
The Complete Obsolete Guide to Generative AI
CSV is a text-based tabular data format in which fields are commonly separated by commas and records are separated by lines.
- How it is used
- Supplies a practical format for requesting AI-generated time-series rows and indexing local population data.
- How deep it goes
- Demonstrates loading, indexing, and querying CSV data but does not define formal CSV syntax such as quoting or escaping.
- Examples
- Uses country population queries and a requested history of rack-mount server specifications.
- What you can do after
- Apply it via SimpleCSVReader and a query engine to index a local file and ask column-aware questions.
Read how The Complete Obsolete Guide to Generative AI explains CSV →
DuckDB in Action
CSV is a delimited text format that represents tabular data as records with fields separated by a delimiter, commonly a comma.
- How it is used
- Uses CSV for bulk loading, direct querying, format conversion, and exchanging data with tools lacking native source-format support.
- How deep it goes
- Explains parallel loading, automatic column mapping, schema inference, conversion, and compression, without detailing CSV parsing internals.
- Examples
- Demonstrates Stack Overflow exports converted from XML through JSON into compressed Comments.csv.gz files.
- What you can do after
- Apply it via DuckDB and command-line tools to convert, compress, query, and reuse tabular data.
Python Workout, Second Edition
A CSV file is a text file that represents tabular records with fields separated by delimiters, commonly commas.
- How it is used
- Processes shared tabular text and converts delimited records between files.
- How deep it goes
- Explains delimiters, csv.writer, filtering, and selected fields, but does not develop advanced CSV variations.
- Examples
- Uses vegetable records, passwd-style records, TAB-delimited output, dictionaries, and random integers.
- What you can do after
- Build CSV transformations with Python’s csv module, including delimiter selection, field filtering, and row writing.
Graph Neural Networks in Action
CSV is a delimited text format that represents tabular data as rows of fields separated by commas or another specified delimiter.
- How it is used
- Uses CSV to move transformed graph data between raw-data pipelines, Python workflows, NetworkX, and PyG.
- How deep it goes
- Explains CSV’s interoperability constraints and applies it to edge-list and adjacency-list conversion, without specifying a universal schema.
- Examples
- Demonstrates relationship dictionaries converted into adjacency-list and edge-list files for graph analysis.
- What you can do after
- Builds CSV graph inputs from raw relationships and loads them into NetworkX or PyG.
.NET in Action, Second Edition
CSV is a delimited text format in which records are represented as lines and fields are separated by commas, with quoting and escaping rules for special content.
- How it is used
- Uses CSV as a simple input stream for importing customer records into a data store.
- How deep it goes
- Explains line reading, three-field validation, parsing, and persistence branching, but does not detail general CSV quoting rules.
- Examples
- Uses customer records containing email, name, and license fields, including duplicate-email updates and malformed-line skips.
- What you can do after
- Build it from scratch as a C# importer that converts CSV lines into repository create and update operations.
Logs and Telemetry
CSV is a delimited text format that represents records as rows of values separated by a configurable delimiter.
- How it is used
- Formats log events for file output when compact, delimiter-separated values are useful.
- How deep it goes
- Defines delimiters and nested-value handling, but stops short of quoting, escaping, or schema rules.
- Examples
- Demonstrates a tab-delimited output1.csv file configured through Fluent Bit's file output plugin.
- What you can do after
- Configure CSV file output with a selected delimiter and route matching log events to it.
Data Analysis with LLMs
CSV is a text-based tabular-data format in which each row occupies a line and column values are separated by commas.
- How it is used
- Stores tabular data for analysis in ChatGPT or as input to a Python document-classification workflow.
- How deep it goes
- Defines rows, comma-separated fields, and a possible header line, without detailing other format rules.
- Examples
- Uses a reviews table for product-category counts and a text-column file for document classification.
- What you can do after
- Apply CSV input to count reviews by product category or classify text rows with pandas.
Related concepts
- read_csvused by · read_csv is a function that parses comma-separated or otherwise delimited text into a tabular data structure.
- csvused by · The csv module is Python’s standard-library module for reading and writing comma-separated and other delimiter-separated tabular data.
- Parquetalternative to · Apache Parquet is an open, column-oriented binary file format for storing and processing structured data with schema and metadata support.
- pandasused by · pandas is an open-source Python library that provides labeled data structures and tools for manipulating and analyzing tabular and other structured data.
- JSONalternative to · JSON is a standardized, language-independent text format for representing structured data using objects, arrays, strings, numbers, Boolean values, and null.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.