The purpose of this article is to show some common Excel tasks and how you would do them in pandas.
Python, pandas and matplot can be used to create a waterfall chart.
Pandas can be used to create a diff tool that compares two similar Excel spreadsheets.
Pandas and IPython allow you to quickly and easily manipulate data and create useful graphs.
There are many useful python tools to quickly and easily analyze large volumes of data.