Exploring Data Types in pandas
Exploratory Data Analysis (EDA) has six main practices. The six main practices of EDA are discovering, structuring, cleaning, […]
clean
Data Cleaning Introduction
As a data analyst or data scientist, you want to analyze data that is clean, not dirty. In […]
Cleaning Data for Analysis
Pre-Cleaning Steps Before you clean your data there are three pre-cleaning steps you should take. Data analysts perform […]
SQL Update From Another Table
We want to add a new column to our Orders table and put the product name into that […]
Pivot Table Data Structure
For your Excel pivot tables to be useful and easy to work with, you must first ensure that […]
Clean Code by Bob Martin
“Uncle” Bob Martin has written a book called Clean Code. This post just mentions a few pointers from […]
SQL Server csv in xml out Project Part 6
In this post we will focus on cleaning the incoming data. In our project, the stored procedure that […]