Movatterモバイル変換

rrefine

Introduction

OpenRefine(formerlyGoogle Refine) is a popular, open source datacleaning software.rrefine enables users toprogrammatically trigger data transfer between R andOpenRefine. Using the functions available in thispackage, you can import, export, apply data cleaning operations, ordelete a project inOpenRefine directly from R. Thereareseveralclient libraries for automatingOpenRefine tasks viaPython, nodeJS and Ruby.rrefine extends thisfunctionality to R users.

Installation

The development version ofrrefine is available onGitHub and can beinstalled viadevtools:

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

rrefine is also available onCRAN:

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

Functions

The package includes the following functionality to interface withOpenRefine 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 allprojects
• refine_project_summary(): Get project summary data
• refine_operations(): Apply arbitrary operations to aproject
• refine_remove_column(): Remove a column from aproject
• refine_add_column(): Add a column to a project
• refine_rename_column(): Rename an existing column in aproject
• refine_move_column(): Move a column to a new index
• refine_transform(): Apply arbitrary texttransformations
• 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 toNULL
• 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 trailingwhitespaces
• refine_collapse_whitespace(): Collapse consecutivewhitespaces to single whitespace
• refine_unescape_html(): Unescape HTML in string

Descriptions and examples of usage are available in the packagemanualandvignette.

Issues

Feature requests, bug reports or other questions should be directedto theissuequeue.