Intermediate · 30 min · 5 steps
One giant booking made the average lie, so we checked for outliers
Sameer Malhotra, Senior Financial Data Analyst at AeroReserve Corporate
It is 9:00 AM on a Tuesday. Sameer Malhotra, a financial data analyst at AeroReserve Corporate, is called into an urgent meeting with the Chief Financial Officer. AeroReserve books flights and hotels for companies across South Asia. At last quarter's board meeting, the analytics team reported that the average order value for hotel rooms was ₹1,420.
The question
How do we use the interquartile range (IQR) in pandas to find unusually large orders, and how far apart are the mean and the median?
- Outlier detection
- IQR
- Quantiles
- Data cleaning
The rest of this case study is locked
The data, every step with its code and result, and the final answer open with a pass. A few case studies stay free so you can see how they work.