Replace Nulls with MICE or Probabilistic PCA

[Deebo]

Hi all!

I am trying to replace the NULL values in some fields not with the mean, but with Probabilistic PCA or MICE. How may I achieve that?

[DataCurious_Nick]

Hi @Deebo 

Easiest route for both is probably by Python code - you can add a Python tool to the workflow and use the following links as ideas: 

MICE: (Uses numpy, pandas and scikit-learn - all included in the bundled Python instance with Alteryx Designer)

https://www.analyticsvidhya.com/blog/2021/10/a-complete-guide-to-dealing-with-missing-values-in-pyth... 

Probabilistic PCA: 

https://github.com/ymcdull/ppca - you can import additional Python packages into your Alteryx notebook when using Admin privileges using the Alteryx.InstallPackages() function. 

Hope this helps - Stay Curious!

Nick

datacurious.ai