working with missing table data
显示 更早的评论
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 个评论
KSSV
2020-9-13
What you want to do with that?
Jean Habimana
2020-9-13
KSSV
2020-9-13
okay..you can striaght away use scatter. Data which is missing has NaN's, so scatter will not show them.
Jean Habimana
2020-9-13
Ameer Hamza
2020-9-13
Can you show the code?
采纳的回答
Steven Lord
2020-9-13
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)
更多回答（1 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
