1
Q
What is an inner join (or just join)?
A
Keeps only the records in which the key field is in both tables
2
Q
What is a LEFT JOIN? (RIGHT)
A
Keeps all fields in the left table, and all matches in the right (Opposite)
3
Q
What happens to fields that don’t match on LEFT/RIGHT/FULL JOINS?
A
Listed as missing values
4
Q
What is a FULL JOIN?
A
All values in both tables
5
Q
What is a CROSS JOIN?
A
Gives all combinations of rows from both tables
Python for Data Science
flashcards
Decks in class (16)
# Cards
-
Wk 1: Data Science Process15
-
Wk 2: Background in Python and Unix20
-
SQL Joins5
-
Py Lists (Datacamp + UCSD Wk 2)28
-
DataCamp: Python Basics - Functions18
-
Numpy (Wk 3 UCSD / DataCamp)27
-
Python String Functions (UC-Wk 2)8
-
Tuples & Dictionaries (UCSD - Wk 2)32
-
Jupyter Notebooks (US Wk 3)11
-
Git Bash Commands - UNIX like (Wk 3 UCSD)27
-
Git Bash cmds - Unix like (Wk 2 UCSD)11
-
Pandas Pt 1 (Wk 4 UCSD)31
-
Pandas Pt 1 - Cont'd (UCSD)7
-
Pandas Pt 2 (UCSD)14
-
Pandas Pt 3 (UCSD)15
-
Data Visualization (UCSD)14
