Introduction to the Course-About the Course
Course Introduction
()
About Ronald Guymon
()
About Linden Lu
()
Syllabus
Glossary
About the Discussion Forums
Online Education at Gies College of Business
Introduction to the Course-About Your Classmates
Update Your Profile
Module 1: Foundations-Module 1 Information
Module 1 Overview
Module 1 Readings
Module 1 Introduction
()
Module 1: Foundations-Lesson 1.1: Introduction to Data Analytics
Lesson 1.1 Readings
1.1 Introduction to Data Analytics
()
Module 1: Foundations-Lesson 1.2: Jupyter Notebook
1.2 Jupyter Notebook
()
Python and Integrated Development Environments (IDEs)
()
Installing and Running Python Using the Anaconda Distribution
()
Installing and Running Python Without Anaconda
()
Navigating Jupyter Notebook
()
Navigating JupyterLab
()
Using Notebook Files
()
Navigating Spyder
()
Comparison of Jupyter Notebook, JupyterLab, and Spyder
()
Module 1: Foundations-Lesson 1.3: Introduction to Markdown
1.3 Introduction to Markdown
()
Markdown Basics
()
Module 1: Foundations-Module 1 Conclusion
Module 1 Review
()
Module 2: Introduction to Python-Module 2 Information
Module 2 Overview
Module 2 Readings
Module 2 Introduction
()
Module 2: Introduction to Python-Lesson 2.1: Introduction to Python
2.1 Introduction to Python
()
Python Code Basics
()
Variables, Data Types, and Operators
()
Module 2: Introduction to Python-Lesson 2.2: Introduction to Python Functions
2.2 Introduction to Python Functions
()
Built-In Functions
()
User-Defined Functions
()
Functions vs Methods
()
Module 2: Introduction to Python-Lesson 2.3: Conditional Statements in Python
2.3 Conditional Statements in Python
()
Comparison and Logical Operators
()
Working With Conditional Statements
()
Module 2: Introduction to Python-Module 2 Conclusion
Module 2 Review
()
Module 3: Introduction to Python Programming-Module 3 Information
Module 3 Overview
Module 3 Readings
Module 3 Introduction
()
Module 3: Introduction to Python Programming-Lesson 3.1: Introduction to Python Data Structures
3.1 Introduction to Python Data Structures
()
Introduction to Strings
()
Introduction to Lists
()
Introduction to Dictionaries, Tuples, and Unpacking
()
Common Sequence Operations
()
Module 3: Introduction to Python Programming-Lesson 3.2: Working with Python Data Structures
3.2 Working With Python Data Structure
()
Working With Strings
()
Working With Lists and Tuples
()
Working With Dictionaries
()
Module 3: Introduction to Python Programming-Lesson 3.3: Introduction to Python Loops
3.3 Introduction to Python Loops
()
The For Loop
()
The While Loop
()
Comprehensions
()
Module 3: Introduction to Python Programming-Module 3 Conclusion
Module 3 Review
()
Module 4: Python Programming-Module 4 Information
Module 4 Overview
Module 4 Readings
Module 4 Introduction
()
Module 4: Python Programming-Lesson 4.1: Writing Python Programs
4.1 Writing Python Programs
()
Python Modules
()
Errors and Exceptions
()
Module 4: Python Programming-Lesson 4.2: Introduction to NumPy
4.2 Introduction to NumPy
()
NumPy Array
()
NumPy Basic Functions
()
Module 4: Python Programming-Lesson 4.3: Introduction to Pandas
4.3 Introduction to Pandas
()
Introduction to Dataframes
()
Data Selection With Dataframes
()
Missing Values and Copies With Dataframes
()
Module 4: Python Programming-Module 4 Conclusion
Module 4 Review
()
Module 5: Data Analysis With Python-Module 5 Information
Module 5 Overview
Module 5 Readings
Module 5 Introduction
()
Module 5: Data Analysis With Python-Lesson 5.1: Python File I/O
5.1 Python File IO
()
Reading and Writing Files With Base Python
()
Reading and Writing Files With Pandas
()
Preserving Data Types With Pickling
()
Module 5: Data Analysis With Python-Lesson 5.2: Working With the Pandas Dataframe
5.2 Working With the Pandas DataFrame
()
Exploring Dataframes
()
Copying and Sorting Dataframes
()
Changing Column and Row Names of Dataframes
()
Grouping and Aggregating With Dataframes
()
Stacking and Pivoting Dataframes
()
Module 5: Data Analysis With Python-Lesson 5.3: Introduction to Descriptive Statistics
5.3 Introduction to Descriptive Statistics
()
Descriptive Statistics for Dataframes
()
Module 5: Data Analysis With Python-Module 5 Conclusion
Module 5 Review
()
Module 6: Introduction to Visualization in Python-Module 6 Information
Module 6 Overview
Module 6 Readings
Module 6 Introduction
()
Module 6: Introduction to Visualization in Python-Lesson 6.1: Introduction to Plotting With Python
6.1 Introduction to Plotting With Python
()
Introduction to Plotting With Pandas
()
More on Plotting With Pandas
()
Introduction to matplotlib
()
More on Plotting With matplotlib
()
Introduction to Plotting With Seaborn
()
Module 6: Introduction to Visualization in Python-Lesson 6.2: Introduction to One-Dimensional Data Visualizations
6.2 Introduction to One-Dimensional Data Visualization
()
Introduction to Seaborn Histograms
()
Introduction to Seaborn Box Plots
()
Introduction to Seaborn Bar Plots
()
Module 6: Introduction to Visualization in Python-Lesson 6.3: Introduction to Two-Dimensional Data
6.3 Introduction to Two-Dimensional Data
()
Introduction to Scatter Plots
()
Introduction to Pair Plots
()
Introduction to Joint Plots
()
Module 6: Introduction to Visualization in Python-Module 6 Conclusion
Module 6 Review
()
Module 7: Production Data Analytics-Module 7 Information
Module 7 Overview
Module 7 Readings
Module 7 Introduction
()
Module 7: Production Data Analytics-Lesson 7.1: Introduction to CRISP-DM
7.1 Introduction to CRISP-DM
()
Module 7: Production Data Analytics-Lesson 7.2: Introduction to Data Preparation Techniques
7.2 Introduction to Data Preparation Techniques
()
Pandas Functions to Load Data
()
Fill in Missing Values With Conditional Means
()
Manipulating String Columns of a Dataframe
()
Creating Datetime Values
()
Split, Apply Combine and More on Datetimes
()
Lambda Functions
()
Module 7: Production Data Analytics-Lesson 7.3: Linear Regression in Python
7.3 Linear Regression in Python
()
Setting up Data for Regression
()
Creating a Simple Regression Model
()
Predicting with a Regression Model
()
Multiple Regression Model
()
Categorical Variables in Regression
()
Module 7: Production Data Analytics-Module 7 Conclusion
Module 7 Review
()
Module 8: Introduction to Databases in Python-Module 8 Information
Module 8 Overview
Module 8 Readings
Module 8 Introduction
()
Module 8: Introduction to Databases in Python-Lesson 8.1: Introduction to Data Persistence
8.1 Introduction to Data Persistence
()
Introduction to Terminal
()
Creating a SQLite Database From Terminal
()
Creating a SQLite Table From a CSV File
()
Using Dump and Reading in Files to Create Tables
()
Altering Existing SQLite Tables
()
Module 8: Introduction to Databases in Python-Lesson 8.2: SQL: Advanced Concepts
8.2 Advanced Concepts
()
Querying Tables with SQL
()
SQL Join Queries
()
Module 8: Introduction to Databases in Python-Lesson 8.3: Python Database Programming
8.3 Python Database Programming
()
Querying Relational Database With Python and SQL
()
Exploring Databases and Adding Rows to Tables With Python
()
Module 8: Introduction to Databases in Python-Module 8 Conclusion
Module 8 Review
()
Congratulations on completing the course!
Get Your Course Certificate
Learn on Your Terms
()