Preparing to put tables together

Python for Spreadsheet Users

Chris Cardillo

Data Scientist

Table merging

Table merging

Merging: The VLOOKUP of Data Science

Merging: The VLOOKUP of Data Science

Merging: The VLOOKUP of Data Science

Merging in Python

• Python is case-sensitive!
  • 'Apple' != 'apple'

Merging in Python

• Python is case-sensitive!
  • 'Apple' != 'apple'
• Python is exact with whitespace!
  • 'Apple' != ' Apple '

Merging in Python

• Python is case-sensitive!
  • 'Apple' != 'apple'
• Python is exact!
  • 'Apple' != ' Apple '
• Python joins whole tables!
  • AB + ACD = ABCD, even if we only want ABC
  • So we have to drop column D.

Handling case-sensitivity

fruit_Price - Uppercase Name

fruit_Color - title case name

.str.title() method

fruit_price['name'].str.title()

.str.title() method

fruit_price['name'] = fruit_price['name'].str.title()

print(fruit_price)

.str.upper() method

fruit_price['name'] = fruit_price['name'].str.upper()

print(fruit_price)

.str.lower() method

fruit_price['name'] = fruit_price['name'].str.lower()

print(fruit_price)

.str.title() method

fruit_price['name'] = fruit_price['name'].str.title()

print(fruit_price)

Handling whitespace with .str.strip()

fruit_price['name'] = fruit_price['name'].str.strip()

print(fruit_price)

Selecting and dropping columns

Selecting columns

Select Columns

fruit_price[['name', 'price_usd']]

Selecting columns

Select Columns

fruit_price = fruit_price[['name', 'price_usd']]

Dropping Columns with .drop()

Drop Columns

fruit_price.drop('unneeded', axis=1)

Dropping Columns

Drop Columns

fruit_price = fruit_price.drop('unneeded', axis=1)

Your turn!

Python for Spreadsheet Users