Skip to content

vpnagraj/rrefine

main
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
R
 
 
 
 
 
 
 
 
man
 
 
 
 
 
 
 
 
 
 
 
 
 
 

rrefine

CRAN Status

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.

About

R package for OpenRefine API

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages