Update! (Oct 2018)

Hey there readers! Thanks for your patience with my long delay in posting, life's been crazy but good stuff. I've switched back to working at big4, with a focus on Data Analytics and Accounting, have had 2 kids, and moved back to the DC area. I've been doing a lot with Python, and am very excited to share here what I've been up to!

First off, let me say that this is a really exciting time for any of you who are accounting professionals or accounting students and are interested in Python, data analytics, and/or data visualization. I'm planning to get into some of the cool things happening around all of those, and share my adventures with all.

One notable interesting pursuit I've been working on is with the AICPA's Audit Data Analytics committee. I worked with a working group on the committee to put together some code and a jupyter notebook to pull in a sample trial balance and general ledger, and run some standard journal entry tests on the data. I also recorded a video showing how the notebook works, which should be getting posted to AICPA's site and youtube shortly. The code can be found on github here.

I also presented at an ISACA conference in DC on using Python for improving the IT audit process. Here's the slide deck.

I've been thinking a lot about how to get Python into the hands of non-programmer accountants, and I think one of the easiest ways right now is through Microsoft's Azure platform. It's currently free to run Python code in the cloud, as long as you have a Microsoft account. I can create notebooks in folders available to the public, and you can go and easily clone the folder and start using it on your own.

Try out Python!

Let's try this - if you're reading this and interested in trying Python, go over to Microsoft's Azure website to login and clone their intro library.

Step 1- Go to https://notebooks.azure.com/Microsoft/libraries/samples
Step 2- Click the Clone icon
Step 3- Login to your Microsoft account. Now you should see a page that looks just like the Microsoft page, but now it's in your own personal notebook folder.
Step 4- Click on the "Introduction to Python.ipynb" file to open up the interactive notebook.

Now you should be able to interact with the notebook, being able to edit and run the cells. To run a cell, hold Shift and press Enter on your keyboard.

If this is easy enough to do, then try doing the same thing with my "Accounting and Python Basics.ipynb" file at https://notebooks.azure.com/danshorstein/libraries/python4cpas

Here's a screenshot of the notebook:

Cheers!
-Dan