CSV file handling in MATLAB - Mini Project: Build & Apply

CSV file handling

📖 Scenario: You work in a small store and keep track of daily sales in a CSV file. You want to read this file in MATLAB, process the data, and display useful information.

🎯 Goal: Learn how to read a CSV file in MATLAB, extract data, and display the total sales amount.

📋 What You'll Learn

Create a CSV file named sales.csv with product names and sales amounts.

Read the CSV file into MATLAB using readtable.

Calculate the total sales amount by summing the sales column.

Display the total sales amount using disp.

💡 Why This Matters

🌍 Real World

Stores and businesses often keep sales data in CSV files. MATLAB can read these files to analyze sales quickly.

💼 Career

Data analysts and engineers use MATLAB to process CSV data for reports and decision-making.

1

Create the CSV file sales.csv

Create a CSV file named sales.csv with these exact contents (including header):
Product,Amount
Apples,10
Bananas,15
Oranges,12

MATLAB

% Create the CSV file 'sales.csv' with the given content
% Your code here

Need a hint?

Use fopen to create the file, fprintf to write lines, and fclose to close the file.

2

Read the CSV file into a table

Use readtable to read the CSV file 'sales.csv' into a variable called salesData.

MATLAB

% Read the CSV file into salesData
% Your code here

Need a hint?

Use readtable('sales.csv') to load the CSV data into a table.

3

Calculate the total sales amount

Calculate the total sales amount by summing the Amount column of salesData and store it in a variable called totalSales.

MATLAB

% Calculate totalSales by summing salesData.Amount
% Your code here

Need a hint?

Use sum(salesData.Amount) to add all amounts.

4

Display the total sales amount

Use disp to display the text 'Total sales amount:' followed by the value of totalSales.

MATLAB

% Display the total sales amount
% Your code here

Need a hint?

Use disp(['Total sales amount: ', num2str(totalSales)]) to show the result.