sdc.read: Read plain text reports from SDC Platinum database

Description Usage Arguments Value

Description

It is a convenience function that makes it easier to parse and clean the data from SDC Platinum plain text reports. Several types of reports are supported. However, not everything is yet covered so suggestions, feature requests and issues reports are welcome.

Usage

1
2
3
4
sdc.read(sdc.file.name, sdc.dir = getwd(), data.type = c("jv",
  "Joint Ventures"), report.type = c("csr",
  "Comprehensive Summary Report", "lp", "List of Participants"),
  fields = NA)

Arguments

sdc.file.name

Filename of SDC Platinum plain text report

sdc.dir

Location of SDC Platinum plain text report. Current working directory is assumed by default.

data.type

Type of SDC Platinum database. Only Joint Ventures - "jv" is currently supported. M&A, Venture Experts and so forth could be added in future. Default is "jv"

report.type

Type of plain text report. Two types are currently supported. "csr" - Comprehensive Summary Report and "lp" - List of Participants. Default is "csr".

fields

Which fields to parse from the report. Depends on report type. For the "csr" (Comprehensive Summary Report) following fields are available - "name", "participants", "participants.details", "financial", "deal.type", "date.announced", "date.agreement", "involving", "location", "synopsis", "activity". Default value is NA which means include all fields available. Specifying just a few fields increases speed of parsing.

Value

A data.table where some of the columns are lists of vectors, lists and data.tables. Each row represents separate SDC record.


stasvlasov/sdc.readr documentation built on May 17, 2019, 12:12 a.m.