Data Imputation of Age
Exploratory Data Analysis (EDA) has six main practices. The six main practices of EDA are discovering, structuring, cleaning, […]
replace
Replace Values in Pandas
Are you working with a DataFrame in pandas? Do you need to change or update some values in […]
Data Type Conversion in pandas
Convert Strings to Floats This post discusses one of the EDA Structuring tasks using Python and pandas. Here […]
Cleaning Categories in pandas
You have a dataset in pandas represented as a DataFrame. One of the columns has categories in it. […]
EDA Discovering with Pandas
Exploratory Data Analysis has six phases: discovering, structuring, cleaning, joining, validating and presenting. The first phase is discovery. […]
Replace in R
Do you have some data that you need to replace? In data analysis, you may need to work […]
Excel Recursive Lambda Function
LAMBDA functions in Excel are recursive! This means they can call themselves. One classic example of recursion is […]
Excel Lambda Function
Have you ever used VBA in Excel to create your own functions? LAMBDA allows you to create your […]
Fill and Replace Values
There are times when you need to clean your dataset. Suppose you had a simple table of employees […]
T-SQL Parse a String in a Column
Do you have a column in your SQL Server database that contains a list of things separated by […]