From Spreadsheets to DataFrames: Escaping Excel Hell with Python

I gave a talk at STL Python last week about learning Python from an Excel User point of view. Content is available on link below:

https://github.com/ryansmccoy/spreadsheets-to-dataframes

A few highlights:

Excel to Python [Slides] – walk through a few examples of excel-to-python equivalents, including built-in functions (similar in both), external add-ins (pypi.org), and other examples. The reason I laid out this way because if you can associate a new concept with a concept you already know, then you are more likely to remember it later on.

Data Management [Slides] – A big part of being successful with data is having some sort of strategy for managing it. I basically lay out a few best practices for thinking about data.

Excel Hell

Leave a Reply

Your email address will not be published. Required fields are marked *