tests/testthat/_snaps/match_name.md

with loanbook_demo and abcd_demo outputs expected value

{
  "type": "list",
  "attributes": {
    "names": {
      "type": "character",
      "attributes": {},
      "value": ["id_direct_loantaker", "name_direct_loantaker", "id_intermediate_parent_1", "name_intermediate_parent_1", "id_ultimate_parent", "name_ultimate_parent", "loan_size_outstanding", "loan_size_outstanding_currency", "loan_size_credit_limit", "loan_size_credit_limit_currency", "sector_classification_system", "sector_classification_input_type", "sector_classification_direct_loantaker", "fi_type", "flag_project_finance_loan", "name_project", "lei_direct_loantaker", "isin_direct_loantaker", "id_loan", "id_2dii", "level", "sector", "sector_abcd", "name", "name_abcd", "score", "source", "borderline"]
    },
    "row.names": {
      "type": "integer",
      "attributes": {},
      "value": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26]
    },
    "class": {
      "type": "character",
      "attributes": {},
      "value": ["tbl_df", "tbl", "data.frame"]
    }
  },
  "value": [
    {
      "type": "character",
      "attributes": {},
      "value": ["C26", "C26", "C1", "C1", "C35", "C35", "C5", "C5", "C30", "C30", "C3", "C3", "C23", "C23", "C33", "C33", "C31", "C31", "C32", "C32", "C34", "C34", "C25", "C25", "C20", "C20"]
    },
    {
      "type": "character",
      "attributes": {},
      "value": ["large oil and gas company four", "large oil and gas company four", "large automotive company five", "large automotive company five", "large steel company five", "large steel company five", "large automotive company two", "large automotive company two", "large power company five", "large power company five", "large automotive company one", "large automotive company one", "large hdv company three", "large hdv company three", "large power company three", "large power company three", "large power company four", "large power company four", "large power company one", "large power company one", "large power company two", "large power company two", "large oil and gas company five", "large oil and gas company five", "large coal company two", "large coal company two"]
    },
    {
      "type": "character",
      "attributes": {},
      "value": [null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]
    },
    {
      "type": "character",
      "attributes": {},
      "value": [null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]
    },
    {
      "type": "character",
      "attributes": {},
      "value": ["UP26", "UP26", "UP1", "UP1", "UP35", "UP35", "UP5", "UP5", "UP30", "UP30", "UP3", "UP3", "UP23", "UP23", "UP33", "UP33", "UP31", "UP31", "UP32", "UP32", "UP34", "UP34", "UP25", "UP25", "UP20", "UP20"]
    },
    {
      "type": "character",
      "attributes": {},
      "value": ["large oil and gas company four", "large oil and gas company four", "large automotive company five", "large automotive company five", "large steel company five", "large steel company five", "large automotive company two", "large automotive company two", "large power company five", "large power company five", "large automotive company one", "large automotive company one", "large hdv company three", "large hdv company three", "large power company three", "large power company three", "large power company four", "large power company four", "large power company one", "large power company one", "large power company two", "large power company two", "large oil and gas company five", "large oil and gas company five", "large coal company two", "large coal company two"]
    },
    {
      "type": "double",
      "attributes": {},
      "value": [1774620, 1774620, 10969854, 10969854, 2222371, 2222371, 18585364, 18585364, 16733244, 16733244, 3867595, 3867595, 12466411, 12466411, 2776135, 2776135, 3084865, 3084865, 8866025, 8866025, 5822351, 5822351, 11132126, 11132126, 1699037, 1699037]
    },
    {
      "type": "character",
      "attributes": {},
      "value": ["USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD"]
    },
    {
      "type": "double",
      "attributes": {},
      "value": [8873102, 8873102, 54849271, 54849271, 11111857, 11111857, 92926822, 92926822, 83666218, 83666218, 19337977, 19337977, 62332057, 62332057, 13880676, 13880676, 15424324, 15424324, 44330124, 44330124, 29111756, 29111756, 55660632, 55660632, 8495184, 8495184]
    },
    {
      "type": "character",
      "attributes": {},
      "value": ["USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD", "USD"]
    },
    {
      "type": "character",
      "attributes": {},
      "value": ["NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE", "NACE"]
    },
    {
      "type": "character",
      "attributes": {},
      "value": ["Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code", "Code"]
    },
    {
      "type": "double",
      "attributes": {},
      "value": [6100, 6100, 2910, 2910, 2410, 2410, 2910, 2910, 3511, 3511, 2910, 2910, 2910, 2910, 3511, 3511, 3511, 3511, 3511, 3511, 3511, 3511, 6100, 6100, 5100, 5100]
    },
    {
      "type": "character",
      "attributes": {},
      "value": ["Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan", "Loan"]
    },
    {
      "type": "character",
      "attributes": {},
      "value": ["No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No"]
    },
    {
      "type": "character",
      "attributes": {},
      "value": [null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]
    },
    {
      "type": "character",
      "attributes": {},
      "value": ["728600LZB5IPAF5CM278", "728600LZB5IPAF5CM278", "836000XMDHWKK968EK48", "836000XMDHWKK968EK48", "9570006ADHXV8OQKID45", "9570006ADHXV8OQKID45", "188800KT6I2BFPQ8LR94", "188800KT6I2BFPQ8LR94", "919900S32VPGBYW4O001", "919900S32VPGBYW4O001", "496300U7J971S488HF87", "496300U7J971S488HF87", "727800XGKGZ55ULC9O56", "727800XGKGZ55ULC9O56", "975800RSVLV132XEKG26", "975800RSVLV132XEKG26", "079600Q8AWSJ1GDC4519", "079600Q8AWSJ1GDC4519", "538800WQ5BY8O5EB5Y74", "538800WQ5BY8O5EB5Y74", "0891007LZSAFY2JWQQ06", "0891007LZSAFY2JWQQ06", "6780007PFZ072NXOAS42", "6780007PFZ072NXOAS42", "571800XST2D78KG5J818", "571800XST2D78KG5J818"]
    },
    {
      "type": "character",
      "attributes": {},
      "value": [null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]
    },
    {
      "type": "character",
      "attributes": {},
      "value": ["L1", "L1", "L2", "L2", "L3", "L3", "L4", "L4", "L5", "L5", "L6", "L6", "L7", "L7", "L8", "L8", "L9", "L9", "L10", "L10", "L11", "L11", "L12", "L12", "L13", "L13"]
    },
    {
      "type": "character",
      "attributes": {},
      "value": ["DL7", "UP7", "DL1", "UP1", "DL13", "UP13", "DL3", "UP3", "DL8", "UP8", "DL2", "UP2", "DL5", "UP5", "DL11", "UP11", "DL9", "UP9", "DL10", "UP10", "DL12", "UP12", "DL6", "UP6", "DL4", "UP4"]
    },
    {
      "type": "character",
      "attributes": {},
      "value": ["direct_loantaker", "ultimate_parent", "direct_loantaker", "ultimate_parent", "direct_loantaker", "ultimate_parent", "direct_loantaker", "ultimate_parent", "direct_loantaker", "ultimate_parent", "direct_loantaker", "ultimate_parent", "direct_loantaker", "ultimate_parent", "direct_loantaker", "ultimate_parent", "direct_loantaker", "ultimate_parent", "direct_loantaker", "ultimate_parent", "direct_loantaker", "ultimate_parent", "direct_loantaker", "ultimate_parent", "direct_loantaker", "ultimate_parent"]
    },
    {
      "type": "character",
      "attributes": {},
      "value": ["oil and gas", "oil and gas", "automotive", "automotive", "steel", "steel", "automotive", "automotive", "power", "power", "automotive", "automotive", "automotive", "automotive", "power", "power", "power", "power", "power", "power", "power", "power", "oil and gas", "oil and gas", "coal", "coal"]
    },
    {
      "type": "character",
      "attributes": {},
      "value": ["oil and gas", "oil and gas", "automotive", "automotive", "steel", "steel", "automotive", "automotive", "power", "power", "automotive", "automotive", "automotive", "automotive", "power", "power", "power", "power", "power", "power", "power", "power", "oil and gas", "oil and gas", "coal", "coal"]
    },
    {
      "type": "character",
      "attributes": {},
      "value": ["large oil and gas company four", "large oil and gas company four", "large automotive company five", "large automotive company five", "large steel company five", "large steel company five", "large automotive company two", "large automotive company two", "large power company five", "large power company five", "large automotive company one", "large automotive company one", "large hdv company three", "large hdv company three", "large power company three", "large power company three", "large power company four", "large power company four", "large power company one", "large power company one", "large power company two", "large power company two", "large oil and gas company five", "large oil and gas company five", "large coal company two", "large coal company two"]
    },
    {
      "type": "character",
      "attributes": {},
      "value": ["large oil and gas company four", "large oil and gas company four", "large automotive company five", "large automotive company five", "large steel company five", "large steel company five", "large automotive company two", "large automotive company two", "large power company five", "large power company five", "large automotive company one", "large automotive company one", "large hdv company three", "large hdv company three", "large power company three", "large power company three", "large power company four", "large power company four", "large power company one", "large power company one", "large power company two", "large power company two", "large oil and gas company five", "large oil and gas company five", "large coal company two", "large coal company two"]
    },
    {
      "type": "double",
      "attributes": {},
      "value": [1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1]
    },
    {
      "type": "character",
      "attributes": {},
      "value": ["loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook", "loanbook"]
    },
    {
      "type": "logical",
      "attributes": {},
      "value": [false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false]
    }
  ]
}

errors if any id_loan is duplicated (#349)

  All values of `id_loan` in a `loanbook` must be unique (`1` is not).
  Please ensure that every loan has a unique identifier.


Try the r2dii.match package in your browser

Any scripts or data that you put into this service are public.

r2dii.match documentation built on Oct. 23, 2023, 5:09 p.m.