Hi, I having two column of data one is income and one is spending on food. For my spending on food column I have data that is null and I had data that look incorrect (number in bold) for null value i using imputation tool to input the average value am i doing it correctly? For the incorrect (number in bold) data any advice of what I should do? Here a sample of data
Income Spending on food
10900 890
2400 950
17000 1490
9700 9
15900 1310
10700
11400 38
6000 2000
5609
4050 1
Solved! Go to Solution.
@elephant something like below? it replaces the NULL to 0
@elephant
How do you define "data that look incorrect"?
Like earn 5000 but spend only 8
Err... how is that incorrect?
like it earn 9700 but spend 8 isnt that consider an incorrect or not accurate data?
What... high income people can''t be frugal on food? Haha!
Let's circle back to your rawest form of data. Can you provide a sample? Let's have a look.
You have a few options that you can take, all of which require you to define what "looks incorrect" means. As an example, ratio ([food cost]/[Income] < 1%):
Which option you choose, depends on how much data you have, what your use case is, and how much data is affected.