Filtrera rader och skapa kolumner

Python för kalkylbladsanvändare

Chris Cardillo

Data Scientist

Filtrering i kalkylblad

sheets filter for apple.png

simple fruit whole dataset.png

fruit['name']

simple fruit df name column.png

fruit['name']

simple fruit df name column.png

fruit['name'] == "Apple"

simple fruit df name col equals apple.png

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

simple fruit df apple only.png

fruit[fruit['price_usd'] > 1]

simple fruit df price greater than 1.png

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

simple fruit df price greater than 1 clean index.png

df[df['this_column'] == 'that value']

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

simple fruit df apple only.png

sheets filter for apple.png

simple fruit whole dataset.png

new column spreadsheets.png

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

simple fruit with simple cost.png

simple fruit df with quantity column.png

new column with two columns spreadsheets.png

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

simple fruit df with quantity and cost columns.png

Python för kalkylbladsanvändare