Filling in missing values in datasets
Challenge No. 195: In the ID column, the text should follow the format XX/XX/XX/XX (with a ‘/’ after every two characters).
Solved using:Excel (IF, LAMBDA, LEN), Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, and R.
Challenge No. 92: In the question table, some cells (highlighted) are missing, but a character determines how to fill them based on the following rule:
R = right cell
L = left cell
U = upper cell
D = down cell.
Solved using:Excel (IF, IFS, INDEX), Power Query (List.PositionOf, List.Transform), Python, Python in Excel, and R.
Challenge No. 86: K-nearest neighbors (KNN) is a simple technique for replacing missing values with the average of the nearest values.
Solved using:Excel, Power Query, and VBA.
Challenge No. 74: Customer information including Name, Family, Phone, and Website is provided in the question table.
Solved using:Excel (ARRAYTOTEXT, FILTER, HSTACK), Power Query (List.Difference, List.Distinct, Text.Combine), Python, and R.
Challenge No. 62: The question table presents the actual progress of 3 projects at the end of each month, but some values are missing.
Solved using:Excel (DATE, DROP, IF), Power Query (Date.Month), Python, and R.
Challenge No. 54: The table presents the actual progress of three projects at the end of each month, but some values are missing.
Solved using:Excel (DATE, DROP, EOMONTH), Power Query (List.Transform, Table.Group, Table.TransformColumnTypes), Python, and R.
Challenge No. 52: In the Question Table, numbers ranging from 1001 to 1018 are listed.
Solved using:DAX, Excel (COUNTIF, FILTER, IF), Power Query (List.Difference), Python, Python in Excel, R, SQL, and VBA.
