You are here: Home / Events / ACS - Open Source Data Analytics with Pandas

ACS - Open Source Data Analytics with Pandas

by Alan Milligan last modified Sep 02, 2015 12:11 PM
Python, and its "pandas" library, are becoming standard tools in scientific computing. Could they also have a role in the CFO's office?
When Oct 14, 2015
from 10:00 PM to 11:30 PM
Add event to calendar vCal


Python, and its "pandas" library, are becoming standard tools in scientific computing. Could they also have a role in the CFO's office?

CFOs regularly need to analyse the impact of different projects or business cases, and they almost universally do this using spreadsheets. Spreadsheets have many advantages - they have a low barrier to entry and are easy for most people to understand. However as they get more complicated, disadvantages start to appear; in particular, they can be inflexible and highly error-prone.

This talk will explain how business case analysis can be done using python and pandas. The python version has several advantages over spreadsheets: it is more flexible as the business structure changes; formulas only need to be changed in a single place, reducing the chance of error; and report-ready plots are quick to produce. Also demonstrated will be a way of structuring the problem for some simple business logic, and ways to visualise the results.

The example discussed is made more interesting and useful by being “Monte Carlo” analysis. Traditional business case analysis takes single point estimates of sales, costs and prices, and calculates a single profit forecast. Everybody knows the profit will not turn out to be exactly equal to the forecast. But it is not clear what the range of profits might be, or how likely a loss is. "Monte Carlo" analysis solves this problem by allowing ranges or distributions on the assumptions; the forecast is then a range of outcomes.


In short, the presentation will demonstrate how you can use pandas to analyse high-impact business decisions, and dodge many of the problems of using spreadsheets.



 Speaker Bio

Arthur Street has many years of experience consulting to corporates and modelling their business decisions, often using spreadsheets but sometimes even going so far as to use Mathematica, from his time as a senior manager at PricewaterhouseCoopers.  Since then he has used python to model risk and return at a funds management company, and more recently founded his own company, Artana, to focus on developing python and javascript webapps. He has been a regular speaker at FINSIA (the Financial Services Institute of Australia) on applications of real options, and has a PhD in physics from the California Institute of Technology. He presented on using python for business case analysis at PyCon AU, Australia's national python conference, last year.