Standardise Variable Values With Lookup Codes
This tutorial describes how a module from the costly R package can help you to use lookup codes to standardise variable values and thus facilitate partial automation of costing algorithms.
Categories:
This below section renders a vignette article from the costly library. You can use the following links to:
- view the vignette on the library website (adds useful hyperlinks to code blocks)
- view the source file from that article, and;
- edit its contents (requires a GitHub account).
Note. Parts of the workflow described in this article are common to steps explained in more detail in the article outlining the workflow using fuzzy logic and correspondence tables.
In brief
The steps described and explained in this vignette can also be (more succinctly) accomplished with the following code.
X <- CostlyCountries()
X <- renew(X,
new_val_xx = add_default_currency_seed(X@CostlySeed_r4, include_1L_chr = "Country"),
what_1L_chr = "seed")
X <- renew(X, "jw", type_1L_chr = "slot", what_1L_chr = "logic")
X <- renew(X, new_val_xx = make_country_correspondences("currencies"), what_1L_chr = "correspondences")
X <- renew(X, T, type_1L_chr = "slot", what_1L_chr = "force")
X <- ratify(X)
Y <- CostlyCurrencies()
Y <- renew(Y, new_val_xx = add_default_currency_seed(Y@CostlySeed_r4,
Ready4useDyad_r4 = X@results_ls$Country_Output_Lookup),
what_1L_chr = "seed")
Y <- ratify(Y, type_1L_chr = "Lookup")
Y <- renew(Y, T, type_1L_chr = "slot", what_1L_chr = "force")
Y <- ratify(Y, type_1L_chr = "Lookup")Create project
We begin by creating X, a CostlyCorrespondences module instance.
X <- CostlyCorrespondences()Supply seed dataset
We next create a CostlySeed module instance that includes a dataset containing our variable of interest (in this case, countries). The dataset needs to be paired with a dataset dictionary using the Ready4useDyad module from the ready4use R library. You can supply a custom standards dataset (a tibble), dictionary (a ready4use_dictionary) and the concept represented by our variable of interest using a command of the following format.
# Not run
# A <- CostlySeed(Ready4useDyad_r4 = Ready4useDyad(ds_tb = tibble::tibble(), dictionary_r3 = ready4use_dictionary()), include_chr = c("Country"), label_1L_chr = "Country")The add_default_country_seed function will perform the previous step using values that pair the world.cities dataset of the maps R library with an appropriate dictionary and specifies countries as the concept we will be standardising.
A <- CostlySeed() %>% add_default_currency_seed()We now add A to a new CostlyCorrespondences module instance Y, which we use to standardise the country concept variable using a fuzzy logic And correspondence tables workflow.
A@include_chr <- A@label_1L_chr <- "Country"
Y <- CostlyCountries(CostlySeed_r4 = A) %>%
renew("jw", type_1L_chr = "slot", what_1L_chr = "logic") %>%
renew(new_val_xx = make_country_correspondences("currencies"), what_1L_chr = "correspondences") %>%
renew(T, type_1L_chr = "slot", what_1L_chr = "force") %>%
ratify()We now update X with the results Ready4useDyad from Y (a seed dataset for which country names have been standardised).
X <- renew(X, new_val_xx = CostlySeed(Ready4useDyad_r4 = Y@results_ls$Country_Output_Lookup), what_1L_chr = "seed") # We can now inspect the first few records from our labelled seed dataset.
renewSlot(X, "CostlySeed_r4@Ready4useDyad_r4", type_1L_chr = "label") %>%
exhibitSlot("CostlySeed_r4@Ready4useDyad_r4", display_1L_chr = "head", scroll_box_args_ls = list(width = "100%"))
| Country name | Currency name | Currency symbol | Currency alphabetical ISO code (three letter) | Currency's fractional unit | Number of fractional units in basic unit |
|---|---|---|---|---|---|
| Afghanistan | Afghan afghani | ؋ | AFN | Pul | 100 |
| Albania | Albanian lek | Lek | ALL | Qintar | 100 |
| Algeria | Algerian dinar | DA | DZD | Centime | 100 |
| Andorra | Euro | € | EUR | Cent | 100 |
| Angola | Angolan kwanza | Kz | AOA | Cêntimo | 100 |
| Anguilla | Eastern Caribbean dollar | \$ | XCD | Cent | 100 |
We can also inspect the seed dataset’s dictionary.
exhibitSlot(X, "CostlySeed_r4@Ready4useDyad_r4", type_1L_chr = "dict", scroll_box_args_ls = list(width = "100%"))
| Variable | Category | Description | Class |
|---|---|---|---|
| State / Territory\[1\] | Country | Country name | character |
| Currency\[1\]\[2\] | Currency | Currency name | character |
| Symbol\[D\] orAbbrev.\[3\] | Symbol | Currency symbol | character |
| ISO code\[2\] | A3 | Currency alphabetical ISO code (three letter) | character |
| Fractionalunit | Fractional | Currency's fractional unit | character |
| Numberto basic | Number | Number of fractional units in basic unit | character |
We specify the seed dataset concept that we are looking to standardise and the concept that we will use to lookup replacement values from the standards dataset.
X@CostlySeed_r4@label_1L_chr <- "Currency"
X@CostlySeed_r4@match_1L_chr <- "A3"Specify standards
We can now create B, a CostlyStandards module instance that includes a dataset specifying the complete list of allowable variable values. In many cases using the ISO_4217 dataset from the ISOcodes library will be the optimal source of standardised names for currencies. Using the add_currency_standards function will pair this dataset with a dictionary.
B <- CostlyStandards(Ready4useDyad_r4 = Ready4useDyad() %>% add_currency_standards())We can inspect the first few cases of the labelled version of the standards dataset in B.
renewSlot(B, "Ready4useDyad_r4", type_1L_chr = "label") %>%
exhibitSlot("Ready4useDyad_r4", display_1L_chr = "head", scroll_box_args_ls = list(width = "100%"))
| Alpabetical currency code (three letters) | Numeric currency code | Currency name |
|---|---|---|
| AED | 784 | UAE Dirham |
| AFN | 971 | Afghani |
| ALL | 008 | Lek |
| AMD | 051 | Armenian Dram |
| ANG | 532 | Netherlands Antillean Guilder |
| AOA | 973 | Kwanza |
We can also inspect the data dictionary contained in B.
exhibitSlot(B, "Ready4useDyad_r4", type_1L_chr = "dict", scroll_box_args_ls = list(width = "100%"))
| Variable | Category | Description | Class |
|---|---|---|---|
| Letter | A3 | Alpabetical currency code (three letters) | character |
| Numeric | N | Numeric currency code | character |
| Currency | Currency | Currency name | character |
We can now specifying both the concept (“Currency”) that specifies allowable values for our target variable and the concepts we plan to use for lookup matching (described below).
#B@include_chr <- c("Currency", "Letter")
B@label_1L_chr <- "Currency"
B@match_1L_chr <- "A3"We now add B to X.
X <- renew(X, B, what_1L_chr = "standards")Compare variable of interest values from seed and standards dataset.
Currently, the majority of our currency names need to be standardised. In many cases this may be due to something as simple as the use of lower case.
X <- ratify(X, new_val_xx = "identity")
X@results_ls$Currency_Output_Validation$Invalid_Values
#> [1] "Afghan afghani" "Albanian lek" "Algerian dinar" "Angolan kwanza" "Argentine peso"
#> [6] "Armenian dram" "Aruban florin" "Australian dollar" "Azerbaijani manat" "Bahamian dollar"
#> [11] "Bahraini dinar" "Bangladeshi taka" "Barbadian dollar" "Belarusian ruble" "Belize dollar"
#> [16] "Bermudian dollar" "Bhutanese ngultrum" "Bitcoin[4]" "Bolivian boliviano" "Bosnia and Herzegovina convertible mark"
#> [21] "Botswana pula" "Brazilian real" "Brunei dollar" "Bulgarian lev" "Burmese kyat"
#> [26] "Burundian franc" "Cambodian riel" "Canadian dollar" "Cape Verdean escudo" "Cayman Islands dollar"
#> [31] "Central African CFA franc" "CFP franc" "Chilean peso" "Colombian peso" "Comorian franc"
#> [36] "Congolese franc" "Cook Islands dollar" "Costa Rican colón" "Cuban peso" "Czech koruna"
#> [41] "Danish krone" "Djiboutian franc" "Dominican peso" "Eastern Caribbean dollar" "Egyptian pound"
#> [46] "Eritrean nakfa" "Ethiopian birr" "Falkland Islands pound" "Faroese króna" "Fijian dollar"
#> [51] "Gambian dalasi" "Georgian lari" "Ghanaian cedi" "Gibraltar pound" "Guatemalan quetzal"
#> [56] "Guernsey pound" "Guinean franc" "Guyanese dollar" "Haitian gourde" "Honduran lempira"
#> [61] "Hong Kong dollar" "Hungarian forint" "Icelandic króna" "Indian rupee" "Indonesian rupiah"
#> [66] "Iranian rial" "Iraqi dinar" "Israeli new shekel" "Jamaican dollar" "Japanese yen"
#> [71] "Jersey pound" "Jordanian dinar" "Kazakhstani tenge" "Kenyan shilling" "Kiribati dollar[E]"
#> [76] "Kuwaiti dinar" "Kyrgyz som" "Lao kip" "Lebanese pound" "Lesotho loti"
#> [81] "Liberian dollar" "Libyan dinar" "Macanese pataca" "Macedonian denar" "Malagasy ariary"
#> [86] "Malawian kwacha" "Malaysian ringgit" "Maldivian rufiyaa" "Manx pound" "Mauritanian ouguiya"
#> [91] "Mauritian rupee" "Mexican peso" "Moldovan leu" "Mongolian tögrög" "Moroccan dirham"
#> [96] "Mozambican metical" "Namibian dollar" "Nepalese rupee" "Netherlands Antillean guilder" "New Taiwan dollar"
#> [101] "New Zealand dollar" "Nicaraguan córdoba" "Nigerian naira" "Niue dollar[E]" "North Korean won"
#> [106] "Norwegian krone" "Omani rial" "Pakistani rupee" "Panamanian balboa" "Papua New Guinean kina"
#> [111] "Paraguayan guaraní" "Peruvian sol" "Philippine peso" "Pitcairn Islands dollar[E]" "Polish złoty"
#> [116] "Qatari riyal" "Renminbi" "Romanian leu" "Russian ruble" "Rwandan franc"
#> [121] "Sahrawi peseta" "Saint Helena pound" "Samoan tālā" "São Tomé and Príncipe dobra" "Saudi riyal"
#> [126] "Serbian dinar" "Seychellois rupee" "Sierra Leonean leone" "Singapore dollar" "Solomon Islands dollar"
#> [131] "Somali shilling" "South African rand" "South Korean won" "South Sudanese pound" "Sri Lankan rupee"
#> [136] "Sterling" "Sudanese pound" "Surinamese dollar" "Swazi lilangeni" "Swedish krona"
#> [141] "Swiss franc" "Syrian pound" "Tajikistani somoni" "Tanzanian shilling" "Thai baht"
#> [146] "Tongan paʻanga[K]" "Trinidad and Tobago dollar" "Tunisian dinar" "Turkish lira" "Turkmenistani manat"
#> [151] "Tuvaluan dollar" "Ugandan shilling" "Ukrainian hryvnia" "United Arab Emirates dirham" "United States dollar"
#> [156] "United States dollar[F]" "Uruguayan peso" "Uzbekistani sum" "Vanuatu vatu" "Venezuelan digital bolívar"
#> [161] "Venezuelan sovereign bolívar" "Vietnamese đồng" "West African CFA franc" "Yemeni rial" "Zambian kwacha"
#> [166] "Zimbabwe gold" "Zimbabwean dollar"
Standardised currency names not currently present in our seed dataset are as follows.
X@results_ls$Currency_Output_Validation$Absent_Values
#> [1] "ADB Unit of Account" "Afghani" "Algerian Dinar"
#> [4] "Argentine Peso" "Armenian Dram" "Aruban Florin"
#> [7] "Australian Dollar" "Azerbaijan Manat" "Bahamian Dollar"
#> [10] "Bahraini Dinar" "Baht" "Balboa"
#> [13] "Barbados Dollar" "Belarusian Ruble" "Belize Dollar"
#> [16] "Bermudian Dollar" "Bolívar Soberano" "Boliviano"
#> [19] "Bond Markets Unit European Composite Unit (EURCO)" "Bond Markets Unit European Monetary Unit (E.M.U.-6)" "Bond Markets Unit European Unit of Account 17 (E.U.A.-17)"
#> [22] "Bond Markets Unit European Unit of Account 9 (E.U.A.-9)" "Brazilian Real" "Brunei Dollar"
#> [25] "Bulgarian Lev" "Burundi Franc" "Cabo Verde Escudo"
#> [28] "Canadian Dollar" "Cayman Islands Dollar" "CFA Franc BCEAO"
#> [31] "CFA Franc BEAC" "CFP Franc" "Chilean Peso"
#> [34] "Codes specifically reserved for testing purposes" "Colombian Peso" "Comorian Franc"
#> [37] "Congolese Franc" "Convertible Mark" "Cordoba Oro"
#> [40] "Costa Rican Colon" "Cuban Peso" "Czech Koruna"
#> [43] "Dalasi" "Danish Krone" "Denar"
#> [46] "Djibouti Franc" "Dobra" "Dominican Peso"
#> [49] "Dong" "East Caribbean Dollar" "Egyptian Pound"
#> [52] "El Salvador Colon" "Ethiopian Birr" "Falkland Islands Pound"
#> [55] "Fiji Dollar" "Forint" "Ghana Cedi"
#> [58] "Gibraltar Pound" "Gold" "Gourde"
#> [61] "Guarani" "Guinean Franc" "Guyana Dollar"
#> [64] "Hong Kong Dollar" "Hryvnia" "Iceland Krona"
#> [67] "Indian Rupee" "Iranian Rial" "Iraqi Dinar"
#> [70] "Jamaican Dollar" "Jordanian Dinar" "Kenyan Shilling"
#> [73] "Kina" "Kuna" "Kuwaiti Dinar"
#> [76] "Kwanza" "Kyat" "Lao Kip"
#> [79] "Lari" "Lebanese Pound" "Lek"
#> [82] "Lempira" "Leone" "Liberian Dollar"
#> [85] "Libyan Dinar" "Lilangeni" "Loti"
#> [88] "Malagasy Ariary" "Malawi Kwacha" "Malaysian Ringgit"
#> [91] "Mauritius Rupee" "Mexican Peso" "Mexican Unidad de Inversion (UDI)"
#> [94] "Moldovan Leu" "Moroccan Dirham" "Mozambique Metical"
#> [97] "Mvdol" "Naira" "Nakfa"
#> [100] "Namibia Dollar" "Nepalese Rupee" "Netherlands Antillean Guilder"
#> [103] "New Israeli Sheqel" "New Taiwan Dollar" "New Zealand Dollar"
#> [106] "Ngultrum" "North Korean Won" "Norwegian Krone"
#> [109] "Ouguiya" "Pa’anga" "Pakistan Rupee"
#> [112] "Palladium" "Pataca" "Peso Convertible"
#> [115] "Peso Uruguayo" "Philippine Peso" "Platinum"
#> [118] "Pound Sterling" "Pula" "Qatari Rial"
#> [121] "Quetzal" "Rand" "Rial Omani"
#> [124] "Riel" "Romanian Leu" "Rufiyaa"
#> [127] "Rupiah" "Russian Ruble" "Rwanda Franc"
#> [130] "Saint Helena Pound" "Saudi Riyal" "SDR (Special Drawing Right)"
#> [133] "Serbian Dinar" "Seychelles Rupee" "Silver"
#> [136] "Singapore Dollar" "Sol" "Solomon Islands Dollar"
#> [139] "Som" "Somali Shilling" "Somoni"
#> [142] "South Sudanese Pound" "Sri Lanka Rupee" "Sucre"
#> [145] "Sudanese Pound" "Surinam Dollar" "Swedish Krona"
#> [148] "Swiss Franc" "Syrian Pound" "Taka"
#> [151] "Tala" "Tanzanian Shilling" "Tenge"
#> [154] "The codes assigned for transactions where no currency is involved" "Trinidad and Tobago Dollar" "Tugrik"
#> [157] "Tunisian Dinar" "Turkish Lira" "Turkmenistan New Manat"
#> [160] "UAE Dirham" "Uganda Shilling" "Unidad de Fomento"
#> [163] "Unidad de Valor Real" "Unidad Previsional" "Uruguay Peso en Unidades Indexadas (UI)"
#> [166] "US Dollar" "US Dollar (Next day)" "Uzbekistan Sum"
#> [169] "Vatu" "WIR Euro" "WIR Franc"
#> [172] "Won" "Yemeni Rial" "Yen"
#> [175] "Yuan Renminbi" "Zambian Kwacha" "Zimbabwe Dollar"
#> [178] "Zloty"
Standardise variable values
We standardise the target variable values, specifying that we are using the lookup codes method and not the fuzzy-logic / correspondences method.
X <- ratify(X, type_1L_chr = "Lookup")This significantly reduces the umber of non-standard values for our target variable.
X@results_ls$Currency_Output_Validation$Invalid_Values
#> [1] "Bitcoin[4]" "Cook Islands dollar" "Faroese króna" "Guernsey pound" "Jersey pound" "Kiribati dollar[E]" "Manx pound" "Niue dollar[E]"
#> [9] "Pitcairn Islands dollar[E]" "Sahrawi peseta" "Tuvaluan dollar" "Zimbabwe gold" "Zimbabwean dollar"
If we wish we can remove the non-standardised values.
X <- renew(X, T, type_1L_chr = "slot", what_1L_chr = "force")
X <- ratify(X, type_1L_chr = "Lookup")We can no inspect our results a dataset for which the country names and currency names now conform to ISO standards.
X@results_ls$Currency_Output_Lookup %>%
renew(type_1L_chr = "label") %>%
exhibit(scroll_box_args_ls = list(width = "100%"))
| Country name | Currency name | Currency symbol | Currency alphabetical ISO code (three letter) | Currency's fractional unit | Number of fractional units in basic unit |
|---|---|---|---|---|---|
| Afghanistan | Afghani | ؋ | AFN | Pul | 100 |
| Albania | Lek | Lek | ALL | Qintar | 100 |
| Algeria | Algerian Dinar | DA | DZD | Centime | 100 |
| Andorra | Euro | € | EUR | Cent | 100 |
| Angola | Kwanza | Kz | AOA | Cêntimo | 100 |
| Anguilla | East Caribbean Dollar | \$ | XCD | Cent | 100 |
| Antigua and Barbuda | East Caribbean Dollar | \$ | XCD | Cent | 100 |
| Argentina | Argentine Peso | \$ | ARS | Centavo | 100 |
| Armenia | Armenian Dram | ֏ | AMD | Luma | 100 |
| Aruba | Aruban Florin | ƒ | AWG | Cent | 100 |
| Saint Helena, Ascension and Tristan da Cunha | Saint Helena Pound | £ | SHP | Penny | 100 |
| Australia | Australian Dollar | \$ | AUD | Cent | 100 |
| Austria | Euro | € | EUR | Cent | 100 |
| Azerbaijan | Azerbaijan Manat | ₼ | AZN | Qəpik | 100 |
| Bahamas | Bahamian Dollar | \$ | BSD | Cent | 100 |
| Bahrain | Bahraini Dinar | BD | BHD | Fils | 1000 |
| Bangladesh | Taka | ৳ | BDT | Poisha | 100 |
| Barbados | Barbados Dollar | \$ | BBD | Cent | 100 |
| Belarus | Belarusian Ruble | Br | BYN | Kopeck | 100 |
| Belgium | Euro | € | EUR | Cent | 100 |
| Belize | Belize Dollar | \$ | BZD | Cent | 100 |
| Benin | CFA Franc BCEAO | Fr | XOF | Centime | 100 |
| Bermuda | Bermudian Dollar | \$ | BMD | Cent | 100 |
| Bhutan | Ngultrum | Nu | BTN | Chetrum | 100 |
| Bhutan | Indian Rupee | ₹ | INR | Paisa | 100 |
| Bolivia, Plurinational State of | Boliviano | Bs | BOB | Centavo | 100 |
| Bonaire, Sint Eustatius and Saba | US Dollar | \$ | USD | Cent | 100 |
| Bosnia and Herzegovina | Convertible Mark | KM | BAM | Fening | 100 |
| Botswana | Pula | P | BWP | Thebe | 100 |
| Brazil | Brazilian Real | R\$ | BRL | Centavo | 100 |
| British Indian Ocean Territory | US Dollar | \$ | USD | Cent | 100 |
| Virgin Islands, British | US Dollar | \$ | USD | Cent | 100 |
| Brunei Darussalam | Brunei Dollar | \$ | BND | Sen | 100 |
| Brunei Darussalam | Singapore Dollar | \$ | SGD | Cent | 100 |
| Bulgaria | Bulgarian Lev | Lev | BGN | Stotinka | 100 |
| Burkina Faso | CFA Franc BCEAO | Fr | XOF | Centime | 100 |
| Burundi | Burundi Franc | Fr | BIF | Centime | 100 |
| Cambodia | Riel | ៛ | KHR | Sen | 100 |
| Cambodia | US Dollar | \$ | USD | Cent | 100 |
| Cameroon | CFA Franc BEAC | Fr | XAF | Centime | 100 |
| Canada | Canadian Dollar | \$ | CAD | Cent | 100 |
| Cabo Verde | Cabo Verde Escudo | \$ | CVE | Centavo | 100 |
| Cayman Islands | Cayman Islands Dollar | \$ | KYD | Cent | 100 |
| Central African Republic | CFA Franc BEAC | Fr | XAF | Centime | 100 |
| Chad | CFA Franc BEAC | Fr | XAF | Centime | 100 |
| Chile | Chilean Peso | \$ | CLP | Centavo | 100 |
| China | Yuan Renminbi | ¥ | CNY | Jiao\[G\] | 10 |
| Colombia | Colombian Peso | \$ | COP | Centavo | 100 |
| Comoros | Comorian Franc | Fr | KMF | Centime | 100 |
| Congo, The Democratic Republic of the | Congolese Franc | Fr | CDF | Centime | 100 |
| Congo | CFA Franc BEAC | Fr | XAF | Centime | 100 |
| Cook Islands | New Zealand Dollar | \$ | NZD | Cent | 100 |
| Costa Rica | Costa Rican Colon | ₡ | CRC | Céntimo | 100 |
| Côte d'Ivoire | CFA Franc BCEAO | Fr | XOF | Centime | 100 |
| Croatia | Euro | € | EUR | Cent | 100 |
| Cuba | Cuban Peso | \$ | CUP | Centavo | 100 |
| Curaçao | Netherlands Antillean Guilder | ƒ | ANG | Cent | 100 |
| Cyprus | Euro | € | EUR | Cent | 100 |
| Czechia | Czech Koruna | Kč | CZK | Heller | 100 |
| Denmark | Danish Krone | kr | DKK | Øre | 100 |
| Djibouti | Djibouti Franc | Fr | DJF | Centime | 100 |
| Dominica | East Caribbean Dollar | \$ | XCD | Cent | 100 |
| Dominican Republic | Dominican Peso | \$ | DOP | Centavo | 100 |
| Timor-Leste | US Dollar | \$ | USD | Centavo | 100 |
| Ecuador | US Dollar | \$ | USD | Centavo | 100 |
| Egypt | Egyptian Pound | LE | EGP | Piastre\[B\] | 100 |
| El Salvador | US Dollar | \$ | USD | Cent | 100 |
| Equatorial Guinea | CFA Franc BEAC | Fr | XAF | Centime | 100 |
| Eritrea | Nakfa | Nkf | ERN | Cent | 100 |
| Estonia | Euro | € | EUR | Cent | 100 |
| Eswatini | Lilangeni | L or E (pl.) | SZL | Cent | 100 |
| Eswatini | Rand | R | ZAR | Cent | 100 |
| Ethiopia | Ethiopian Birr | Br | ETB | Santim | 100 |
| Falkland Islands (Malvinas) | Falkland Islands Pound | £ | FKP | Penny | 100 |
| Falkland Islands (Malvinas) | Pound Sterling | £ | GBP | Penny | 100 |
| Faroe Islands | Danish Krone | kr | DKK | Øre | 100 |
| Fiji | Fiji Dollar | \$ | FJD | Cent | 100 |
| Finland | Euro | € | EUR | Cent | 100 |
| France | Euro | € | EUR | Cent | 100 |
| French Polynesia | CFP Franc | ₣ | XPF | Centime | 100 |
| French Southern Territories | Euro | € | EUR | Cent | 100 |
| Gabon | CFA Franc BEAC | Fr | XAF | Centime | 100 |
| Gambia | Dalasi | D | GMD | Butut | 100 |
| Georgia | Lari | ₾ | GEL | Tetri | 100 |
| Germany | Euro | € | EUR | Cent | 100 |
| Ghana | Ghana Cedi | ₵ | GHS | Pesewa | 100 |
| Gibraltar | Gibraltar Pound | £ | GIP | Penny | 100 |
| Gibraltar | Pound Sterling | £ | GBP | Penny | 100 |
| Greece | Euro | € | EUR | Cent | 100 |
| Greenland | Danish Krone | kr | DKK | Øre | 100 |
| Grenada | East Caribbean Dollar | \$ | XCD | Cent | 100 |
| Guatemala | Quetzal | Q | GTQ | Centavo | 100 |
| Guernsey | Pound Sterling | £ | GBP | Penny | 100 |
| Guinea | Guinean Franc | Fr | GNF | Centime | 100 |
| Guinea-Bissau | CFA Franc BCEAO | Fr | XOF | Centime | 100 |
| Guyana | Guyana Dollar | \$ | GYD | Cent | 100 |
| Haiti | Gourde | G | HTG | Centime | 100 |
| Honduras | Lempira | L | HNL | Centavo | 100 |
| Hong Kong | Hong Kong Dollar | \$ | HKD | Cent | 100 |
| Hungary | Forint | Ft | HUF | Fillér | 100 |
| Iceland | Iceland Krona | kr | ISK | Eyrir | 100 |
| India | Indian Rupee | ₹ | INR | Paisa | 100 |
| Indonesia | Rupiah | Rp | IDR | Sen | 100 |
| Iran, Islamic Republic of | Iranian Rial | Rl or Rls (pl.) | IRR | Rial | 1 |
| Iraq | Iraqi Dinar | ID | IQD | Fils | 1000 |
| Ireland | Euro | € | EUR | Cent | 100 |
| Isle of Man | Pound Sterling | £ | GBP | Penny | 100 |
| Israel | New Israeli Sheqel | ₪ | ILS | Agora | 100 |
| Italy | Euro | € | EUR | Cent | 100 |
| Jamaica | Jamaican Dollar | \$ | JMD | Cent | 100 |
| Japan | Yen | ¥ | JPY | Sen\[C\] | 100 |
| Jersey | Pound Sterling | £ | GBP | Penny | 100 |
| Jordan | Jordanian Dinar | JD | JOD | Piastre\[H\] | 100 |
| Kazakhstan | Tenge | ₸ | KZT | Tıyn | 100 |
| Kenya | Kenyan Shilling | Sh or Shs (pl.) | KES | Cent | 100 |
| Kiribati | Australian Dollar | \$ | AUD | Cent | 100 |
| Korea, Democratic People's Republic of | North Korean Won | ₩ | KPW | Chon | 100 |
| Korea, Republic of | Won | ₩ | KRW | Jeon | 100 |
| Kuwait | Kuwaiti Dinar | KD | KWD | Fils | 1000 |
| Kyrgyzstan | Som | som | KGS | Tyiyn | 100 |
| Lao People's Democratic Republic | Lao Kip | ₭ | LAK | Att | 100 |
| Latvia | Euro | € | EUR | Cent | 100 |
| Lebanon | Lebanese Pound | LL | LBP | Piastre | 100 |
| Lesotho | Loti | L or M (pl.) | LSL | Sente | 100 |
| Lesotho | Rand | R | ZAR | Cent | 100 |
| South Georgia and the South Sandwich Islands | Falkland Islands Pound | £ | FKP | Penny | 100 |
| South Georgia and the South Sandwich Islands | Pound Sterling | £ | GBP | Penny | 100 |
| Liberia | Liberian Dollar | \$ | LRD | Cent | 100 |
| Liberia | US Dollar | \$ | USD | Cent | 100 |
| Libya | Libyan Dinar | LD | LYD | Dirham | 1000 |
| Liechtenstein | Swiss Franc | Fr | CHF | Rappen | 100 |
| Lithuania | Euro | € | EUR | Cent | 100 |
| Luxembourg | Euro | € | EUR | Cent | 100 |
| Macao | Pataca | MOP\$ | MOP | Avo | 100 |
| Macao | Hong Kong Dollar | \$ | HKD | Cent | 100 |
| Madagascar | Malagasy Ariary | Ar | MGA | Iraimbilanja | 5 |
| Malawi | Malawi Kwacha | K | MWK | Tambala | 100 |
| Malaysia | Malaysian Ringgit | RM | MYR | Sen | 100 |
| Maldives | Rufiyaa | Rf | MVR | Laari | 100 |
| Mali | CFA Franc BCEAO | Fr | XOF | Centime | 100 |
| Malta | Euro | € | EUR | Cent | 100 |
| Marshall Islands | US Dollar | \$ | USD | Cent | 100 |
| Mauritania | Ouguiya | UM | MRU | Khoums | 5 |
| Mauritius | Mauritius Rupee | Re or Rs (pl.) | MUR | Cent | 100 |
| Mexico | Mexican Peso | \$ | MXN | Centavo | 100 |
| Micronesia, Federated States of | US Dollar | \$ | USD | Cent | 100 |
| Moldova, Republic of | Moldovan Leu | Leu or Lei (pl.) | MDL | Ban | 100 |
| Monaco | Euro | € | EUR | Cent | 100 |
| Mongolia | Tugrik | ₮ | MNT | Möngö | 100 |
| Montenegro | Euro | € | EUR | Cent | 100 |
| Montserrat | East Caribbean Dollar | \$ | XCD | Cent | 100 |
| Morocco | Moroccan Dirham | DH | MAD | Centime | 100 |
| Mozambique | Mozambique Metical | Mt | MZN | Centavo | 100 |
| Myanmar | Kyat | K or Ks (pl.) | MMK | Pya | 100 |
| Namibia | Namibia Dollar | \$ | NAD | Cent | 100 |
| Namibia | Rand | R | ZAR | Cent | 100 |
| Nauru | Australian Dollar | \$ | AUD | Cent | 100 |
| Nepal | Nepalese Rupee | Re or Rs (pl.) | NPR | Paisa | 100 |
| Nepal | Indian Rupee | ₹ | INR | Paisa | 100 |
| Netherlands | Euro | € | EUR | Cent | 100 |
| New Caledonia | CFP Franc | ₣ | XPF | Centime | 100 |
| New Zealand | New Zealand Dollar | \$ | NZD | Cent | 100 |
| Nicaragua | Cordoba Oro | C\$ | NIO | Centavo | 100 |
| Niger | CFA Franc BCEAO | Fr | XOF | Centime | 100 |
| Nigeria | Naira | ₦ | NGN | Kobo | 100 |
| Niue | New Zealand Dollar | \$ | NZD | Cent | 100 |
| North Macedonia | Denar | DEN | MKD | Deni | 100 |
| Norway | Norwegian Krone | kr | NOK | Øre | 100 |
| Oman | Rial Omani | RO | OMR | Baisa | 1000 |
| Pakistan | Pakistan Rupee | Re or Rs (pl.) | PKR | Paisa | 100 |
| Palau | US Dollar | \$ | USD | Cent | 100 |
| Palestine, State of | New Israeli Sheqel | ₪ | ILS | Agora | 100 |
| Palestine, State of | Jordanian Dinar | JD | JOD | Piastre\[H\] | 100 |
| Panama | Balboa | B/ | PAB | Centésimo | 100 |
| Panama | US Dollar | \$ | USD | Cent | 100 |
| Papua New Guinea | Kina | K | PGK | Toea | 100 |
| Paraguay | Guarani | ₲ | PYG | Céntimo | 100 |
| Peru | Sol | S/ | PEN | Céntimo | 100 |
| Philippines | Philippine Peso | ₱ | PHP | Sentimo | 100 |
| Pitcairn | New Zealand Dollar | \$ | NZD | Cent | 100 |
| Poland | Zloty | zł | PLN | Grosz | 100 |
| Portugal | Euro | € | EUR | Cent | 100 |
| Qatar | Qatari Rial | QR | QAR | Dirham | 100 |
| Romania | Romanian Leu | Leu or Lei (pl.) | RON | Ban | 100 |
| Russian Federation | Russian Ruble | ₽ | RUB | Kopeck | 100 |
| Rwanda | Rwanda Franc | Fr | RWF | Centime | 100 |
| Bonaire, Sint Eustatius and Saba | US Dollar | \$ | USD | Cent | 100 |
| Western Sahara | Moroccan Dirham | DH | MAD | Centime | 100 |
| Saint Helena, Ascension and Tristan da Cunha | Saint Helena Pound | £ | SHP | Penny | 100 |
| Saint Helena, Ascension and Tristan da Cunha | Pound Sterling | £ | GBP | Penny | 100 |
| Saint Kitts and Nevis | East Caribbean Dollar | \$ | XCD | Cent | 100 |
| Saint Lucia | East Caribbean Dollar | \$ | XCD | Cent | 100 |
| Saint Pierre and Miquelon | Euro | € | EUR | Cent | 100 |
| Saint Pierre and Miquelon | Canadian Dollar | \$ | CAD | Cent | 100 |
| Saint Vincent and the Grenadines | East Caribbean Dollar | \$ | XCD | Cent | 100 |
| Samoa | Tala | \$ | WST | Sene | 100 |
| Saint Barthélemy | Euro | € | EUR | Cent | 100 |
| San Marino | Euro | € | EUR | Cent | 100 |
| Sao Tome and Principe | Dobra | Db | STN | Cêntimo | 100 |
| Saudi Arabia | Saudi Riyal | Rl or Rls (pl.) | SAR | Halala | 100 |
| Senegal | CFA Franc BCEAO | Fr | XOF | Centime | 100 |
| Serbia | Serbian Dinar | DIN | RSD | Para | 100 |
| Seychelles | Seychelles Rupee | Re or Rs (pl.) | SCR | Cent | 100 |
| Sierra Leone | Leone | Le | SLE | Cent | 100 |
| Singapore | Singapore Dollar | \$ | SGD | Cent | 100 |
| Singapore | Brunei Dollar | \$ | BND | Sen | 100 |
| Bonaire, Sint Eustatius and Saba | US Dollar | \$ | USD | Cent | 100 |
| Sint Maarten (Dutch part) | Netherlands Antillean Guilder | ƒ | ANG | Cent | 100 |
| Slovakia | Euro | € | EUR | Cent | 100 |
| Slovenia | Euro | € | EUR | Cent | 100 |
| Solomon Islands | Solomon Islands Dollar | \$ | SBD | Cent | 100 |
| Somalia | Somali Shilling | Sh or Shs (pl.) | SOS | Cent | 100 |
| South Africa | Rand | R | ZAR | Cent | 100 |
| South Sudan | South Sudanese Pound | LS | SSP | Piaster | 100 |
| Spain | Euro | € | EUR | Cent | 100 |
| Sri Lanka | Sri Lanka Rupee | Re or Rs (pl.) | LKR | Cent | 100 |
| Sudan | Sudanese Pound | LS | SDG | Piastre | 100 |
| Suriname | Surinam Dollar | \$ | SRD | Cent | 100 |
| Sweden | Swedish Krona | kr | SEK | Öre | 100 |
| Switzerland | Swiss Franc | Fr | CHF | Rappen\[J\] | 100 |
| Syrian Arab Republic | Syrian Pound | LS | SYP | Piastre | 100 |
| Taiwan, Province of China | New Taiwan Dollar | \$ | TWD | Cent | 100 |
| Tajikistan | Somoni | SM | TJS | Diram | 100 |
| Tanzania, United Republic of | Tanzanian Shilling | Sh or Shs (pl.) | TZS | Cent | 100 |
| Thailand | Baht | ฿ | THB | Satang | 100 |
| Togo | CFA Franc BCEAO | Fr | XOF | Centime | 100 |
| Tonga | Pa'anga | T\$ | TOP | Seniti | 100 |
| Trinidad and Tobago | Trinidad and Tobago Dollar | \$ | TTD | Cent | 100 |
| Tunisia | Tunisian Dinar | DT | TND | Millime | 1000 |
| Türkiye | Turkish Lira | ₺ | TRY | Kuruş | 100 |
| Turkmenistan | Turkmenistan New Manat | m | TMT | Tenge | 100 |
| Turks and Caicos Islands | US Dollar | \$ | USD | Cent | 100 |
| Tuvalu | Australian Dollar | \$ | AUD | Cent | 100 |
| Uganda | Uganda Shilling | Sh or Shs (pl.) | UGX | (none) | (none) |
| Ukraine | Hryvnia | ₴ | UAH | Kopeck | 100 |
| United Arab Emirates | UAE Dirham | Dh or Dhs (pl.) | AED | Fils | 100 |
| United Kingdom | Pound Sterling | £ | GBP | Penny | 100 |
| United States | US Dollar | \$ | USD | Cent\[A\] | 100 |
| Uruguay | Peso Uruguayo | \$ | UYU | Centésimo | 100 |
| Uzbekistan | Uzbekistan Sum | soum | UZS | Tiyin | 100 |
| Vanuatu | Vatu | VT | VUV | Cent | 100 |
| Holy See (Vatican City State) | Euro | € | EUR | Cent | 100 |
| Venezuela, Bolivarian Republic of | Bolívar Soberano | Bs.S | VES | Céntimo | 1 |
| Venezuela, Bolivarian Republic of | Bolívar Soberano | Bs.D | VED | Céntimo | 100 |
| Venezuela, Bolivarian Republic of | US Dollar | \$ | USD | Cent | 100 |
| Viet Nam | Dong | ₫ | VND | Hào\[L\] | 10 |
| Wallis and Futuna | CFP Franc | ₣ | XPF | Centime | 100 |
| Yemen | Yemeni Rial | Rl or Rls (pl.) | YER | Fils | 100 |
| Zambia | Zambian Kwacha | K | ZMW | Ngwee | 100 |
| Zimbabwe | US Dollar | \$ | USD | Cent | 100 |
Last modified June 8, 2024: updated vignettes (77a947c)