OpenRefine August 2021 Review

We wish you a happy September! This month, we decided to share the most relevant and helpful OpenRefine August 2021 community announcements, releases, tutorials, videos, and academic publications with you.

Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!

Read More

OpenRefine July 2021 Review

Happy August! This month, we decided to share the most relevant and helpful OpenRefine July 2021 community announcements, releases, tutorials, videos, and academic publications with you.

Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!

Read More

OpenRefine June 2021 Review

Happy July! This month, we decided to share the most relevant and helpful OpenRefine June 2021 videos, tutorials, and releases with you.

Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!

Read More

OpenRefine May 2021 Review

Happy June! This month, we decided to share the most relevant and helpful OpenRefine May videos, tutorials, and releases with you.

Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!

Read More

using columnName to bulk fill down columns

Thanks to this StackOverflow question, I finally found a great use case to introduce the columnName variable in OpenRefine. 

The columnName variable has been poorly documented (see previous discussions in SO and on the OpenRefine mailing list). The feature got really interesting with the All > Transform option available in OpenRefine 2.7 back in 2017 (yes, this blog post is long overdue!)

Read More

OpenRefine April 2021 Review

For April we took the time to review all your favourite OpenRefine extensions for updates and checked for new ones! 

Do not forget to subscribe to our newsletter to get our monthly update right in your mailbox.

Read More

Edit value from the facet

 

I just can't believe we have not yet published a tutorial for this essential OpenRefine feature! 

When you select the edit option from the facet menu, you can edit all matching values in a column, similar to a search and replace function. Of course, the update is recorded in OpenRefine history and can be replicated on a similar dataset.

You can use the edit using facet to quickly clean up typos or misspelled cells. It is also useful to address duplicates that are either not detected by the clustering feature or caught in larger clusters with irrelevant matches. 

In this video example below, we replace the value US  to United States for 45 cells in one shot.

Read More