Data is only as good as its completeness. And we have all dealt with incomplete data. But when a dataset has missing or incomplete data, it creates a set of dynamics that are centered on how to handle the missing data. There are, of course, several strategies one can use to address this issue. Some strategies often include:

Deleting the row where the missing data appears

Placing a unique number in the missing data field or location

Averaging the data that DOES appear and placing the average value into the missing data field or location.

Placing a value in the missing data field or location from an adjacent field or location

Analyze each strategy, and other strategies you may think of, and determine the advantages and disadvantages of each strategy. As part of your analysis, make sure to address if anything can be gained or lost from using one strategy over another.