The Data Preparation Tool is a program I created for The City of Austin.
What does it do?
The Data Preparation Tool is a handy GUI application to help clean up and prepare datasets. It has a lot of common functions that data scientists would use to prepare data.
Current features: Trim Column, Set Null Values, Describe/Info interface, rename columns, delete columns, undo/redo.
Future feature wishlist: Sort function, change column’s data type, import dataset from JSON URL.
Why was it created?
We wanted to design an app that would let even inexperienced users to manipulate datasets and run cleaning routines like removing/replacing null values. The goal was to make many of the steps we use in the data science team accessable to anybody who knows how to open up a CSV or Excel file.