3 posts
✚ Cleaning and Formatting Data, What I Use (The Process #64)

There are many tools to clean up your data, and they can be helpful with the right dataset and situation. I tend to stick to a small handful. Here's what works for me. Read More

0 0
Cleaning your data with Excel and Google Spreadsheets

For Datawrapper, Lisa Charlotte Rost outlines the steps to prepare and clean your data in Excel or Google Spreadsheets. From the beginning: When you download an Excel file, it often has multiple sheets. Our data set has three of them, as seen on the bottom: “Data”, “Metadata – Countries” and “Metadata – Indicators”. Look through all of your sheets and make sure you understand what you’re seeing there. Do the...

0 0
Data cleaning tips

When you're first learning statistics, visualization, or any data-related subject, the data usually is given to you in a ready-to-use format. This is so that you can spend most of your time on the topic of interest. But once you step outside the learning bubble, data rarely comes in the format you want. Marc Bellemare, an associate professor in the Department of Applied Economics at the University of Minnesota, provides...

0 0