CSV file handling in MATLAB - Step-by-Step Execution

Concept Flow - CSV file handling

Open CSV file

↓

Read header line

↓

Read each data line

↓

Parse line into values

↓

Store values in array/table

↓

Repeat until end of file

↓

Close file

This flow shows how MATLAB reads a CSV file line by line, parses values, stores them, and closes the file.

Execution Sample

MATLAB

filename = 'data.csv';
fileID = fopen(filename, 'r');
header = fgetl(fileID);
data = [];
while ~feof(fileID)
  line = fgetl(fileID);
  values = sscanf(line, '%f,%f,%f');
  data = [data; values'];
end
fclose(fileID);

This code opens a CSV file, reads the header, then reads and parses each data line into a numeric array.

Execution Table

Step	Action	Variable Values	Output/Effect
1	Open file 'data.csv'	fileID = valid file handle	File opened for reading
2	Read header line	header = 'A,B,C'	Header line stored
3	Check end of file	feof(fileID) = false	Continue loop
4	Read next line	line = '1.0,2.0,3.0'	Line read as string
5	Parse line	values = [1.0; 2.0; 3.0]	Values converted to numbers
6	Append to data	data = [1.0 2.0 3.0]	Data array updated
7	Check end of file	feof(fileID) = false	Continue loop
8	Read next line	line = '4.0,5.0,6.0'	Line read as string
9	Parse line	values = [4.0; 5.0; 6.0]	Values converted to numbers
10	Append to data	data = [1.0 2.0 3.0; 4.0 5.0 6.0]	Data array updated
11	Check end of file	feof(fileID) = true	Exit loop
12	Close file	fileID = closed	File closed

💡 End of file reached, loop stops reading lines

Variable Tracker

Variable	Start	After Step 4	After Step 6	After Step 8	After Step 10	Final
fileID	undefined	valid handle	valid handle	valid handle	valid handle	closed
header	undefined	'A,B,C'	'A,B,C'	'A,B,C'	'A,B,C'	'A,B,C'
line	undefined	'1.0,2.0,3.0'	'1.0,2.0,3.0'	'4.0,5.0,6.0'	'4.0,5.0,6.0'	'4.0,5.0,6.0'
values	undefined	undefined	[1.0;2.0;3.0]	[1.0;2.0;3.0]	[4.0;5.0;6.0]	[4.0;5.0;6.0]
data	[]	[]	[1.0 2.0 3.0]	[1.0 2.0 3.0]	[1.0 2.0 3.0; 4.0 5.0 6.0]	[1.0 2.0 3.0; 4.0 5.0 6.0]

Key Moments - 3 Insights

Why do we use fgetl(fileID) instead of fscanf for reading lines?

fgetl reads one line as a string, allowing us to parse it manually. fscanf reads formatted data but may skip lines or not handle mixed data well. See steps 2,4,8 in execution_table.

Why do we transpose values with values' before appending to data?

sscanf returns a column vector; transposing makes it a row vector to append as a new row in data. See steps 5 and 6.

What stops the while loop from running forever?

feof(fileID) returns true when the file end is reached, causing the loop to exit. See steps 3,7,11.

Visual Quiz - 3 Questions

Look at the execution_table at step 6, what is the content of data?

A []

B [1.0; 2.0; 3.0]

C [1.0 2.0 3.0]

D [4.0 5.0 6.0]

💡 Hint

Check the 'Variable Values' column at step 6 in execution_table.

At which step does the loop stop reading lines from the file?

A Step 10

B Step 11

C Step 12

D Step 9

💡 Hint

Look for feof(fileID) becoming true in execution_table.

If the CSV file had 4 columns instead of 3, how would the sscanf format string change?

A '%f,%f,%f,%f'

B '%f,%f'

C '%f,%f,%f'

D '%f'

💡 Hint

sscanf format string matches the number of columns; see code in execution_sample.

Concept Snapshot

CSV file handling in MATLAB:
- Open file with fopen(filename, 'r')
- Read header line with fgetl(fileID)
- Loop: read each line with fgetl
- Parse line with sscanf(line, '%f,%f,%f')
- Append parsed data to array
- Close file with fclose(fileID)

Full Transcript

This example shows how MATLAB reads a CSV file step-by-step. First, the file is opened for reading. Then the header line is read and stored. The program enters a loop where it checks if the end of file is reached. If not, it reads the next line as a string. This line is parsed into numbers using sscanf with a format matching the CSV columns. The parsed numbers are transposed and appended as a new row to the data array. This repeats until the end of the file is reached, then the file is closed. Variables like fileID, header, line, values, and data change values as the program runs. Key points include using fgetl to read lines, transposing parsed values to append rows, and using feof to stop the loop. The visual quiz tests understanding of data content after steps, loop exit condition, and format string for parsing.