Excel is ubiquitous in the business world and can be an extremely powerful tool. However, there are way too many instances where it is abused and used to create unsustainable solutions to very real business problems. Fortunately python is an open source language with a powerful data manipulation library called pandas that can help relieve some of this pain.
This talk will discuss some of the challenges with trying to use Excel as the primary tool for data wrangling including:
After discussing some of the types of problems with an Excel-based solution, I will cover:
The purpose of the talk is to give a broad overview of a potential solution and provide pointers on next steps to implement in your own organization. The topic does not require any specific technical experience or knowledge.
Chris has been working with python and other open source technologies for many years. He frequently blogs at Practical Business Python.