Calculate ratio compared with the previous period for continuous intervals of grouped subsets

Task:Calculate the longest consecutive rising days of e […]

Grouped subset cross row calculation and filter grouped results

Task:Find out stocks that have had three consecutive tr […]

Sorting and filtering of grouped subsets

Task: Find out the sales clerks whose sales are within […]

Foreign key join 2

Task:Find out the department with the youngest departme […]

Foreign key join 1

Task:Find out employees with couple salary more than 10 […]

Calculate ratio compared with the previous period for the selected records

Task:Find the trading information and increase rate of […]

Filter according to cumulative value

Task:Find the top n customers whose sales accounts for […]

Divide columns

Task:List in column the information of employees whose […]

General operation

Task: Find out the males over 25 and females over 23 fr […]

WordCount

Task:Count the number of words in a file. Python 1 data […]