Topic: pandas

Pandas Basics
August 22, 2021

Pandas Basics

Table of Contents Frequency Table using pd.crosstab References What is Pandas Pandas is a library specifically aimed at simplifying the…

EDA - Exploratory Data Analysis
June 28, 2021

EDA - Exploratory Data Analysis

Purpose Companies usually collect a lot of data over time. Once they have enough data, they realize, they can't do much with it. They come…

Data Visualization and EDA
June 20, 2021

Data Visualization and EDA

Purpose Understanding various types of Plots available for analyzing data Prologue Data visualisation is an important skill to possess for…

Standardisation of Data
June 20, 2021

Standardisation of Data

Purpose Whatever data you get will most likely not be in a format that can be processed directly. There will some form of data cleaning…

Operations on Pandas DataFrames
June 16, 2021

Operations on Pandas DataFrames

Merging DataFrames Note: can be set to left / right / inner / outer and it is similar to SQL is the column on which merge can occur…

Reading data from external sources into a DataFrame
June 16, 2021

Reading data from external sources into a DataFrame

Reading from text file Reading from Database Scraping data using bs4 Reading data from PDF files (pyPDF2) Reading from text file Reading…

Treating Missing values in DataFrame
June 16, 2021

Treating Missing values in DataFrame

Identify missing values Note: If there were any rows missing all values, we would simply drop them. Treating missing Values There are…