Filtering rows and creating columns

Python for Spreadsheet Users

Chris Cardillo

Data Scientist

Filtering in spreadsheets

sheets filter for apple.png

Python for Spreadsheet Users

Accessing a single column

simple fruit whole dataset.png

Python for Spreadsheet Users

Accessing a single column

fruit['name']

simple fruit df name column.png

Python for Spreadsheet Users

Comparison operators

  • == (equal to)
  • != (not equal to)
  • < (less than)
  • > (greater than)
  • <= (less than or equal to)
  • >= (greater or equal to)
Python for Spreadsheet Users

Comparisons

fruit['name']

simple fruit df name column.png

fruit['name'] == "Apple"

simple fruit df name col equals apple.png

Python for Spreadsheet Users

Filtering

fruit[fruit['name'] == "Apple"]

simple fruit df apple only.png

Python for Spreadsheet Users

Filtering

fruit[fruit['price_usd'] > 1]

simple fruit df price greater than 1.png

Python for Spreadsheet Users

Filtering

fruit[fruit['price_usd'] > 1].reset_index(drop=True)

simple fruit df price greater than 1 clean index.png

Python for Spreadsheet Users

Basic filtering pattern

df[df['this_column'] == 'that value']
Python for Spreadsheet Users

Basic filtering pattern

In Python
fruit[fruit['name'] == "Apple"]

simple fruit df apple only.png

In Spreadsheets

sheets filter for apple.png

Python for Spreadsheet Users

Creating a new column

simple fruit whole dataset.png

Python for Spreadsheet Users

Creating a new column

new column spreadsheets.png

Python for Spreadsheet Users

Mathematical operators

  • + (addition)
  • - (subtraction)
  • * (multiplication)
  • / (division)
Python for Spreadsheet Users

Creating a new column

fruit['cost'] = fruit['price_usd'] * 2

simple fruit with simple cost.png

Python for Spreadsheet Users

Creating a new column

simple fruit df with quantity column.png

Python for Spreadsheet Users

Creating a new column

new column with two columns spreadsheets.png

Python for Spreadsheet Users

Creating a new column

fruit['cost'] = fruit['price_usd'] * fruit['quantity']

simple fruit df with quantity and cost columns.png

Python for Spreadsheet Users

Your turn!

Python for Spreadsheet Users

Preparing Video For Download...