
Master data analysis using NumPy and Pandas by loading data from different sources, manipulating and slicing Series and DataFrames, and applying fundamental data structures and functions.
Learn numpy basics for data analysis: create and reshape arrays, understand shape and dtype, and index and slice. Load data from csv and excel formats and perform mathematical operations.
Explore numpy arrays, reshape data to desired dimensions, create empty or zero-filled arrays, and apply indexing, slicing, and range-based selection to build 1D and 2D arrays.
Learn indexing and slicing in data analysis with NumPy and Pandas, using start, end, and step to select specific positions, including negative indices, in one- and two-dimensional arrays.
Explore indexing and slicing in NumPy arrays, including 1D and 2D shapes, start end step patterns, and selecting rows and columns, with basic statistics like min, max, mean, and median.
Learn to compute key statistics and perform random number operations using numpy-like tools, including min, max, mean, median, variance, standard deviation, and basic linear algebra concepts.
Explore the NumPy and pandas libraries to create and manipulate series and data frames, learn indexing, reshaping, and handling missing data for efficient data analysis.
Learn to create date ranges in data frames using frequency and date format, inspect data with head and info, and handle missing values, drop rows or columns, and compute correlation.
Explore indexing and slicing in pandas dataframes and series, compare two-dimensional data frames with one-dimensional series, and use describe, info, and shape to summarize columns, rows, and missing values.
Learn how to use pandas loc and iloc to select data by label or position, using single, multiple, and sliced columns with positive or negative steps.
Explore indexing and slicing a DataFrame with start, end, and step values, including negative indices, to select specific rows and columns efficiently.
Explore descriptive statistics with pandas describe on numeric and object columns, and master data concatenation, merging, dropping duplicates, and sorting to clean and combine data frames.
learn how to merge two data frames using a common column with the merge function, specify on, and handle column names and indexing to align data for analysis.
Learn to merge dataframes with inner, left, right, and outer joins using common columns, and clean text data by lowercasing, normalizing, and replacing patterns in strings.
Learn how to load data with Python by setting the working directory, using read_csv with skiprows, header, and sep, and adjusting dtype to create clean dataframes.
Load data from csv, excel, and url sources using pandas (pd.read_csv, pd.read_excel), select specific columns, manage whitespace and rows to produce clean datasets ready for analysis.
Explore data visualization with pandas by analyzing a used cars dataset, using box plots and scatter plots to reveal mean, median, distribution, and skewness.
Data science blends statistics, data analysis, machine learning, and artificial intelligence to understand and analyze data, handling structured, unstructured, and semi-structured data through a cyclical process.
Understand what machine learning is, how it differs from traditional programming, and the roles of data science and statistics. Explore supervised and reinforcement learning and data-driven models.
Learn to prepare data, stop the bleed on data, and analyze to understand datasets for informed decisions using NumPy and Pandas.
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!
1. NumPy Introduction
2. Python Numpy Array
3. Indexing & Slicing - 1
4. Indexing & Slicing - 2
5. Statistical Functions, Operators & Random Numbers
6. Introduction Series & DataFrame
7. Date Range & Inspecting Data
8. Indexing & Slicing on DataFrame - 1
9. loc & iloc
10. Indexing & Slicing on DataFrame - 2
11. Concatenation & Descriptive Statistics
12. Merging DataFrames
13. Working with Text Data
14. Function Application & Loading data in Python
15. Loading Data from CSV, Excel & URL
16. Data Visualization using Pandas
17. What is Data Science
18. What is Machine Learning