Data Analysis with Pandas and Python

Analyze data quickly and easily with Python's powerful pandas library! All datasets included --- beginners welcome!

4.64 (21799 reviews)
Udemy
platform
English
language
Data Science
category
instructor
Data Analysis with Pandas and Python
196,395
students
19.5 hours
content
Nov 2023
last update
$109.99
regular price

What you will learn

Perform a multitude of data operations in Python's popular pandas library including grouping, pivoting, joining and more!

Learn hundreds of methods and attributes across numerous pandas objects

Possess a strong understanding of manipulating 1D, 2D, and 3D data sets

Resolve common issues in broken or incomplete data sets

Why take this course?

Student Testimonials:

  • The instructor knows the material, and has detailed explanation on every topic he discusses. Has clarity too, and warns students of potential pitfalls. He has a very logical explanation, and it is easy to follow him. I highly recommend this class, and would look into taking a new class from him. - Diana

  • This is excellent, and I cannot complement the instructor enough. Extremely clear, relevant, and high quality - with helpful practical tips and advice. Would recommend this to anyone wanting to learn pandas. Lessons are well constructed. I'm actually surprised at how well done this is. I don't give many 5 stars, but this has earned it so far. - Michael

  • This course is very thorough, clear, and well thought out. This is the best Udemy course I have taken thus far. (This is my third course.) The instruction is excellent! - James


Welcome to the most comprehensive Pandas course available on Udemy! An excellent choice for both beginners and experts looking to expand their knowledge on one of the most popular Python libraries in the world!

Data Analysis with Pandas and Python offers 19+ hours of in-depth video tutorials on the most powerful data analysis toolkit available today. Lessons include:

  • installing

  • sorting

  • filtering

  • grouping

  • aggregating

  • de-duplicating

  • pivoting

  • munging

  • deleting

  • merging

  • visualizing

and more!

Why learn pandas?

If you've spent time in a spreadsheet software like Microsoft Excel, Apple Numbers, or Google Sheets and are eager to take your data analysis skills to the next level, this course is for you! 


Data Analysis with Pandas and Python introduces you to the popular Pandas library built on top of the Python programming language. 

Pandas is a powerhouse tool that allows you to do anything and everything with colossal data sets -- analyzing, organizing, sorting, filtering, pivoting, aggregating, munging, cleaning, calculating, and more! 

I call it "Excel on steroids"!

Over the course of more than 19 hours, I'll take you step-by-step through Pandas, from installation to visualization! We'll cover hundreds of different methods, attributes, features, and functionalities packed away inside this awesome library. We'll dive into tons of different datasets, short and long, broken and pristine, to demonstrate the incredible versatility and efficiency of this package.

Data Analysis with Pandas and Python is bundled with dozens of datasets for you to use. Dive right in and follow along with my lessons to see how easy it is to get started with pandas!

Whether you're a new data analyst or have spent years (*cough* too long *cough*) in Excel, Data Analysis with pandas and Python offers you an incredible introduction to one of the most powerful data toolkits available today!

Content

Installation and Setup

Introduction to the Course
About Me
Completed Course Files
MacOS - Download the Anaconda Distribution
MacOS - Install Anaconda Distribution
MacOS - Access the Terminal
MacOS - Create Conda Environment and Install Pandas
MacOS - Unpack Course Materials + The Start and Shutdown Process
Windows - Download the Anaconda Distribution
Windows - Install Anaconda Distribution
Windows - Access the Command Prompt and Update Anaconda Libraries
Windows - Unpack Course Materials + The Startdown and Shutdown Process
Intro to the Jupyter Notebook Interface
Cell Types and Cell Modes
Code Cell Execution
Popular Keyboard Shortcuts
Import Libraries into Jupyter Notebook
Python Crash Course, Part 1 - Data Types and Variables
Python Crash Course, Part 2 - Lists
Python Crash Course, Part 3 - Dictionaries
Python Crash Course, Part 4 - Operators
Python Crash Course, Part 5 - Functions

Series

Create Jupyter Notebook for the Series Module
Create A Series Object from a Python List
Create A Series Object from a Python Dictionary
Intro to Attributes
Intro to Methods
Parameters and Arguments
Import Series with the .read_csv() Method
The .head() and .tail() Methods
Python Built-In Functions
More Series Attributes
The .sort_values() Method
The inplace Parameter
The .sort_index() Method
Python's in Keyword
Extract Series Values by Index Position
Extract Series Values by Index Label
The .get() Method on a Series
Math Methods on Series Objects
The .idxmax() and .idxmin() Methods
The .value_counts() Method
The .apply() Method
The .map() Method
A Review of the Series Module

