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?
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-python/
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
