ISO 4217 Currency Codes

JohnSnowLabs

Files Size Format Created Updated License Source
2 135kB csv zip 3 years ago John Snow Labs Standard License John Snow Labs Swiss Association for Standardization
International Organization for Standardization ISO 4217 is the International Standard for currency codes. The most recent edition is ISO 4217:2015. The purpose of ISO 4217:2015 is to establish... read more
Download Developers

Data Files

Download files in this dataset

File Description Size Last changed Download
iso-4217-currency-codes-csv 18kB csv (18kB) , json (76kB)
iso-4217-currency-codes_zip Compressed versions of dataset. Includes normalized CSV and JSON data with original data and datapackage.json. 25kB zip (25kB)

iso-4217-currency-codes-csv  

This is a preview version. There might be more data in the original version.

Field information

Field Name Order Type (Format) Description
Entity 1 string Entity name
Currency 2 string the official Currency name
Alphabetic_Code 3 string The official Currency alphabetic code
Numeric_Code 4 string The official Currency numeric code
Minor_Unit 5 integer Minor unit number
Withdrawal_Date 6 date (%Y-%m-%d)
Withdrawal_Interval 7 string

Integrate this dataset into your favourite tool

Use our data-cli tool designed for data wranglers:

data get https://datahub.io/JohnSnowLabs/iso-4217-currency-codes
data info JohnSnowLabs/iso-4217-currency-codes
tree JohnSnowLabs/iso-4217-currency-codes
# Get a list of dataset's resources
curl -L -s https://datahub.io/JohnSnowLabs/iso-4217-currency-codes/datapackage.json | grep path

# Get resources

curl -L https://datahub.io/JohnSnowLabs/iso-4217-currency-codes/r/0.csv

curl -L https://datahub.io/JohnSnowLabs/iso-4217-currency-codes/r/1.zip

If you are using R here's how to get the data you want quickly loaded:

install.packages("jsonlite", repos="https://cran.rstudio.com/")
library("jsonlite")

json_file <- 'https://datahub.io/JohnSnowLabs/iso-4217-currency-codes/datapackage.json'
json_data <- fromJSON(paste(readLines(json_file), collapse=""))

# get list of all resources:
print(json_data$resources$name)

# print all tabular data(if exists any)
for(i in 1:length(json_data$resources$datahub$type)){
  if(json_data$resources$datahub$type[i]=='derived/csv'){
    path_to_file = json_data$resources$path[i]
    data <- read.csv(url(path_to_file))
    print(data)
  }
}

Note: You might need to run the script with root permissions if you are running on Linux machine

Install the Frictionless Data data package library and the pandas itself:

pip install datapackage
pip install pandas

Now you can use the datapackage in the Pandas:

import datapackage
import pandas as pd

data_url = 'https://datahub.io/JohnSnowLabs/iso-4217-currency-codes/datapackage.json'

# to load Data Package into storage
package = datapackage.Package(data_url)

# to load only tabular data
resources = package.resources
for resource in resources:
    if resource.tabular:
        data = pd.read_csv(resource.descriptor['path'])
        print (data)

For Python, first install the `datapackage` library (all the datasets on DataHub are Data Packages):

pip install datapackage

To get Data Package into your Python environment, run following code:

from datapackage import Package

package = Package('https://datahub.io/JohnSnowLabs/iso-4217-currency-codes/datapackage.json')

# print list of all resources:
print(package.resource_names)

# print processed tabular data (if exists any)
for resource in package.resources:
    if resource.descriptor['datahub']['type'] == 'derived/csv':
        print(resource.read())

If you are using JavaScript, please, follow instructions below:

Install data.js module using npm:

  $ npm install data.js

Once the package is installed, use the following code snippet:

const {Dataset} = require('data.js')

const path = 'https://datahub.io/JohnSnowLabs/iso-4217-currency-codes/datapackage.json'

// We're using self-invoking function here as we want to use async-await syntax:
;(async () => {
  const dataset = await Dataset.load(path)
  // get list of all resources:
  for (const id in dataset.resources) {
    console.log(dataset.resources[id]._descriptor.name)
  }
  // get all tabular data(if exists any)
  for (const id in dataset.resources) {
    if (dataset.resources[id]._descriptor.format === "csv") {
      const file = dataset.resources[id]
      // Get a raw stream
      const stream = await file.stream()
      // entire file as a buffer (be careful with large files!)
      const buffer = await file.buffer
      // print data
      stream.pipe(process.stdout)
    }
  }
})()

Read me

International Organization for Standardization ISO 4217 is the International Standard for currency codes. The most recent edition is ISO 4217:2015. The purpose of ISO 4217:2015 is to establish internationally recognised codes for the representation of currencies. Currencies can be represented in the code in two ways: a three-letter alphabetic code and a three-digit numeric code.
Datapackage.json