Welcome to Python!

Python for Spreadsheet Users

Chris Cardillo

Data Scientist

What is Python?

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

Object-oriented spreadsheets

Object-oriented spreadsheets

Object-oriented Python

In Python

math.SUM(2,3)

In Spreadsheets

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

Scripts

A Recipe for Buttered Toast

1. Turn on toaster

2. Put bread in toaster for 1 minute

3. Take bread out of toaster

4. Put butter on toast

Importing packages

import math

Importing pandas

Importing pandas

import pandas

Loading Excel data

import pandas

pandas.read_excel('fruit.xlsx')

• fruit.xlsx
  • (the kind of data pandas likes)

pandas as pd

before

import pandas

pandas.read_excel('fruit.xlsx')

after

import pandas as pd

pd.read_excel('fruit.xlsx')

Variable assignment

import pandas as pd

fruit = pd.read_excel('fruit.xlsx')

fruit.xlsx

Looking at data with print()

import pandas as pd

fruit = pd.read_excel('fruit.xlsx')

print(fruit)

Script and console panes in DataCamp

• script.py is the script
• IPython Shell is the console

Your turn!

Python for Spreadsheet Users