working with missing table data
2 views (last 30 days)
Show older comments
Jean Habimana
on 13 Sep 2020
Commented: Jean Habimana
on 6 Sep 2021
Hello,
any help?
I am just need to work on my data, however a bunch of them are missing. consider like i need to use all of them (no interp1 or fillmissing) , how can do it so far
consider like i need to scatter plot them.
thanks
5 Comments
Accepted Answer
Steven Lord
on 13 Sep 2020
Calling scatter on data stored in a table array is possible. You just need to extract the data from the table rather than trying to scatter sub-tables. Let's take a sample table and create a scatter plot from the height and weight of patients at a hospital.
load patients
patients = table(LastName,Gender,Age,Height,Weight,Smoker,Systolic,Diastolic);
scatter(patients.Height, patients.Weight)
Note that I used the dot notation to extract the contents of those table variables. I could also have used the following, which opens a new figure so you can compare the two approaches.
figure
scatter(patients{:, 'Height'}, patients{:, 'Weight'}) % curly brace indexing returns data
What won't work is passing tables into scatter.
figure
scatter(patients(:, 'Height'), patients(:, 'Weight')) % parentheses indexing returns a table
As originally created, the patients table has no missing data. We can change that.
patients2 = patients;
patients2{patients2.Height == 64, 'Weight'} = NaN;
% Show that it contains missing data
head(patients2)
% Plot it
figure
scatter(patients2.Height, patients2.Weight)
More Answers (1)
See Also
Categories
Find more on Scatter Plots in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!