avatar

Proclus Academy

Machine Learning / Deep Learning

Let's explore different ways of selecting data from a Pandas DataFrame.

First, I'll introduce the two types of DataFrame indexes. Then, I'll show you how to use the methods iloc[] and loc[] to access the DataFrame data.

Summary Image - How to Slice Pandas DataFrames Using iloc and loc
Let me show you how to use the methods idxmin() and idxmax() to get the index of the minimum or maximum value.

These methods provide additional functionality for DataFrames. We'll cover that as well.

Summary Image - Pandas: Why and How to Use idxmin() and idxmax()
This article teaches you how to extract HTML table data from web pages using Pandas and Python.

You'll also learn to handle a typical error you may encounter when scraping web pages.

Summary Image - Parse web pages and read HTML table data using Pandas and Python
Let me show you how to interact with a SQL database using Pandas and Python.

You'll learn to write a DataFrame to a database table and load an entire table or results of a SQL query into a DataFrame.

Summary Image - Pandas: How to Read and Write Data to a SQL Database (MySQL)
Let's explore all the ways you can use Pandas to interact with Excel files.

I'll show you how to read spreadsheets, load selected columns and worksheets, and write DataFrames to Excel files.

Summary Image - Pandas: How to Read and Write Excel Spreadsheets
Here's all you need to know to start using Pandas for data analysis.

You'll learn how to read, manipulate, sort, filter, and visualize datasets using various Pandas methods.

Summary Image - Pandas: A Step by Step Guide for Absolute Beginners
How do you quantify the distance between a typical value and the center of a dataset?

Let's examine the three most common metrics to measure how values are spread out.

Summary Image - Measures of Spread: MAD, Variance, and Standard Deviation
How can you choose one value that summarizes and captures the essence of a given data set?

Let's examine four measures that you can use to represent such a central value.

Summary Image - Measures of Central Tendency: Mean, Median, Weighted Mean, and Mode
Are you ready to embark on your machine learning journey? Let me be your guide.

I’ll share the topics you’ll need to learn, the best available resources, and the order in which to study them.

Summary Image - Master Machine Learning and Deep Learning in 2023
How can you generate samples from a Normal Distribution? How do you calculate probabilities and percentiles?

You'll learn to do all of that using SciPy. I'll also show you how to plot histograms and density curves for normally distributed data.

Summary Image: Normal Distribution