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