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

[rively90]

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.........

[AndrewSu · Accepted solution]

@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.