What are the best tools for cleaning data?

Question

4

Options
Considered

6

User
Recs.

Oct 7, 2022

Last
Updated

Here’s the Deal

4 Options Considered

Best tools for cleaning data	Price	Platforms	Technology
-- OpenRefine	Free	Windows, Linux, Mac	Java
-- Easy Data Transform	Paid	Windows, Mac	-
-- Jupyter	-	-	-
-- Microsoft Excel	-	-	-

See Full List

I Recommend...

Built By the Slant team

Find the best product instantly.

4.7 star rating

Try it now - it's free

score 3 · Answer 1

OpenRefine

Top Pro

Free

RickZeeland's Experience

OpenRefine (formerly Google Refine) is a free and open-source tool for cleaning and transforming messy data. See More

Specs

Platforms:Windows, Linux, Mac

Technology:Java

Top Pro

Offline / Data Privacy

Unlike a number of Google's tools, using this one doesn't mean putting your data in the hands of Google, so there's no worries about using this tool to work with sensitive data. See More

See All

score 1 · Answer 2

Easy Data Transform

Platforms:Windows, Mac

score 1 · Answer 3

Jupyter

Top Pro

pandas

Named for "panel data", pandas is a Python library with tools and data structures for working with tabular data. (Also matrix, statistics, time series, etc.) Jupyter has good support for displaying pandas data frames. See More

Top Pro

matplotlib

Python's math plotting library. It's useful to visualize numeric data in various ways, and Jupyter can display the output inside the notebook. See More

score 1 · Answer 4

Microsoft Excel

Top Pro

PowerQuery plugin for loading data

PowerQuery adds functionality to pull and cleanse data from a variety of sources into your spreadsheet, remembering the source and cleansing workflow steps to allow the data in the sheet to be refreshed should the source data change. http://www.microsoft.com/en-gb/download/details.aspx?id=39379 See More

The Slant team built an AI & it’s awesome

Find the best product instantly

What are the best tools for cleaning data?

4 Options Considered

OpenRefine

My Recommendation for OpenRefine

My Recommendation for OpenRefine

Free

Offline / Data Privacy

Easy Data Transform

My Recommendation for Easy Data Transform

My Recommendation for Easy Data Transform

Jupyter

My Recommendation for Jupyter

My Recommendation for Jupyter

pandas

matplotlib

Microsoft Excel

My Recommendation for Microsoft Excel

My Recommendation for Microsoft Excel

PowerQuery plugin for loading data

Don't see your favorite option? Add it.

One sec!