Python for Spreadsheet Manipulation 102

Python for Spreadsheet Manipulation 102

? "pypancsv" 2019

How I Found Python

Excel vs/and Python

(Today, just Python, for practice!)

What do YOU wish you could do?

(Remind me to repeat for the microphone, please)

Syllabus

102 (today)

101 recap Coding

Adding/dropping columns Basic matching / VLOOKUP Row Filtering If time: Selectively editing cells based on

column+row filter combinations

A simple pivot?

101 Recap

Coding 101

Pieces of Code: Expressions vs. Statements

Expressions 1 1+3 'Hi There' NULL True False 2 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download