If you've ever moved table-style data from Point A to Point B, you may have tried exporting it to CSV, cleaning the CSV file in Excel, and re-importing the results.
When Excel seems "just not quite enough" for that middle step, consider Python, a programming language that has exploded in popularity among non-programmers dealing with complex data problems.
See how short pieces of Python code can perform advanced filter-and-replace operations, summarize data, combine multiple CSV files (VLOOKUP across multiple columns? no problem!), and speed up processing of extra-large CSV files.
When it's faster to code Python, and when to click buttons in Excel
Some "programming 101" to help you read the session's demo code
Training and practice resources
This session is aimed at:
"Non-programmers" who are are pretty darned handy with Excel formulas, if you do say so yourselves
Non-Python programmers who want to see what CSV processing looks like in Python
Refusing to budge from sorting the closet "ROYGBV" by color since early childhood, and once told, "In my mind, your brain is shaped like an old-fashioned library card catalog," Katie is always thrilled to help others find -- and maintain -- order in their data.
This will add your name to the list of interested participants. It will help us gauge interest for scheduling purposes.