Challenge No. 155: Transform the question table into the result table format.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Skip, List.Transform, Table.AddColumn), Python, Python in Excel, and R.
Table.AddColumn
Adds a new column to a table with computed values in Power Query.
Add Index Column! Part 5
Challenge No. 154: Add an index column to the question table, which has the same index value for every consecutive date.
Solved using:Excel (DROP, IF, LAMBDA), Google Sheets, Power Query (Table.AddColumn, Table.AddIndexColumn, Table.Column), Python, Python in Excel, and R.
Calculate Percentage of Correct Answers
Challenge No. 83: Generate result table where Y means that right answer has been chosen and N means wrong answer has been chosen.
Solved using: Power Query (List.Distinct, Table.AddColumn).
Extract From Text! Part 3
Challenge No. 149: Extract texts between and pair of the bellow characters.
Solved using:Excel (LAMBDA, LET, MAP), Google Sheets, Power Query (Table.AddColumn), Python, Python in Excel, and R.
Table Transformation! Part 16
Challenge No. 147: Transform the question structure into the result structure.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (List.Skip, List.Split, Table.AddColumn), Python, Python in Excel, R, and VBA.
Sum Groups Separated by Blanks
Challenge No. 75: Groups are separated by blank rows in Problem table.
Solved using: Python in Excel.
Column Splitting! Part 2
Challenge No. 146: Split the IDs from the beginning of the text up to the “|” character in each occurrence of “|”.
Solved using:Excel (IFNA, LAMBDA, LEN), Google Sheets, Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, R, and VBA.
Length Of Pattern!
Challenge No. 145: Find the largest length of occurrences of the “++-” pattern across the test IDs for each product.
Solved using:Excel (CONCAT, GROUPBY, LAMBDA), Google Sheets, Power Query (List.Transform, Text.Combine, Table.AddColumn), Python, Python in Excel, and R.
Multiply Columns by Factor Dynamically
Challenge No. 73: Multiply Alpha, Beta, Gamma columns with Factor column.
Solved using: Python in Excel.
First Date Of Months!
Challenge No. 144: From the provided “transactions” table, filter the first transaction for each.
Solved using:Excel (DROP, FILTER, LAMBDA), Google Sheets, Power Query (Date.Month, Table.AddColumn, Table.Group), Python, Python in Excel, and R.