The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.

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.

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.