Installation and Setup
  • Introduction to Data Analysis with Pandas and Python
  • About Me
  • Completed Course Files
  • MacOS - Download the Anaconda Distribution, our Python development environment
  • MacOS - Install Anaconda Distribution
  • MacOS - Access the Terminal Application
  • MacOS - Create conda Environment and Install pandas and Jupyter Notebook
  • MacOS - Unpack Course Materials + The Start and Shutdown Process
  • Windows - Download the Anaconda Distribution
  • Windows - Install Anaconda Distribution
  • Windows - Create conda Environment and Install pandas and Jupyter Notebook
  • Windows - Unpack Course Materials + The Startdown and Shutdown Process
  • Intro to the Jupyter Notebook Interface
  • Cell Types and Cell Modes in Jupyter Notebook
  • Code Cell Execution in Jupyter Notebook
  • Popular Keyboard Shortcuts in Jupyter Notebook
  • Import Libraries into Jupyter Notebook
  • Troubleshooting Issues with Jupyter Notebook
BONUS: Python Crash Course
  • Intro to the Python Crash Course
  • Comments
  • Basic Data Types
  • Operators
  • Variables
  • Built-in Functions
  • Custom Functions
  • String Methods
  • Lists
  • Index Positions and Slicing
  • Dictionaries
Series
  • Create Jupyter Notebook for the Series Module
  • Create A Series Object from a Python List
  • Create A Series Object from a Python Dictionary
  • Create a Series Object
  • Coding Exercise SOLUTION: Create a Series Object
  • Intro to Attributes on a Series Object
  • Intro to Methods on a Series Object
  • Parameters and Arguments
  • Create Series from Dataset with the pd.read_csv Method
  • Import Series with the read_csv Function
  • Coding Exercise SOLUTION: Import Series with the read_csv Function
  • Use the head and tail Methods to Return Rows from Beginning and End of Dataset
  • Passing pandas Objects to Python Built-In Functions
  • Accessing More Series Attributes
  • Use the sort_values method to sort a Series in ascending or descending order
  • Use the inplace Parameter to permanently mutate a pandas data structure
  • Use the sort_index Method to Sort the Index of a pandas Series object
  • The sort_values and sort_index Methods
  • Coding Exercise SOLUTION: The sort_values and sort_index Methods
  • Use Python's in Keyword to Check for Inclusion in Series values or index
  • Extract Series Values by Index Positiox
  • Extract Series Values by Index Label
  • Extract Series Values by Index Position or Index Label
  • Coding Exercise SOLUTION: Extract Series Values by Index Position or Index Label
  • Use the get Method to Retrieve a Value for an index label in a Series
  • Math Methods on Series Objects
  • Use the idxmax and idxmin Methods to Find Index of Greatest or Smallest Value
  • Use the value_counts Method to See Counts of Unique Values within a Series
  • Use the apply Method to Invoke a Function on Every Series Values
  • The Series#map Method
  • A Review of the Series Module
DataFrames I: Introduction
  • Intro to DataFrames I Module
  • Shared Methods and Attributes between Series and DataFrames
  • Differences between Shared Methods
  • Select One Column from a DataFrame
  • Select One Column from a DataFrame
  • Coding Exercise SOLUTION: Select One Column from a DataFrame
  • Select Two or More Columns from a DataFrame
  • Select Two or More Columns from a DataFrame
  • Coding Exercise SOLUTION: Select Two or More Columns from a DataFrame
  • Add New Column to DataFrame
  • Broadcasting Operations on DataFrames
  • A Review of the value_counts Method
  • Drop DataFrame Rows with Null Values with the dropna Method
  • Delete DataFrame Rows with Missing Values
  • Coding Exercise SOLUTION: Delete DataFrame Rows with Missing Values
  • Fill in Null DataFrame Values with the fillna Method
  • Convert DataFrame Column Types with the astype Method
  • Sort a DataFrame with the sort_values Method, Part I
  • Sort a DataFrame with the sort_values Method, Part II
  • The sort_values Method on a DataFrame
  • Coding Exercise SOLUTION: The sort_values Method on a DataFrame
  • Sort DataFrame Indexwith the sort_index Method
  • Rank Series Values with the rank Method
DataFrames II: Filtering Data
  • This Module's Dataset + Memory Optimization
  • Filter a DataFrame Based on A Condition
  • Filter DataFrame with More than One Condition (AND - &)
  • Filter DataFrame with More than One Condition (OR - |)
  • Check for Inclusion with the isin Method
  • Check for Null and Present DataFrame Values with the isnull and notnull Methods
  • Check For Inclusion Within a Range of Values with the between Method
  • Check for Duplicate DataFrame Rows with the duplicated Method
  • Delete Duplicate DataFrame Rows with the drop_duplicates Method
  • Identify and Count Unique Values with the unique and nunique Methods
DataFrames III: Data Extraction
  • Intro to the DataFrames III Module + Import Dataset