Bummer! This is just a preview. You need to be signed in with an account to view the entire instruction.
- Importing Data 1:29
- Exploration Methods
- Review Exploration Methods 3 questions
- Selecting Data
- Review Selecting Data 2 questions
- Optional Challenge #1 - Top Referrers
- Manipulation 0:50
- Manipulation Techniques
- Review Manipulation Techniques 4 questions
- Optional Challenge #2 - Update Users
- Combining DataFrames 0:55
- Combining DataFrames
- Handling Duplicated and Missing Data
- Review Merging and Handling Missing Data 3 questions
- Manipulating Text
- Optional Challenge #3 - Verified Email List
- Grouping
- Review Text Manipulation and Grouping 2 questions
- Until Next Time 1:15
Instruction
Exploration Methods
Exploration Methods
When you receive a CSV file from an external source, you'll want to get a feel for the data.
Let's import some data and then learn how to explore it.
# Setup
import os
import pandas as pd
# We use os.path.join because Windows uses a backslash (\) to separate directories
# while others use a forward slash (/)
users_file_name = os.path.join('data', 'users.csv')
users_...