Data cleaning, Exploratory Data Analysis and Visualization using Pandas, Numpy, Matplotlib and Seaborn. — Index Of Contents ∘ Introduction ∘ What is Machine learning? ∘ Project Outline ∘ Install and Import required libraries ∘ Download Data from Kaggle ∘ Getting Basic information About Data ∘ Dropping the columns which are not necessary for analysis and building…

Data Analysis, Visualization using Matplotlib and Seaborn — Answering interesting questions related to data — Index Of Contents · Introduction · What is Exploratory Data Analysis · Project Outline · Exploratory Analysis and Visualization ∘ Loan Defaulter Analysis based on following columns ∘ Home Ownerships ∘ Loan Purpose ∘ Grade ∘ Home Ownerships & Loan Purpose ∘ Grade & Loan Purpose ∘…

Data preprocessing and cleaning the dataset using Pandas — Getting ready to analyze data! — Index Of Contents · What is Exploratory Data Analysis · Project Outline · Download and read the dataset · Data Preprocessing & Cleaning ∘ Data Cleansing: DataType changes and fixing column values · Summary statistics of relevant columns and filling the missing values ∘ Column: revol_util ∘ Column: pub_rec_bankruptcies ∘ Column…

Using Python’s Requests, Beautiful Soup, and Pandas — Table Of Contents ∘ What is Web Scraping? ∘ How does web scraping work? …

How do I select a subset of a DataFrame? — Index Of Contents · Introduction · Method 1: Boolean Mask · Method 2: loc · Method 3 : Query · Method 4: iloc · Conclusion Introduction In this post, we will discuss various methods to filter Pandas' data frame in Python. Data Filtering is one of the most frequent and sort…

Various Pandas methods which accept regex expressions — Index Of Contents · Introduction · Data Frame creation · Method # 1: extract() · Method # 2: count() · Method # 3: match() · Method # 4: findall() · Method # 5: contains() · Conclusion Introduction There are several methods in Pandas that accepts regex expressions which is in line…

Looking for efficient way to combine several text files? — Index Of Contents · Introduction · What is glob · Manual method · Effective method · Conclusion Introduction There are several occasions in real time where you may need to merge multiple text files into single text file before starting with your analysis You may have many log/text files from one…

How to apply Lambda functions in data frames — Index Of Contents · Introduction · What is Lambda Function · Applied to Single Column · Multiple Columns · Single Row Using · Filtering Data by Applying Lambda Function · Use of map() function · Bonus: if-else Statement · Conclusion Introduction The lambda function solves many data science problems in Pandas…

Merge using Inner, Outer, Left, and Right joins — Index Of Contents · Introduction · Why merge or join? · Merging DataFrames ∘ Simple merging ∘ Merging with non-unique column · Four Types of Joins ∘ Inner join ∘ Outer join ∘ Left join ∘ Right join · Conclusion Introduction Pandas provide a single function, merge, as the entry point…