Periscope Data Blog Calculating Trimmed Means (SQL and Python Variations)

Data can often have extreme outliers, which can heavily skew certain metrics, such as the mean. One way to get around this is to use a trimmed mean. Here's how to use SQL and Python to calculate trimmed means.