Python in Excel a Smarter Way to Use External Data. Watch this video on YouTube. ... Using `.describe()` to summarize numeric columns, such as calculating the mean, median, ...