View Forum Topic

Forums
CS461
Doubt on "credit or adult"

Author	Message
mohanmb91 Posts: 12	Posted 17:02 Jan 26, 2016 \| 2 pts Copy all columns with empty values and replace all empty numeric fields with the average of its column in this new column. As far as I have seen i couldn't find any empty or NAN values in numeric fields from the given dataset. but there are lot of zero's so should i replace the zero's with the average of its column while creating new column. And for average if i do mean() the values are becoming float so should I again convert it into integer's ??
msargent Posts: 519	Posted 20:05 Jan 26, 2016 \| You can replace the zeroes if you want; it would probably produce better results. Use the median, to avoid skewing by outliers.

Author

Message

mohanmb91

Posts: 12

Posted 17:02 Jan 26, 2016 |

2 pts Copy all columns with empty values and replace all empty numeric fields with the average of its column in this new column.

As far as I have seen i couldn't find any empty or NAN values in numeric fields from the given dataset. but there are lot of zero's so should i replace the zero's with the average of its column while creating new column.
And for average if i do mean() the values are becoming float so should I again convert it into integer's ??

msargent

Posts: 519

Posted 20:05 Jan 26, 2016 |

You can replace the zeroes if you want; it would probably produce better results. Use the median, to avoid skewing by outliers.