Master Pandas For Data Handling

What you'll learn
Master the Pandas library for advanced Data Handling
The fundamental concepts and language of the Pandas DataFrame object
All aspects of changing, modifying and selecting Data from a Pandas DataFrame
File handling with the Pandas library
Use the .concat(), .join(), and .merge() functions/methods to combine Pandas DataFrame objects
Scale and Standardize data
Advanced Data Preparation with Pandas, including model-based imputation of missing data
Make advanced Data Descriptions with Pandas, including cross-tabulations, groupings, and descriptive statistics
Make Data Visualizations with Pandas, Matplotlib, and Seaborn
Cloud Computing - use Anaconda Cloud Notebook (Jupyter Notebook). Learn to use Cloud Computing resources
Optional: use Anaconda Distribution's Jupyter Notebook and Conda package management system
Requirements
Everyday experience using a computer with Windows, MacOS, Ios, Android, ChromeOS, or Linux is recommended
Basic Python knowledge is recommended
Access to a computer with an internet connection
The course only uses costless software
Walk-you-through installation and setup videos for Windows 10/11 is included
Description
This video course will teach you to master Pandas, the most powerful, efficient, and useful Data Handling library in existence. You will learn to master the Pandas library and to use powerful Data Handling techniques with the intention of making you able to use the powerful Pandas library for Data Science and Machine Learning Data Handling tasks.With the Pandas library you get a fast, powerful, flexible and easy to use, open-source data analysis and data manipulation tool, directly usable with the Python programming language and able to use any data source with the incredibly powerful Pandas DataFrame object.This video course is updated to Pandas 2 and the announced upcoming Pandas 3 version.You will learn:Master the Pandas library for advanced Data HandlingThe fundamental concepts and language of the Pandas DataFrame objectAll aspects of changing, modifying and selecting Data from a Pandas DataFrameFile handling with the Pandas libraryUse the .concat(), .join(), and .merge() functions/methods to combine Pandas DataFrame objectsScale and Standardize dataAdvanced Data Preparation with Pandas, including model-based imputation of missing dataMake advanced Data Descriptions with Pandas, including cross-tabulations, groupings, and descriptive statisticsMake Data Visualizations with Pandas, Matplotlib, and SeabornCloud Computing: To use the web browser-based Anaconda Cloud Notebook (Cloud-based Jupyter Notebook). Learn to use Cloud Computing resources in this course.Option: To use the Anaconda Distribution (Windows, Mac, Linux, and more)Option: Python environment fundamentals with the Conda package management system and command line installing/updating of libraries and packages - golden nuggets to improve your quality of work life.And much more.This course is an excellent way to learn to Master Pandas and Data Handling! Data Handling is the process of making data useful and usable for data analysis. Most Data Scientists and Machine Learners spends about 80% of their working efforts and time on Data Handling tasks. Being good at Data Handling and Pandas is extremely useful and time-saving skills that functions as a force multiplier for productivity.This course is designed for anyone who wants toAnyone who knows the basics of Python programming and want to learn the Pandas library!Anyone who is a new student at the University level and want to learn Data Handling skills that they will have use for in their entire data science, engineering or academic careers!Anyone who knows Python and wants to extend your knowledge of the Pandas library and Data Handling!Anyone who knows about Data Science or Machine Learning and want to learn Data Handling skills that work as a force multiplier with the skills you already know!Anyone who wants to learn advanced Data Handling and improve their capabilities and productivityRequirements:Everyday experience using a computer with Windows, MacOS, iOS, Android, ChromeOS, or Linux is recommendedBasic Python knowledge is recommendedAccess to a computer with an internet connectionThe course only uses costless softwareWalk-you-through installation and setup videos for Windows 10/11 is includedThis course is the course we ourselves would want to be able to enroll in if we could time-travel and become new students. In our opinion, this course is the best course to learn to Master Pandas and Data Handling.Enroll now to receive 12+ hours of detailed video tutorials with manually edited English captions, and a certificate of completion after completing the course!
Overview
Section 1: Introduction
Lecture 1 Introduction to Master Pandas for Data Handling
Lecture 2 Setup of the Anaconda Cloud Notebook
Lecture 3 Download and installation of the Anaconda Distribution (optional)
Lecture 4 The Conda Package Management System (optional)
Section 2: Master Pandas for Data Handling
Lecture 5 Master Pandas for Data Handling: Overview
Lecture 6 Pandas theory and terminology
Lecture 7 Creating a DataFrame from scratch
Lecture 8 Pandas File Handling: Overview
Lecture 9 Pandas File Handling: The .csv file format
Lecture 10 Pandas File Handling: The .xlsx file format
Lecture 11 Pandas File Handling: SQL-database files and Pandas DataFrame
Lecture 12 Pandas Operations & Techniques: Overview
Lecture 13 Pandas Operations & Techniques: Object Inspection
Lecture 14 Pandas Operations & Techniques: DataFrame Inspection
Lecture 15 Pandas Operations & Techniques: Column Selections
Lecture 16 Pandas Operations & Techniques: Row Selections
Lecture 17 Pandas Operations & Techniques: Conditional Selections
Lecture 18 Pandas Operations & Techniques: Scalers and Standardization
Lecture 19 Pandas Operations & Techniques: Concatenate DataFrames
Lecture 20 Pandas Operations & Techniques: Joining DataFrames
Lecture 21 Pandas Operations & Techniques: Merging DataFrames
Lecture 22 Pandas Data Preparation I: Overview & workflow
Lecture 23 Pandas Data Preparation II: Edit DataFrame labels
Lecture 24 Pandas Data Preparation III: Duplicates
Lecture 25 Pandas Data Preparation IV: Missing Data & Imputation
Lecture 26 Pandas Data Description I: Overview
Lecture 27 Pandas Data Description II: Sorting and Ranking
Lecture 28 Pandas Data Description III: Descriptive Statistics
Lecture 29 Pandas Data Description IV: Crosstabulations & Groupings
Lecture 30 Pandas Data Visualization I: Overview
Lecture 31 Pandas Data Visualization II: Histograms
Lecture 32 Pandas Data Visualization III: Boxplots
Lecture 33 Pandas Data Visualization IV: Scatterplots
Lecture 34 Pandas Data Visualization V: Pie Charts
Lecture 35 Pandas Data Visualization VI: Line plots
Anyone who knows the basics of Python programming and want to learn the Pandas library,Anyone who is a new student at the University level and want to learn Data Handling skills that they will have use for in their entire data science, engineering or academic careers,Anyone who knows Python and wants to extend your knowledge of the Pandas library and Data Handling,Anyone who knows about Data Science or Machine Learning and want to learn Data Handling skills that work as a force multiplier with the skills you already know,Anyone who wants to learn advanced Data Handling and improve their capabilities and productivity
Homepage