How to use Sentiment Analysis or any other data science approach to 'Replace the Nulls"?

Question

One recommendation that I got is to use sentiment analysis to repalace the null issues that I'm having. Do you guys know how and mind showing step by step?

original issues:

Hi,

I have a lot of nulls in: Gender, Job, and Race field. What should I do? They seem a lot. I might do something wrong here.

datasets:

* Download 2021 EEO-1 Public Use File (PUF)
* Download 2020 EEO-1 Public Use File (PUF)
* Download 2019 EEO-1 Public Use File (PUF)
* Download 2018 EEO-1 Public Use File (PUF)
* Download 2017 EEO-1 Public Use File (PUF)
* Download 2016 EEO-1 Public Use File (PUF)

please help. I already tried my best to eliminate them. But, they still appear. Not sure what's going on.........

Columns Name.xlsx

Cleaning Final Nulls.yxzp

Cleaning Final Nulls.yxmd

AndrewSu · Accepted Answer

@rively90 , is there a reason you're trying to eliminate the 'null' with a data science approach?  The easiest way to do this would be through the "Data Cleanse" tool or perhaps the "Filter" tool.

https://help.alteryx.com/20231/designer/data-cleansing-tool

if this helps resolve your issue, please mark this reply as the solution so that others in the Community can benefit from our collaboration.

thanks.