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?

................
................

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

Google Online Preview   Download