Pamela Fox (31)
Plan for tomorrow at #PyconUS:
* Education Summit @ 9am, where I'll talk about teaching with Codespaces
* MS sponsored session @ 3:30 pm, where Rohit and I will give a whirlwind tour of app development with VS Code, extensions (including a brand new one...!!), and Azure
Finally got to play with the =PY() formula in Excel, thanks to the #PyconUS tutorial from @crazy4pi314
Learnt how to render data frames, explode numpy matrices, and calculate Tetris scores (a problem from the annual Excel competition, which apparently is a thing...)
Working with XLSX files in VS Code?
VS Code extension recommendations from @crazy4pi314 in #PyconUS tutorial
* Excel Viewer: https://marketplace.visualstudio.com/items?itemName=GrapeCity.gc-excelviewer
* Data Wrangler: https://marketplace.visualstudio.com/items?itemName=ms-toolsai.datawrangler
Learnt a ton from @crazy4pi314 in their "Snakes in a Grid" tutorial at #PyconUS about how we can use Python to work with Excel spreadsheets:
* Use pandas read_excel() to turn an XLSX into a dataframe, and to_excel() to turn a dataframe to an XLSX
https://github.com/crazy4pi314/snakes-in-a-grid/blob/main/2_work-with-pandas.ipynb
* Use openpyxl to create a spreadsheet from scratch, complete with working formulas and charts!
https://github.com/crazy4pi314/snakes-in-a-grid/blob/main/3_work-with-openpyxl.ipynb
Now I'm in the "Snakes in a Grid" tutorial @ #PyconUS from @crazy4pi314 -
we're going to put excel in our python and python in our excel! 🐍 📊
First up at #PyconUS, @tonybaloney is giving an AI Crash Course.
Exercises and slides in:
https://github.com/tonybaloney/PyCon-AI-Crash-Course