DataFrames I

Intro to DataFrames I Module
Shared Methods and Attributes between Series and DataFrames
Differences between Shared Methods
Select One Column from a DataFrame
Select Two or More Columns from a DataFrame
Add New Column to DataFrame
Broadcasting Operations
A Review of the .value_counts() Method
Drop Rows with Null Values
Fill in Null Values with the .fillna() Method
The .astype() Method
Sort a DataFrame with the .sort_values() Method, Part I
Sort a DataFrame with the .sort_values() Method, Part II
Sort DataFrame with the .sort_index() Method
Rank Values with the .rank() Method

DataFrames II

This Module's Dataset + Memory Optimization
Filter a DataFrame Based on A Condition
Filter with More than One Condition (AND - &)
Filter with More than One Condition (OR - |)
The .isin() Method
The .isnull() and .notnull() Methods
The .between() Method
The .duplicated() Method
The .drop_duplicates() Method
The .unique() and .nunique() Methods

DataFrames III

Intro to the DataFrames III Module + Import Dataset
The .set_index() and .reset_index() Methods
Retrieve Rows by Index Label with .loc[]
Retrieve Rows by Index Position with .iloc[]
The Catch-All .ix[] Method
Second Arguments to .loc[], .iloc[], and .ix[] Methods
Set New Values for a Specific Cell or Row
Set Multiple Values in DataFrame
Rename Index Labels or Columns in a DataFrame
Delete Rows or Columns from a DataFrame
Create Random Sample with the .sample() Method
The .nsmallest() and .nlargest() Methods
Filtering with the .where() Method
The .query() Method
A Review of the .apply() Method on Single Columns
The .apply() Method with Row Values
The .copy() Method

Working with Text Data

Intro to the Working with Text Data Module
Common String Methods - lower, upper, title, and len
The .str.replace() Method
Filtering with String Methods
More String Methods - strip, lstrip, and rstrip
String Methods on Index and Columns
Split Strings by Characters with .str.split() Method
More Practice with Splits
The expand and n Parameters of the .str.split() Method

MultiIndex

Intro to the MultiIndex Module
Create a MultiIndex with the set_index() Method
The .get_level_values() Method
The .set_names() Method
The sort_index() Method
Extract Rows from a MultiIndex DataFrame
The .transpose() Method and MultiIndex on Column Level
The .swaplevel() Method
The .stack() Method
The .unstack() Method, Part 1
The .unstack() Method, Part 2
The .unstack() Method, Part 3
The .pivot() Method
The .pivot_table() Method
The pd.melt() Method

GroupBy

Intro to the Groupby Module
First Operations with groupby Object
Retrieve A Group with the .get_group() Method
Methods on the Groupby Object and DataFrame Columns
Grouping by Multiple Columns
The .agg() Method
Iterating through Groups

Merging, Joining, and Concatenating

Intro to the Merging, Joining, and Concatenating Module
The pd.concat() Method, Part 1
The pd.concat() Method, Part 2
The .append() Method on a DataFrame
Inner Joins, Part 1
Inner Joins, Part 2
Outer Joins
Left Joins
The left_on and right_on Parameters
Merging by Indexes with the left_index and right_index Parameters
The .join() Method
The pd.merge() Method

Working with Dates and Times

Intro to the Working with Dates and Times Module
Review of Python's datetime Module
The pandas Timestamp Object
The pandas DateTimeIndex Object
The pd.to_datetime() Method
Create Range of Dates with the pd.date_range() Method, Part 1
Create Range of Dates with the pd.date_range() Method, Part 2
Create Range of Dates with the pd.date_range() Method, Part 3
The .dt Accessor
Install pandas-datareader Library
Import Financial Data Set with pandas_datareader Library
Selecting Rows from a DataFrame with a DateTimeIndex
Timestamp Object Attributes
The .truncate() Method
pd.DateOffset Objects
More Fun with pd.DateOffset Objects
The pandas Timedelta Object
Timedeltas in a Dataset

Panels

DEPRECATION WARNING
Intro to the Module + Fetch Panel Dataset from Google Finance
The Axes of a Panel Object
Panel Attributes
Use Bracket Notation to Extract a DataFrame from a Panel
Extracting with the .loc, .iloc, and .ix Methods
Convert Panel to a MultiIndex DataFrame (and Vice Versa)
The .major_xs() Method
The .minor_xs() Method
Transpose a Panel with the .transpose() Method
The .swapaxes() Method
A Review of the Panels Module

Input and Output

