Challenge No. 114: In Question Table 1, the dates and product IDs are provided.
Solved using:Excel (FILTER, HSTACK, IFERROR), Google Sheets, Power Query (Text.Split, Table.AddColumn), Python, Python in Excel, R, and SQL.
⭐️⭐️⭐️ Intermediate
Moderate difficulty level.
Sum Negative Numbers Only
Challenge No. 135: Extract the negative numbers and sum them from the given strings.
Solved using: Python in Excel.
Add Suffix to Duplicates
Challenge No. 134: If an animal appears more than once, then that animal’s name should be suffixed with 1, 2, 3.
Solved using: SQL.
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.
Insert blank rows based on
Challenge No. 35: Insert the number of blank rows after the records as per Number column.
Solved using: Python.
Generate Cartesian product of values
Challenge No. 34: Generate the Cartesian product as shown.
Solved using: SQL.
Find Non-Common Words
Challenge No. 112: Find the words which are not common between Group 1 and Group 2.
Solved using: SQL.
Format FIFA data with hyphens
Challenge No. 30: — This week is for FIFA world cup challenges —
Insert a hyphen ( i.
Solved using: SQL.
Characters Repetition!
Challenge No. 105: In the question table, where some passwords are provided, extract the 6 most commonly used characters across all the passwords and count their repetitions.
Solved using:Excel (CONCAT, FILTER, GROUPBY), Google Sheets, Power Query (List.Combine, List.Distinct, List.Transform), Python, Python in Excel, and R.
Caesar Cipher Multi Shift
Challenge No. 103: This is the 3rd in series of Caesar’s Cipher Challenges.
Solved using: SQL.