working with missing table data

Question

Jean Habimana 2020-9-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/592864-working-with-missing-table-data

评论： Jean Habimana 2021-9-6

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 个评论
显示 3更早的评论隐藏 3更早的评论

Jean Habimana 2020-9-13

i have been trying to do so, but see the error

Error using scatter (line 56)

Input arguments must be numeric, datetime, duration or categorical.

Error in A2Q1draft (line 15)

Ameer Hamza 2020-9-13

Can you show the code?

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Steven Lord 2020-9-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/592864-working-with-missing-table-data#answer_493939

在 MATLAB Online 中打开

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)