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

[KSSV]

What you want to do with that?

[Jean Habimana]

i need a scatter plot from them

[KSSV]

okay..you can striaght away use scatter. Data which is missing has NaN's, so scatter will not show them.

[Jean Habimana]

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]

Can you show the code?

Answer 1

[Steven Lord]

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)

[Jean Habimana]

Thanks

Answer 2

[Jean Habimana]

awesome.

that was very helpful