Welcome to P y thon ! P YTH ON FOR SP R E AD SH E E T U SE R S - - PowerPoint PPT Presentation

▶
welcome to p y thon
SMART_READER_LITE
LIVE PREVIEW

Welcome to P y thon ! P YTH ON FOR SP R E AD SH E E T U SE R S - - PowerPoint PPT Presentation

Apr 14, 2023 261 likes •788 views

Welcome to P y thon ! P YTH ON FOR SP R E AD SH E E T U SE R S Chris Cardillo Data Scientist What is P y thon ? General p u rpose programming lang u age Has code packages for data science Object - oriented PYTHON FOR SPREADSHEET USERS Object

slide-1
SLIDE 1

Welcome to Python!

P YTH ON FOR SP R E AD SH E E T U SE R S

Chris Cardillo

Data Scientist

slide-2
SLIDE 2

PYTHON FOR SPREADSHEET USERS

What is Python?

General purpose programming language Has code packages for data science Object-oriented

slide-3
SLIDE 3

PYTHON FOR SPREADSHEET USERS

Object-oriented spreadsheets

slide-4
SLIDE 4

PYTHON FOR SPREADSHEET USERS

Object-oriented spreadsheets

slide-5
SLIDE 5

PYTHON FOR SPREADSHEET USERS

Object-oriented Python

In Python

math.SUM(2,3)

In Spreadsheets

slide-6
SLIDE 6

PYTHON FOR SPREADSHEET USERS

The power of the dot

math.SUM() math is our package SUM is our function in the

package The dot ( . ) lets us access the function inside the package

slide-7
SLIDE 7

PYTHON FOR SPREADSHEET USERS

Scripts

A Recipe for Buered Toast

  • 1. Turn on toaster
  • 2. Put bread in toaster for 1 minute
  • 3. Take bread out of toaster
  • 4. Put butter on toast
slide-8
SLIDE 8

PYTHON FOR SPREADSHEET USERS

Importing packages

import math

slide-9
SLIDE 9

PYTHON FOR SPREADSHEET USERS

Importing pandas

slide-10
SLIDE 10

PYTHON FOR SPREADSHEET USERS

Importing pandas

import pandas

slide-11
SLIDE 11

PYTHON FOR SPREADSHEET USERS

Loading Excel data

import pandas pandas.read_excel('fruit.xlsx')

fruit.xlsx (the kind of data pandas likes)

slide-12
SLIDE 12

PYTHON FOR SPREADSHEET USERS

pandas as pd

before

import pandas pandas.read_excel('fruit.xlsx')

aer

import pandas as pd pd.read_excel('fruit.xlsx')

slide-13
SLIDE 13

PYTHON FOR SPREADSHEET USERS

Variable assignment

import pandas as pd fruit = pd.read_excel('fruit.xlsx')

fruit.xlsx

slide-14
SLIDE 14

PYTHON FOR SPREADSHEET USERS

Looking at data with print()

import pandas as pd fruit = pd.read_excel('fruit.xlsx') print(fruit)

slide-15
SLIDE 15

PYTHON FOR SPREADSHEET USERS

Script and console panes in DataCamp

SCRIPT.PY is the script IPYTHON SHELL is the

console

slide-16
SLIDE 16

Your turn!

P YTH ON FOR SP R E AD SH E E T U SE R S

slide-17
SLIDE 17

DataFrames and their methods

P YTH ON FOR SP R E AD SH E E T U SE R S

Chris Cardillo

Data Scientist

slide-18
SLIDE 18

PYTHON FOR SPREADSHEET USERS

Where we left off

import pandas as pd fruit = pd.read_excel('fruit.xlsx') print(fruit)

slide-19
SLIDE 19

PYTHON FOR SPREADSHEET USERS

Anatomy of a pandas DataFrame

slide-20
SLIDE 20

PYTHON FOR SPREADSHEET USERS

Anatomy of a pandas DataFrame

slide-21
SLIDE 21

PYTHON FOR SPREADSHEET USERS

Anatomy of a pandas DataFrame

slide-22
SLIDE 22

PYTHON FOR SPREADSHEET USERS

Anatomy of a pandas DataFrame

slide-23
SLIDE 23

PYTHON FOR SPREADSHEET USERS

