I am learning how to handle missing values in a dataset. I have a table with ~1million entries. At the moment I am trying to deal with a small number of missing values.
My data concerns a bicycle-share system and my missing values are start & end locations.
Data: missing starting stations, only 7 values
Data: missing ending station, 24 values altogether
I deleted the rows where both values were missing since I figured there wasn't enough information to make an accurate prediction. However, using
duration and possibly
timestamp I figure I can reasonably fill in the missing values.
I've identified these values as MCAR because I can't see any systematic relationships as to why they would be missing. Furthermore, I notice that because
duration (measured in seconds) is relatively low (1000s = 16min) I can accurately guess which other stations have been reached under that time.
I know I could probably drop these values because they are relatively few. But if I wanted to fill them in, what is the best method to achieve this?