OpenRefine
OpenRefine is a free, open source power tool for working with messy data and improving it (by OpenRefine)
CQEngine
Ultra-fast SQL-like queries on Java collections (by npgall)
| OpenRefine | CQEngine | |
|---|---|---|
| 48 | 6 | |
| 11,270 | 1,746 | |
| 1.1% | 1.0% | |
| 9.8 | 0.0 | |
| 4 days ago | over 1 year ago | |
| Java | Java | |
| BSD 3-clause "New" or "Revised" License | Apache License 2.0 |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
OpenRefine
Posts with mentions or reviews of OpenRefine.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2025-04-17.
-
Working on the Open Data Editor at the Open Knowledge Foundation
In April 2024, I was hired to polish the front-end of the Open Data Editor, an open source tool for non-technical data practitioners to explore and detect errors in tables. This app serves mostly as an easier-to-use alternative to Open Refine (with a lot less features, the tradeoff being a much flatter learning curve and more pleasing-to-the-eye interface).
- OpenRefine: For working with, cleaning, transforming messy data
-
Classic Data science pipelines built with LLMs
Are you aware of this tool? https://openrefine.org
-
Ask HN: What Underrated Open Source Project Deserves More Recognition?
"OpenRefine is a powerful free, open source tool for working with messy data: cleaning it; transforming it from one format into another; and extending it with web services and external data." https://openrefine.org/
-
What you need to know about the future of Mozilla Hubs
Yes, let's hope! The strategy has worked out sometimes - Google shut down 'Google Refine' 10 years ago, it got turned into 'Open Refine', last update 2 months ago. https://github.com/OpenRefine/OpenRefine
It's a hugely useful tool if you're working with messy Excel-scale data, i.e., most biologists or social scientists.
-
OpenRefine
It seems to be pure JS with jQuery: https://github.com/OpenRefine/OpenRefine/blob/master/main/we...
-
java string equals returns false, even for identical strings
EDIT: trim() does not remove unicode 0x200b (unicode character for zero width space). https://github.com/OpenRefine/OpenRefine/issues/5105 is worth a read.
-
UIUC MCS - CS 513 Review - Theory and Practice of Data Cleaning
There were six homework assignments. In order they were Regular Expressions, OpenRefine, Datalog, SQL, Provenance, and Python. None of these assignments took more than two to three hours to complete. They all were basic implementation and programming assignments with autograders.
CQEngine
Posts with mentions or reviews of CQEngine.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-05-18.
-
What is the weirdest or most interesting piece of code you ever had to write?
Wrote the code to convert CQEngineCQEngine queries into Solr search queries.
-
Looking for: library to turn SQL (or abstracted) to code & execute against custom backend (slice of structs)
It seems that you're looking for something like https://github.com/npgall/cqengine but unfortunately I'm not aware of any equivalent in Go. LINQ is similar. I'd probably try searching for "LINQ in go" or something like that.
-
Evaluating Range Predicates over Java collections
I wonder if there's a huge difference in efficiency between RoaringBitmap and CQEngine. I used CQEngine a few years back and it turned out really great. Never tried RoaringBitmap, though.
- CQEngine for Java Tutorials/ Guides / Books?
- Ideal Datastructure for Multiple Keys mapping to Multiple Values?
- Early stage draft: Functional transformation of immutable objects
What are some alternatives?
When comparing OpenRefine and CQEngine you can also consider the following projects:
Jimfs - An in-memory file system for Java 7+
Lanterna - Java library for creating text-based GUIs
visidata - A terminal spreadsheet multitool for discovering and arranging data
Modern Java - A Guide to Java 8 - Modern Java - A Guide to Java 8
Smooks - An extensible Java framework for building event-driven applications that break up XML and non-XML data into chunks for data integration
Design Patterns - Design patterns implemented in Java