Simple Pivot Table in MATLAB in less than 1 minute

Have you ever wondered how to go about creating a simple pivot table in MATLAB? Well it is actually easier than you may think. All it takes is 4 lines of code.

Here is the code that appeared in the video above. The Excel file Patients.xlsx was created from the data in patients.mat which comes with MATLAB.

% import data
data = readtable('Patients.xlsx');

% split data based on rows and columns
[aGroup, Gender, Location] = findgroups(data.Gender, data.Location);

% apply mean function to Height for each group
avgHeight = splitapply(@mean, data.Height, aGroup);

% visualize what has been done
simplePivot = table(Gender, Location, avgHeight);

% create your simple pivot table
simplePivot = unstack(simplePivot, 'avgHeight', 'Location')

This is a short example of the Advance Service that VersionBay offers. If you would like VersionBay to look at your code just Contact Us.