CSV and Structured Data

Unit 4 is a practical unit, but a few terms from it keep turning up as one-mark questions in the written paper. They are all about the same thing: what shape the data is in before the AI ever sees it.

1Structured data

Structured data

Data that is organised into rows and columns, where every row has the same columns and every column holds the same kind of value. A class register, a price list, a table of measurements.

Every dataset in this course so far has been structured: the fruit table in Unit 2, the coin weights, the confusion matrix counts. It is the shape the Statistical Data domain works in.

2CSV — Comma Separated Values

CSV

CSV stands for Comma Separated Values. It is a simple file format that stores data separated by commas: one row per line, with a comma marking where each column ends.

The same data, twice

A CSV file is not a special kind of thing. It is a table written out as plain text, one row per line, with commas between the columns.

kind,wing,beak,mass,tail
Sparrow,67.1,11.4,29,55.9
Sparrow,66.7,10.9,27.4,62.4
Sparrow,67.1,9.7,28.1,59.9
Sparrow,78.1,12,25.7,56.9
Sparrow,82.3,10.7,23.6,53.4
Sparrow,72.4,11.1,25,57.8

The first line holds the column names; every line after it is one row of data. Commas mark where one column ends and the next begins — which is the whole of what Comma Separated Values means.

A table with the lines rubbed out

A CSV file is a table that has had its grid lines taken away and the commas left behind to show where they were. Open it in a text editor and you see the commas; open it in a spreadsheet and the grid comes back. Nothing about the data changed.

Why AI projects like it

It is plain text, so every program can read it, and it is tiny compared with a spreadsheet file. That is why a dataset you download for an AI project almost always arrives as .csv.

3Where structured data lives

	What it is	What it is for
CSV	A plain-text file format	Storing and moving a table between programs
Spreadsheet	An application (such as Excel or Google Sheets)	Entering, editing and charting a table by hand
SQL	A language, not a file	Managing data held in a DBMS — especially structured data
TXT	A plain-text file with no agreed structure	Ordinary writing; no rows and columns

The distinction the paper tests

CSV is a file format. SQL is a language. A spreadsheet is an application. They all deal with tables, which is exactly why they are offered as four options against each other. If the question says language or mentions a DBMS, the answer is SQL. If it says file format or separated by commas, it is CSV.

4From the board papers

Which of the following is the correct expansion of CSV?
(A) Comma and Space Value (B) Comma Separated Values (C) Control Separated Values (D) Character Separated ValuesCBSE board exam 2025

1 mark

▶Show the answer

(B) Comma Separated Values. All four options are plausible-sounding expansions, which is the whole difficulty — there is nothing to work out, so this one has to be known.

______ is a simple file format that stores data separated by commas.
(a) jpg (b) doc (c) csv (d) pngCBSE sample papers 2023–24 and 2024–25

1 mark

▶Show the answer

(c) csv. The other three are not table formats at all — jpg and png are images and doc is a word-processor document.

It is a domain-specific language designed for managing data held in different kinds of DBMS. It is particularly useful in handling structured data. Which computer language is this?
(A) SQL (B) CSV (C) Spreadsheet (D) TXTCBSE board exam 2025

1 mark

▶Show the answer

(A) SQL. The question says language twice and names a DBMS, and SQL is the only language on the list — CSV and TXT are file formats and a spreadsheet is an application.

5Check yourself

Quick Check

CSV stands for:

Quick Check

Which of these is a language rather than a file format?

Quick Check

Data organised into rows and columns, where every row has the same columns, is called:

Quick Check

In a CSV file, what does the first line usually hold?

← Previous

🧱 No-Code AI, and Orange

A Dataset, Plotted 📈