Anatomy of a pandas DataFrame

slide-24
SLIDE 24

PYTHON FOR SPREADSHEET USERS

Anatomy of a pandas DataFrame

slide-25
SLIDE 25

PYTHON FOR SPREADSHEET USERS

Anatomy of a pandas DataFrame

slide-26
SLIDE 26

PYTHON FOR SPREADSHEET USERS

DataFrame methods

.head() .info() .describe() .sort_values()

slide-27
SLIDE 27

PYTHON FOR SPREADSHEET USERS

The .head() method

import pandas as pd fruit = pd.read_excel('fruit.xlsx') print(fruit.head())

slide-28
SLIDE 28

PYTHON FOR SPREADSHEET USERS

The .head() method

import pandas as pd fruit = pd.read_excel('fruit.xlsx') print(fruit.head(2))

slide-29
SLIDE 29

PYTHON FOR SPREADSHEET USERS

The .info() method

import pandas as pd fruit = pd.read_excel('fruit.xlsx') print(fruit.info())

slide-30
SLIDE 30

PYTHON FOR SPREADSHEET USERS

The .describe() method

import pandas as pd fruit = pd.read_excel('fruit.xlsx') print(fruit.describe())

slide-31
SLIDE 31

PYTHON FOR SPREADSHEET USERS

The .sort_values() method

import pandas as pd fruit = pd.read_excel('fruit.xlsx') fruit = fruit.sort_values('name') fruit = fruit.reset_index(drop=True) print(fruit)

slide-32
SLIDE 32

PYTHON FOR SPREADSHEET USERS

The .sort_values() method

import pandas as pd fruit = pd.read_excel('fruit.xlsx') fruit = fruit.sort_values('price_usd', ascending=False) fruit = fruit.reset_index(drop=True) print(fruit.head(3))

slide-33
SLIDE 33

Your turn!

P YTH ON FOR SP R E AD SH E E T U SE R S

slide-34
SLIDE 34

Filtering rows and creating columns

P YTH ON FOR SP R E AD SH E E T U SE R S

Chris Cardillo

Data Scientist

slide-35
SLIDE 35

PYTHON FOR SPREADSHEET USERS

Filtering in spreadsheets

slide-36
SLIDE 36

PYTHON FOR SPREADSHEET USERS

Accessing a single column

slide-37
SLIDE 37

PYTHON FOR SPREADSHEET USERS

Accessing a single column

fruit['name']

slide-38
SLIDE 38

PYTHON FOR SPREADSHEET USERS

Comparison operators

== (equal to) != (not equal to) < (less than) > (greater than) <= (less than or equal to) >= (greater or equal to)

slide-39
SLIDE 39

PYTHON FOR SPREADSHEET USERS

Comparisons

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

slide-40
SLIDE 40

PYTHON FOR SPREADSHEET USERS

Filtering

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

slide-41
SLIDE 41

PYTHON FOR SPREADSHEET USERS

Filtering

fruit[fruit['price_usd'] > 1]

slide-42
SLIDE 42

PYTHON FOR SPREADSHEET USERS

Filtering

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

slide-43
SLIDE 43

PYTHON FOR SPREADSHEET USERS

Basic filtering pattern

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

slide-44
SLIDE 44

PYTHON FOR SPREADSHEET USERS

Basic filtering pattern

In Python

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

In Spreadsheets

slide-45
SLIDE 45

PYTHON FOR SPREADSHEET USERS

Creating a new column

slide-46
SLIDE 46

PYTHON FOR SPREADSHEET USERS

Creating a new column

slide-47
SLIDE 47

PYTHON FOR SPREADSHEET USERS

Mathematical operators

+ (addition)

  • (subtraction)

* (multiplication) / (division)

slide-48
SLIDE 48

PYTHON FOR SPREADSHEET USERS

Creating a new column

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

slide-49
SLIDE 49

PYTHON FOR SPREADSHEET USERS

Creating a new column

slide-50
SLIDE 50

PYTHON FOR SPREADSHEET USERS

Creating a new column

slide-51
SLIDE 51

PYTHON FOR SPREADSHEET USERS

Creating a new column

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

slide-52
SLIDE 52

Your turn!

P YTH ON FOR SP R E AD SH E E T U SE R S