Pandas: Complex aggregation expressions
Using a dictionary of aggreations
Pandas: Complex aggregation expressions
Using a dictionary of aggreations
Pandas: Calculate percentile ranking relative to another column
Via the searchsorted command
CompSci: GUIDs are not strings
The string representation of a GUID should not be relevant to a program
AWS CLI: List account aliases
Using the aws iam list-account-aliases command
SQL: UNION v UNION ALL
UNION removes duplicate records, whereas UNION ALL does not