How to Deal with Empty cell.

Question

Hi Team,

i have generated fake data using faker library. I have clean the data in Alteryx. After cleaning and filter it segregate in two parts.

599 record contains data with clean.

401 record contain empty data.

Now how to clean the 401 empty data.

I want to remove empty and try to make it usable.

uncleaned_customer_data.csv

DataTesting.yxmd

rohit782192 · Answer

Hi flying008,

My Question is how can we make a use of the False part which are empty.

We cannot let them go waste as this is the data. In additional is there a way to deal with empty to remove or fill something.

flying008 · Answer

Hi, @rohit782192

As your sample data, The number of rows in which any one of the fields is empty is 394, 606 rows contain total data.