ORefine - CLI for Working With Open Refine
Makes working with CSVs a bit less painful. Tries to automate some common operations. Contributions welcome, this is a rough cut with the minimal features I needed to get a job done.
You'll need OpenRefine installed & running.
Examples
# output a list of stripped emails from a CSV
orefine a_list_of_emails_and_other_columns.csv --output-columns=email_stripped --stdout
# list of emails common to both csvs
orefine full_list.csv other_set_to_intersect_with.csv --common --output-columns=email --stdout
# merge data from another list & tag
orefine import_list.csv external_list_with_zip_and_state_data.csv --merge=zip,State --add-static-column=source,"LIST-TAG-DATA" --open
# tag a list
orefine import_list.csv --add-static-column=source,AUG-2013-POSTCARD-IMPORT --output-columns=email_stripped,source --stdout > ~/Desktop/list_import.csv
Development Resources
- OpenRefine API
- GRel cross documentation
- Google Refine Gem
- Tutorial on merging datasets with a common column
Contributing
- Fork it
- Create your feature branch (
git checkout -b my-new-feature) - Commit your changes (
git commit -am 'Add some feature') - Push to the branch (
git push origin my-new-feature) - Create new Pull Request
Authors
- Mike Bianco, @iloveitaly