Ask HN: What online tool do you use for data cleaning?
Been looking for an online tool that's easy to use for tabular data cleaning such as date parsing and formatting, column split, etc. Couldn't find anything so I created Data Janitor (https://www.csvjson.com/datajanitor) to scratch my own itch.
Wondering what people out there use. I prefer an online tool - don't want to install anything. Also a point tool - don't want to have to sign up.
3 comments
[ 1.6 ms ] story [ 13.8 ms ] threadUse a title like "Show HN: Data Janitor - Online spreadsheet cleaning and transformation"
(Wait for resubmitting until Dec26. Nobody reads HN during Christmas.)
Some questions/remarks:
- It's not 100% clear that you must click in Clean & Transform to edit the transformation script
- If you edit the process script but don't click on "Run", then nothing happens (obviously). Perhaps you can add a small warning in the main page "Outdated results. Please click "Run" to process your data with the new script"
- Does the process happen in the browser or in your server? How private is the data I upload? (I'm pessimistic and assume not private at all.)
- How long do you keep the saver versions? Are you doing some filtering to prevent spam/overuse/ilegal content?
(Once your site is big enough to get some spam/abuse/ilegal content, you can write a nice post about how you combat it.)