Challenge No. 178: Find the prime Factors of numbers in the question table.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (List.Transform), Python, Python in Excel, R, and VBA.
Python for Data Analysis
Using Python for data analysis
Table Transformation! Part 21
Challenge No. 177: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (Table.AddColumn, Table.ExpandTableColumn, Table.Group), Python, Python in Excel, and R.
Custom Grouping! Part 16
Challenge No. 176: Group every five rows of the question table and then provide some of quantity for each group.
Solved using:Excel (GROUPBY, HSTACK, LAMBDA), Google Sheets, Power Query (Table.Group, List.Transform, Table.AddIndexColumn), Python, Python in Excel, and R.
Filter!
Challenge No. 174: In the question table, filter out rows where there is a greater value within the two days before or after the current row.
Solved using:Excel (AND, FILTER, IF), Google Sheets, Power Query (Table.SelectRows), Python, Python in Excel, and R.
Custom Grouping! Part 15
Challenge No. 173: The Question table contains transactions recorded on different dates.
Solved using:Excel (HSTACK, LAMBDA, LET), Google Sheets, Power Query (Table.Group, Date.Month, Table.AddIndexColumn), Python, Python in Excel, and R.
Performance!
Challenge No. 172: In this challenge, 250,000 rows of hourly historical data are provided, which are not sorted in any specific order.
Solved using:Excel (DROP, LET, SORT), Google Sheets, Power Query (Table.AddColumn, Table.Sort), Python, Python in Excel, and R.
Table Transformation! Part 20
Challenge No. 171: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Transform), Python, Python in Excel, and R.
Extract From Text! Part 7
Challenge No. 169: Similar to Challenge 149, extract the texts between the pairs of the characters listed below.
Solved using:Excel (ARRAYTOTEXT, LAMBDA, MAP), Google Sheets, Power Query (List.Split, List.Transform, Text.Combine), Python, Python in Excel, and R.
Custom Grouping! Part 14
Challenge No. 168: The stock prices for the given dates are provided in the question table.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (Table.Group, Table.AddIndexColumn, Table.ExpandTableColumn), Python, Python in Excel, and R.
Table Transformation! Part 19
Challenge No. 167: 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, and R.