Intro to the Input and Output Module
Feed pd.read_csv() Method a URL Argument
Quick Object Conversions
Export DataFrame to CSV File with the .to_csv() Method
Install xlrd and openpyxl Libraries to Read and Write Excel Files
Import Excel File into pandas
Export Excel File
Input and Output

Visualization

Intro to Visualization Module
The .plot() Method
Modifying Aesthetics with Templates
Bar Graphs
Pie Charts
Histograms
Visualization

Options and Settings

Introduction to the Options and Settings Module
Changing pandas Options with Attributes and Dot Syntax
Changing pandas Options with Methods
The precision Option

Conclusion

Conclusion

Screenshots

Data Analysis with Pandas and Python - Screenshot_01Data Analysis with Pandas and Python - Screenshot_02Data Analysis with Pandas and Python - Screenshot_03Data Analysis with Pandas and Python - Screenshot_04

Our review

🌟 **Course Overview** 🌟 The online course titled "[Your Course Title]" has received a global rating of *4.64*, with all recent reviews being positive. Below is a synthesis of the key points and recurring themes from the student feedback, structured for clarity and ease of reading. ### Pros: - **Comprehensive Learning:** The course is praised for its thorough approach to teaching Pandas, covering every detailed topic with clear explanations. It's suitable for individuals with a basic knowledge of Python and data analysis. - **Practical Application:** Students appreciate the hands-on approach, using notebooks alongside video tutorials, which allows for immediate application and experimentation. The practical exercises provided are considered great reinforcement of the mini-lectures. - **Detailed Explanations:** The course is commended for its detailed explanations and examples that aid in understanding complex concepts. These explanations make it a refreshing experience for those looking to enhance their Pandas skills, as well as for beginners. - **Multilingual Support:** The course material, especially the video content, is accessible with subtitles in Spanish, which is a significant plus for non-English speakers. - **Clear Instruction:** The instructor's method of explanation is highlighted as clear and concise, making it easy for students to follow along. The structured approach to teaching is appreciated. - **Student Engagement:** Students feel engaged and supported throughout the course, with many expressing gratitude towards the instructor for providing a comfortable learning experience. ### Cons: - **Pacing:** Some students find the beginning of the course to be a bit slow, suggesting that it could be made more engaging or presented at a quicker pace to maintain interest. - **Exercise Quantity:** A few students recommend including more exercises and tasks throughout the course to provide ample opportunity for practice and to check progress. - **Outdated Content:** A notable concern is the presence of outdated content, with some Python & Anaconda features being depreciated but not updated in the course material. This could potentially lead to confusion or frustration for students following the course. - **Need for Structured Notes/Guides:** There is a suggestion for the provision of structured notes or study guides that summarize content in an easily understandable manner, which would serve as a quick reference for learners. - **Project Implementation:** Some students believe that a project encompassing all aspects of Pandas syntax, from data collection to visualization, would enhance understanding and application of the concepts taught. - **Technical Updates:** There is a call for regular updates to the course content to ensure that the instructions provided are current and accurate. ### Additional Recommendations: - **Speed Option:** Some students suggest that an option to speed up the video playback would make the learning process more efficient, particularly for students who prefer faster-paced instructional content. - **Improved Structure and Rationale:** A request for explanations regarding why certain structures are used in syntax and a deeper understanding of installed systems and their functions could further improve the course. ### Conclusion: Overall, the course "Your Course Title" is highly regarded for its comprehensive coverage of Pandas and its engaging teaching methods. While there are some areas where improvements could be made, such as updating content, adding more exercises, and potentially speeding up certain parts of the instruction, the course remains a valuable resource for those looking to enhance their data analysis skills using Python and Pandas. With clear instruction, multilingual support, and practical application opportunities, this course is certainly recommended for its effectiveness in teaching Pandas.

Coupons

DateDiscountStatus
5/29/202150% OFF
expired
4/21/202250% OFF
expired
4/28/202250% OFF
expired
5/13/202250% OFF
expired
5/26/202250% OFF
expired
6/9/202250% OFF
expired
6/23/202250% OFF
expired
7/8/202250% OFF
expired
7/22/202250% OFF
expired
9/12/202250% OFF
expired
12/19/202250% OFF
expired
12/29/202250% OFF
expired
1/6/202350% OFF
expired
4/6/202389% OFF
expired

Charts

Price

Data Analysis with Pandas and Python - Price chart

Rating

Data Analysis with Pandas and Python - Ratings chart

Enrollment distribution

Data Analysis with Pandas and Python - Distribution chart
932344
udemy ID
8/16/2016
course created date
6/13/2019
course indexed date
Bot
course submited by