Merging: The VLOOKUP of Python

Python for Spreadsheet Users

Chris Cardillo

Data Scientist

VLOOKUP

full vlookup.png

Python for Spreadsheet Users

VLOOKUP - the key column

key columns no arrows.png

Python for Spreadsheet Users

VLOOKUP - A left join

key columns in vlookup.png

Python for Spreadsheet Users

VLOOKUP - #N/A

NA lookup.png

Python for Spreadsheet Users

The .merge() method

fruit color console.png

fruit_colors

fruit prices console.png

fruit_prices

Python for Spreadsheet Users

The .merge() method

fruit_colors.merge(fruit_prices, on='name', how='left')

Table Merges.png

Python for Spreadsheet Users

Key columns without the same name

fruit color console.png

fruit_colors

price with fruit_type column.png

fruit_prices

Python for Spreadsheet Users

left_on and right_on in .merge()

fruit_colors.merge(fruit_prices, 
                   left_on='name', 
                   right_on='fruit_type', 
                   how='left')

different key columns addition.png

Python for Spreadsheet Users

Your turn!

Python for Spreadsheet Users

Preparing Video For Download...