OpenRefine is a powerful point and click web interface for data normalization and preparation. RefinePro offers a hosting option to add extra computing power, collaboration, and batch scheduling. We can help you to integrate OpenRefine in your data flow.
Both OpenRefine and RefinePro platforms include easy to use functionality for:
Extensive Input & Output Support
Cluster & Deduplication
Filter & Sort
Join, Merge & Reconcile
Join and merge different data sets to build new views and insights. Create lookups and reconcile against master data sources. Easily concatenate multiple fields together.
Split a field into multiple columns based on any character(s). Create new rows from multi-value cells.
Undo / Redo
Do your data cleaning in a safe environment where you can undo any changes. Review and audit your transformation history. Once your project is completed you can save your steps to reapply them next time.
Pivot columns into rows or transpose rows into columns with just a few clicks.
Custom Query Language
The General Refine Query Language (GREL) is flexible, powerful, and yet simple enough to create custom filters and transformation expressions. Preview your changes in real time before committing your changes.
Fetch Web Pages & work with APIs
Call web services and fetch web pages from within Refine. Extend your dataset with your favorite API or machine intelligence services with limited coding knowledge.