cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.
Choose Language Hide Translation Bar
Beginner_9
Level II

How to Exclude Random Missing point before performing PCA.

Hi,

 

How to exclude missing values from the dataset before analysis. These are random missing values due to instrument malfunction. I don't want to impute my data. I have explored the 'Explore Missing Value' but that didn't help because that changes the interpretation of my PCA results.

 

Is there any other way to do so?

 

Thank you,

Beginner_9

New JMP learner
5 REPLIES 5
jthi
Super User

Re: How to Exclude Random Missing point before performing PCA.

How does your data look like? Can you exclude the whole row? If you can, select one of the missing values, right click on it, select matching cells and then right click on the row number and hide and exclude

jthi_0-1756396319324.png

jthi_1-1756396328663.png

 

You can also use Explore Missing Values for this. Select the columns with missing values you wish to exclude and then click Exclude Rows

-Jarmo
Beginner_9
Level II

Re: How to Exclude Random Missing point before performing PCA.

Thank you for your response. I knew the exclude option. I was looking for something where I can specifically exclude the random missing cells without having to apply imputation before my analysis.

 

Thanks alot

New JMP learner
Victor_G
Super User

Re: How to Exclude Random Missing point before performing PCA.

Hi @Beginner_9,

 

You can use the Explore Missing Values platform to help detect, select and exclude rows with missing values automatically. It avoids having to search through your datatable and use manual operations.

Victor_G_1-1757082491772.png


Hope this may help you,

Victor GUILLER

"It is not unusual for a well-designed experiment to analyze itself" (Box, Hunter and Hunter)
Beginner_9
Level II

Re: How to Exclude Random Missing point before performing PCA.

Hi @Victor_G,

 

Is there a way to exclude missing cells instead of the entire row or column?

 

Thank you,

 

New JMP learner
Victor_G
Super User

Re: How to Exclude Random Missing point before performing PCA.

Hi @Beginner_9,

 

Not with this platform, it will only give you the possibility to exclude rows containing missing values.
I suggest you read the documentation about the different methods available in the PCA platform.

If you want to "exclude" cells with missing values from the analysis, switching the default method to row-wise will exclude any observation with missing data. The other methods will try to leverage the information contained in missing and non-missing cells.

Hope this answer will help you,

Victor GUILLER

"It is not unusual for a well-designed experiment to analyze itself" (Box, Hunter and Hunter)

Recommended Articles