Challenge No. 141: For each blank cell, replace the null value with the value from the row above that has the same ID.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (Table.Group), Python, Python in Excel, and R.
Data Cleaning
Challenges about data cleaning techniques.
Table Transformation! Part 13
Challenge No. 131: Transform the question structure into the result structure.
Solved using:Excel (HSTACK, LET, ROWS), Google Sheets, Power Query (List.Skip, List.Split, List.Transform), Python, Python in Excel, and R.
Table Transformation! Part 11
Challenge No. 122: Transform the question table into the reult table format.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Transform, Text.Contains, Table.AddColumn), Python, Python in Excel, and R.
Duplicate Values! Part 2
Challenge No. 113: Consider the IDs in the question table.
Solved using:Excel (DROP, IF, LAMBDA), Google Sheets, Power Query (List.Transform, Table.AddColumn, Table.AddIndexColumn), Python, Python in Excel, and R.
Duplicate Values! Part 1
Challenge No. 100: Consider the IDs in the question table.
Solved using:Excel (CHAR, COUNTIF, COUNTIFS), Google Sheets, Power Query (List.Transform, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Data Cleaning! Part 1
Challenge No. 98: In the Question table, historical sales values are provided in a single cell, including the Date, Product Name, and Quantity, but in a disorganized order.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Contains, Text.Split), Python, Python in Excel, and R.
Table Transformation! Part 9
Challenge No. 89: Product sales information is provided in the question table.
Solved using:Excel (COUNTA, FILTER, HSTACK), Power Query (List.Transform, Table.SelectRows, Table.Skip), Python, Python in Excel, and R.
Table Transformation! Part 8
Challenge No. 65: In the question table, the total costs for different date ranges are provided.
Solved using:Excel (HSTACK, LAMBDA, LET), Power Query (List.Dates, List.Transform, Table.AddColumn), Python, R, and VBA.
Table Transformation! Part 7
Challenge No. 48: The table below presents various combinations of heuristic algorithms used to solve a problem, each combination separated by a “+”.
Solved using:Excel (COUNTIF, HSTACK, IF), Google Sheets, Power Query (List.Distinct, List.Transform, Table.AddColumn), Python, and R.
Table Transformation! Part 6
Challenge No. 41: Convert the data from the question table into the result table, arranging the information so that each product is detailed in separate rows.
Solved using:Excel (FILTER, HSTACK, LET), Power Query (List.Transform, Table.RemoveColumns, Table.Sort), Python, and R.