Data Science Archives - Emma Tsui Portraiture

For one of my projects, I was stuck (and confused) with which combination methods to use to combine my dataframes. Granted that I am not superb at coding, and my brain can be foggy after 8 hours of data cleaning. Hence, I put this quick guide together to remind myself (& hopefully bring newbies some valuable info) on the differences between merge() / .join() / concat() / .append(). So, here we go:

Data Cleaning: Another Fancy Way to call Ourselves Data Janitors

By Emma Tsui

A major part of my first data project was making sure that the messy data that I got was properly cleaned. I had 5 days of time to do this project, and I spent 4 days of cleaning it. They weren’t kidding when they said data scientists spend 60-80% of their time on cleaning and organizing data. That’s why many blog posts (such as this one) called ourselves data janitors.

A Quick Guide for Combining Data in Pandas Using merge(), .join(), concat(), and .append()

Data Cleaning: Another Fancy Way to call Ourselves Data Janitors