Data Analysis with Pandas and Python

5( 10 REVIEWS )
149 STUDENTS

Course Curriculum

1. Course introduction and welcome
Introduction to the Course 00:12:00
Mac OS – Download the Anaconda Distribution 00:03:00
Mac OS – Install Anaconda Distribution 00:07:00
Mac OS – Access the Terminal 00:02:00
Mac OS – Update Anaconda Libraries 00:11:00
Mac OS – Unpack Course Materials + The Startdown and Shutdown Process 00:10:00
Windows – Download the Anaconda Distribution 00:04:00
Windows – Install Anaconda Distribution 00:05:00
Windows – Access the Command Prompt and Update Anaconda Libraries 00:10:00
Windows – Unpack Course Materials + The Startdown and Shutdown Process 00:09:00
Intro to the Jupyter Notebook Interface 00:05:00
Cell Types and Cell Modes 00:07:00
Code Cell Execution 00:05:00
Popular Keyboard Shortcuts 00:03:00
Import Libraries into Jupyter Notebook 00:07:00
Python Crash Course, Part 1 – Data Types and Variables 00:07:00
Python Crash Course, Part 2 – Lists 00:05:00
Python Crash Course, Part 3 – Dictionaries 00:04:00
Python Crash Course, Part 4 – Operators 00:05:00
Python Crash Course, Part 5 – Functions 00:06:00
Series
Create Jupyter Notebook for the Series Module 00:02:00
Create A Series Object from a Python List 00:11:00
Create A Series Object from a Python Dictionary 00:03:00
Intro to Attributes 00:07:00
Intro to Methods 00:05:00
Parameters and Arguments 00:10:00
Import Series with the read_csv() Method 00:10:00
The head() and tail() Methods 00:04:00
Python Built-In Functions 00:05:00
More Series Attributes 00:06:00
The sort_values() Method 00:06:00
The inplace Parameter 00:05:00
The sort_index() Method 00:05:00
Python’s in Keyword 00:04:00
Extract Series Values by Index Position 00:04:00
Extract Series Values by Index Label 00:07:00
The get() Method on a Series 00:05:00
Math Methods on Series Objects 00:06:00
The idxmax() and idxmin() Methods 00:03:00
The value_counts() Method 00:04:00
The apply() Method 00:07:00
The map() Method 00:07:00
DataFrames I
Intro to DataFrames I Module 00:07:00
Shared Methods and Attributes between Series and DataFrames 00:08:00
Differences between Shared Methods 00:07:00
Select One Column from a DataFrame 00:08:00
Select Two or More Columns from a DataFrame 00:05:00
Add New Column to DataFrame 00:08:00
Broadcasting Operations 00:09:00
A Review of the value_counts() Method 00:04:00
Drop Rows with Null Values 00:07:00
Fill in Null Values with the fillna() Method 00:04:00
The astype() Method 00:11:00
Sort a DataFrame with the sort_values() Method, Part I 00:06:00
Sort a DataFrame with the sort_values() Method, Part II 00:04:00
Sort DataFrame with the sort_index() Method 00:03:00
Rank Values with the rank() Method 00:06:00
DataFrames II
This Module’s Dataset + Memory Optimization 00:11:00
Filter a DataFrame Based on A Condition 00:13:00
Filter with More than One Condition (AND – &) 00:05:00
Filter with More than One Condition (OR – ) 00:09:00
The isin() Method 00:06:00
The isnull() and notnull() Methods 00:05:00
The between() Method 00:07:00
The duplicated() Method 00:09:00
The drop_duplicates() Method 00:08:00
The unique() and nunique() Methods 00:04:00
DataFrames III
Intro to the DataFrames III Module + Import Dataset 00:03:00
The set_index() and reset_index() Methods 00:06:00
Retrieve Rows by Index Label with loc[] 00:10:00
Retrieve Rows by Index Position with iloc[] 00:06:00
The Catch-All ix[] Method 00:09:00
Second Arguments to loc[], iloc[], and ix[] Methods 00:06:00
Set New Values for a Specific Cell or Row 00:04:00
Set Multiple Values in DataFrame 00:09:00
Rename Index Labels or Columns in a DataFrame 00:07:00
Delete Rows or Columns from a DataFrame 00:07:00
Create Random Sample with the sample() Method 00:05:00
The nsmallest() and nlargest() Methods 00:06:00
Filtering with the where() Method 00:05:00
The query() Method 00:09:00
A Review of the apply() Method on Single Columns 00:06:00
The apply() Method with Row Values 00:07:00
The copy() Method 00:07:00
Working with Text Data
Intro to the Working with Text Data Module 00:06:00
Common String Methods – lower, upper, title, and len 00:07:00
The strreplace() Method 00:08:00
Filtering with String Methods 00:07:00
More String Methods – strip, lstrip, and rstrip 00:05:00
String Methods on Index and Columns 00:06:00
Split Strings by Characters with strsplit() Method 00:09:00
More Practice with Splits 00:06:00
The expand and n Parameters of the strsplit() Method 00:07:00
MultiIndex
Intro to the MultiIndex Module 00:04:00
Create a MultiIndex with the set_index() Method 00:10:00
The get_level_values() Method 00:08:00
The set_names() Method 00:03:00
The sort_index() Method 00:05:00
Extract Rows from a MultiIndex DataFrame 00:09:00
The transpose() Method and MultiIndex on Column Level 00:06:00
The swaplevel() Method 00:03:00
The stack() Method 00:06:00
The unstack() Method, Part 1 00:04:00
The unstack() Method, Part 2 00:06:00
The unstack() Method, Part 3 00:05:00
The pivot() Method 00:07:00
The pivot_table() Method 00:10:00
The pdmelt() Method 00:06:00
GroupBy
Intro to the Groupby Module 00:08:00
First Operations with groupby Object 00:10:00
Retrieve A Group with the get_group() Method 00:04:00
Methods on the Groupby Object and DataFrame Columns 00:09:00
Grouping by Multiple Columns 00:05:00
The agg() Method 00:06:00
Iterating through Groups 00:09:00
Merging, Joining, and Concatenating
Intro to the Merging, Joining, and Concatenating Module 00:06:00
The pdconcat() Method, Part 1 00:06:00
The pdconcat() Method, Part 2 00:07:00
The append() Method on a DataFrame 00:02:00
Inner Joins, Part 1 00:09:00
Inner Joins, Part 2 00:09:00
Outer Joins 00:12:00
Left Joins 00:09:00
The left_on and right_on Parameters 00:09:00
Merging by Indexes with the left_index and right_index Parameters 00:11:00
The join() Method 00:03:00
The pdmerge() Method 00:03:00
Working with Dates and Times
Intro to the Working with Dates and Times Module 00:04:00
Review of Python’s datetime Module 00:10:00
The pandas Timestamp Object 00:07:00
The pandas DateTimeIndex Object 00:05:00
The pdto_datetime() Method 00:11:00
Create Range of Dates with the pddate_range() Method, Part 1 00:10:00
Create Range of Dates with the pddate_range() Method, Part 2 00:09:00
Create Range of Dates with the pddate_range() Method, Part 3 00:08:00
The dt Accessor 00:07:00
Install pandas-datareader Library 00:03:00
Import Financial Data Set with pandas_datareader Library 00:11:00
Selecting Rows from a DataFrame with a DateTimeIndex 00:08:00
All About Hadoop: The Big Data Lingo Chapter 01:00:00
The truncate() Method 00:03:00
pdDateOffset Objects 00:12:00
More Fun with pdDateOffset Objects 00:14:00
The pandas Timedelta Object 00:09:00
Timedeltas in a Dataset 00:10:00
Panels
Intro to the Module + Fetch Panel Dataset from Google Finance 00:07:00
The Axes of a Panel Object 00:08:00
Panel Attributes 00:05:00
Use Bracket Notation to Extract a DataFrame from a Panel 00:04:00
Extracting with the loc, iloc, and ix Methods 00:07:00
Convert Panel to a MultiIndex DataFrame (and Vice Versa) 00:04:00
The major_xs() Method 00:06:00
The minor_xs() Method 00:06:00
Transpose a Panel with the transpose() Method 00:08:00
The swapaxes() Method 00:04:00
Input and Output
Intro to the Input and Output Module 00:02:00
Feed pdread_csv() Method a URL Argument 00:04:00
Quick Object Conversions 00:05:00
Export DataFrame to CSV File with the to_csv() Method 00:06:00
Install xlrd and openpyxl Libraries to Read and Write Excel Files 00:03:00
Import Excel File into pandas 00:10:00
Export Excel File 00:09:00
Visualization
Intro to Visualization Module 00:04:00
The plot() Method 00:09:00
Modifying Aesthetics with Templates 00:05:00
Bar Graphs 00:06:00
Pie Charts 00:05:00
Histograms 00:06:00
Options and Settings
Introduction to the Options and Settings Module 00:02:00
Changing pandas Options with Attributes and Dot Syntax 00:07:00
Changing pandas Options with Methods 00:06:00
The precision Option 00:03:00
Conclusion
Conclusion 00:02:00

Course Reviews

5

5
10 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

PRIVATE COURSE ...

Instructors

149 STUDENTS ENROLLED

30 DAYS MONEY BACK Guarantee

Buy For Your team

Get your team access to john’s top 1540+ courses anytime anywhere

try john academy for business

Our Course Awarding Bodies

ACCREDITED BY

 

OUR COURSE PARTNERS

Have you any inquiry?

  • By submitting your information, you agree to the terms and conditions stated in our Privacy Policy

© John Academy.