esProc Desktop's Blog
Tag

Data Science

#data-science

More content

Read more stories on Hashnode

Articles with this tag

#126 — Group When Encountering Non-Null Values

Jan 6, 20251 min read

Problem description & analysis: We have an annual and monthly water-consumption data table, and the year is filled in only on the left of the first...

#126 — Group When Encountering Non-Null Values

#124 — Take Adjacent Data as Grouping Criteria

Dec 31, 20241 min read

Problem description & analysis: Here below is a data table: Task: Group the data in the first column, and calculate the sum of the values in the...

#124 — Take Adjacent Data as Grouping Criteria

#120 — Group by Segment

Dec 23, 20241 min read

Problem description & analysis: Here below is a data table: Task: We want to count the number of people in each of the following score segments...

#120 — Group by Segment

#118 — Group by the Combination of Multiple Columns

Dec 16, 20241 min read

Problem description & analysis: Here below is a data table: Task: We want to group the data by Year and Quarter, and count the total sales of each...

#118 — Group by the Combination of Multiple Columns

#117 — Simple Grouping

Dec 13, 20241 min read

Problem description & analysis: Here below is a data table: Task: We want to group the data by Class and calculate the average score of each subject...

#117 — Simple Grouping

#116 — Concatenate Members with the Same Ranking

Dec 12, 20241 min read

Problem description & analysis: Here below is a data table: Task: Rank the students by math score and concatenate the names of students having the...

#116 — Concatenate Members with the Same Ranking