import_coin_tool {COINr} | R Documentation |
Import data directly from COIN Tool
Description
The COIN Tool is an Excel-based tool for building composite indicators. This function provides a direct interface for reading a COIN Tool input deck and converting it to COINr. You need to provide a COIN Tool file, with the "Database" sheet properly compiled.
Usage
import_coin_tool(fname, makecodes = FALSE, oldtool = FALSE, out2 = "list")
Arguments
fname |
The file name and path to read, e.g. |
makecodes |
Logical: if |
oldtool |
Logical: if |
out2 |
Either |
Details
This function replaces the now-defunct COINToolIn()
from COINr < v1.0.
Value
Either a list or a coin, depending on out2
Examples
## Not run:
## This example downloads a COIN Tool spreadsheet containing example data,
## saves it to a temporary directory, unzips, and reads into R. Finally it
## assembles it into a COIN.
# Make temp zip filename in temporary directory
tmpz <- tempfile(fileext = ".zip")
# Download an example COIN Tool file to temporary directory
# NOTE: the download.file() command may need its "method" option set to a
# specific value depending on the platform you run this on. You can also
# choose to download/unzip this file manually.
download.file("https://knowledge4policy.ec.europa.eu/sites/default/
files/coin_tool_v1_lite_exampledata.zip", tmpz)
# Unzip
CTpath <- unzip(tmpz, exdir = tempdir())
# Read COIN Tool into R
l <- import_coin_tool(CTpath, makecodes = TRUE)
## End(Not run)