rrefine

Introduction

OpenRefine (formerly Google Refine) is a popular, open source data cleaning software. rrefine enables users to programmatically trigger data transfer between R and OpenRefine. Using the functions available in this package, you can import, export, apply data cleaning operations, or delete a project in OpenRefine directly from R. There are several client libraries for automating OpenRefine tasks via Python, nodeJS and Ruby. rrefine extends this functionality to R users.

Installation

The development version of rrefine is available on GitHub and can be installed via devtools:

# install.packages("devtools")
devtools::install_github("vpnagraj/rrefine")
library(rrefine)

rrefine is also available on CRAN:

install.packages("rrefine")
library(rrefine)

Functions

The package includes the following functionality to interface with OpenRefine projects:

• refine_upload(): Upload data to a project
• refine_export(): Export data from a project
• refine_delete(): Delete a project
• refine_metadata(): Retrieve metadata from all projects
• refine_project_summary(): Get project summary data
• refine_operations(): Apply arbitrary operations to a project
• refine_remove_column(): Remove a column from a project
• refine_add_column(): Add a column to a project
• refine_rename_column(): Rename an existing column in a project
• refine_move_column(): Move a column to a new index
• refine_transform(): Apply arbitrary text transformations
• refine_to_lower(): Coerce text to lowercase
• refine_to_upper(): Coerce text to uppercase
• refine_to_title(): Coerce text to title case
• refine_to_null(): Set values to NULL
• refine_to_empty(): Set text values to empty string ("")
• refine_to_text(): Coerce value to string
• refine_to_number(): Coerce value to numeric
• refine_to_date(): Coerce value to date
• refine_trim_whitespace(): Remove leading and trailing whitespaces
• refine_collapse_whitespace(): Collapse consecutive whitespaces to single whitespace
• refine_unescape_html(): Unescape HTML in string

Descriptions and examples of usage are available in the package manual and vignette.

Issues

Feature requests, bug reports or other questions should be directed to the issue queue.