Open Source Tools

How Open Data and Open Source can support Green Public Procurement - Part 4

How Open Data and Open Source can support Green Public Procurement - Part 4

In the fourth part of this series we approach Green Public Procurement as a Sustainable Portfolio Management task and explore how open data can support this mission

Reading Time: 9 min.
Recap of Previous Posts Part 1 - Overview of the Public Procurement TED dataset Part 2 - Identification of Entities involved in procurement Part 3 - Attribution of GHG Emissions using the CPV classification In the earlier parts of this series we motivated and defined the scope of our exploration of Public Procurement data, we dug deeper into constructing economic representations of the public procurement process. We also linked procurement entities to private sector sellers.
How Open Data and Open Source can support Green Public Procurement - Part 3

How Open Data and Open Source can support Green Public Procurement - Part 3

In the third part of this series we illustrate how one may assign greenhouse gas emissions to public procurement using environmentally extended input-output models

Reading Time: 10 min.
Recap of Previous Posts Part 1 - Overview of the Public Procurement TED dataset Part 2 - Identification of Entities involved in procurement In the first part of this series we motivated and defined the scope of a study explores Public Procurement data. In the second instalment we dug deeper into an important facet of the data, with the aim of constructing a meaningful economic representation of the public procurement process.
How Open Data and Open Source can support Green Public Procurement - Part 2

How Open Data and Open Source can support Green Public Procurement - Part 2

In the second part of this series we explore how to construct an economic network representation of the public procurement universe

Reading Time: 10 min.
Recap of Previous Post Part 1 - Overview In the first part of this series we motivated and defined the scope of a study that explores Public Procurement data. We discussed the meaning of the main relevant terms (Open Data, Open Source, Green Public Procurement) and briefly reviewed the current state and challenges of the latter in EU context. Further, we took a first look into the EU’s TED Database (which is the main source of data) and highlighted some key statistics which bring to light information such as: size of the dataset, overall structure and some data quality aspects.
How Open Data and Open Source can support Green Public Procurement - Part 1

How Open Data and Open Source can support Green Public Procurement - Part 1

In the first part of this series we survey the TED procurement data landscape to build the context in which we will explore the relevance of this open data set for green public procurement

Reading Time: 13 min.
Introduction In a series of posts we will explore the role of Open Data and Open Source in enabling and accelerating the broad based effort towards Green Public Procurement (GPP). There are several important (and possibly obscure or “buzzwordy”) terms in the above sentence, so the first order of business will be to unpack them. Let us start with the term Public Procurement which will be the main domain of interest in this study.
EU Datathon 2022 preselection for the Equinox platform

EU Datathon 2022 preselection for the Equinox platform

We are very happy to announce that our EU Datathon 2022 proposal based on the equinox platform has been pre-selected to enter the formal stage of the competition

Reading Time: 2 min.
What is the EU Datathon? The EU Datathon is an annual Open Data competition organised by the Publications Office of the European Union since 2017. The competitions are organised to create new value for citizens through innovation and promoting the use of open data, in particular the datasets available on the official portal for European data. Every year, EU Datathon calls for innovators from around the world to come up with new ways of using open data to address important societal and environmental challenges, with the condition that they use at least one of the thousands of data sets published on data.
Equinox 0.4 release focuses on green public procurement functionality

Equinox 0.4 release focuses on green public procurement functionality

On Earth Day 2022 we are happy to release a significant update of Equinox, the open source platform supporting sustainable portfolio management

Reading Time: 1 min.
Equinox is an open source platform that supports holistic risk management and reporting in the context of Sustainable Portfolio Management. The platform integrates geospatial information with applicable regulatory and industry standards, for example the GHG Protocol (accounting for Project based, Corporate and City-Wide greenhouse gas emissions), the IPCC Emissions Factor database and further reference data, the PCAF attribution methodologies (and more) to provide a holistic view of the footprint of both individual projects and portfolios.
Representing Matrices as JSON Objects: Part 1

Representing Matrices as JSON Objects: Part 1

Representing a matrix as a JSON object is a task that appears in many modern data science contexts, in particular when one wants to exchange matrix data online. While there is no universally agreed way to achieve this task in all circumstances, in this series of posts we discuss a number of options and the associated tradeoffs.

Reading Time: 13 min.
Motivation and Objective Representing a matrix as a JSON object is a task that appears in many modern data science contexts, in particular when one wants to exchange matrix data online. There is no universally agreed way to achieve this task and various options are available depending on the matrix type and the programming tools and environment one has available. Matrices are in general not “native” structures in computing environments but are handled with speficic packages (modules, extensions or libraries).
Integrating the IPCC Emissions Factors Database Into Equinox

Integrating the IPCC Emissions Factors Database Into Equinox

In the latest update of the Equinox Project we discuss the integration of reference data an in particular greenhouse gas emissions factors as catalogued in the IPCC Emissions Factors database (EFDB).

Reading Time: 2 min.
Equinox is an open source platform that supports the holistic risk management and reporting of major sustainable finance projects (the financing of projects with material physical footprint) such as project finance. Equinox aims to integrate in the database a number reference databases that facilitate tasks of sustainable portfolio management. In the current focus such reference material concerns the emissions factors for various processes and activities. In the latest (Solstice Day!) update of the Equinox Project we discuss the integration of reference data an in particular greenhouse gas emissions factors as catalogued in the IPCC Emissions Factors database (EFDB).
Open Risk Hydra GSOC 2021 Credit Risk Project Wrap Up

Open Risk Hydra GSOC 2021 Credit Risk Project Wrap Up

Reading Time: 5 min.
The GSOC 2021 collaboration between Open Risk and the Hydra Ecosystem - Project Wrap-Up Google Summer of Code 2021 came and went amid the still ongoing worldwide pandemic experience. Open Risk was happy to join forces with the Hydra Ecosystem in exploring a proof-of-concept for next generation API’s using Hydra. The project aimed to guide students (here and here) to build a hypermedia enabled REST service that can serve standardized credit portfolio data.

Open Risk Mentoring GSOC 2021 Hydra Nextgen API Project

For the Google Summer of Code 2021 season Open Risk is happy to join forces with the Hydra Ecosystem to mentor a student project that aims to build a hypermedia enabled REST service around standardized credit portfolio data

Reading Time: 4 min.
A GSOC 2021 summer project collaboration between Open Risk and the Hydra Ecosystem Summer is underway and for the Google Summer of Code 2021 season Open Risk is happy to join forces with the Hydra Ecosystem. The project aims to guide students to build a hypermedia enabled REST service around standardized credit portfolio data. More specifically the project will build a REST service as backend for a hypothetical banking entity that collects and disseminates credit portfolio data conforming to an established public standard (the EBA NPL templates, see below).
Equinox: a Platform for Sustainable Project Finance Risk Management

Equinox: a Platform for Sustainable Project Finance Risk Management

On Earth Day 2021 we are happy to launch Equinox, an open source platform supporting sustainable project finance

Reading Time: 5 min.
Equinox is an open source platform that supports holistic risk management and reporting of Sustainable Finance (Sustainable Portfolio Management). The platform integrates geospatial information with applicable regulatory and industry standards from EBA, PCAF and Equator Principles to provide a holistic view of the footprint of both individual projects and portfolios, in particular of project finance investments. Motivation Sustainability (understood in environmental, economic and social terms) is emerging as an undisputed constraint that will shape future human activity and more specifically how the financial system facilitates and empowers economic life.
Towards the Semantic Description of Machine Learning Models

Towards the Semantic Description of Machine Learning Models

Reading Time: 7 min.
Semantic Web Technologies integrate naturally with the worlds of open data science and open source machine learning, empowering better control and management of the risks and opportunities that come with increased digitization and model use The ongoing and accelerating digitisation of many aspects of social and economic life means the proliferation of data driven/data intermediated decisions and the reliance on quantitative models of various sorts (going under various hashtags such as machine learning, artificial intelligence, data science etc.

Marking Pi Day 2021 With a Raspberry Pi Docker Image for OpenNPL

We celebrate Pi Day 2021 releasing an ARM version of the openNPL platform that is suitable for the Raspberry Pi

Reading Time: 2 min.
Celebrating Pi Day 2021 Pi Day is celebrated every year on March 14th. The reason of course is that the day is denoted in some calendars as (3/14), which evokes of 3.14, the first three digits of “π”. A thin excuse maybe but sufficient for the true believers to join along! The occasion represents an annual opportunity for mathematics and science enthusiasts to recite the infinite charms of Pi, including its irrationality, to talk to friends and family about math and its uses, and, when everything else fails, simply eat pie.
An introduction to Semantic Python

An introduction to Semantic Python

A CrashCourse introduction to semantic data using Python covering a number of frameworks such as rdflib, owlready and pySHACL

Reading Time: 2 min.
Course Content: This CrashCourse is an introduction to semantic data using Python. It covers the following topics: We learn to work with RDF graphs using rdflib We explore the owlready package and OWL ontologies We look into json-ld serialization of RDF/OWL data We try data validation using pySHACL We use throughout a realistic data set based on the Credit Ratings Ontology Who Is This Course For: The course is useful to:
Logarithmic Sankey Visualization of Credit Migrations

Logarithmic Sankey Visualization of Credit Migrations

Sankey diagrams are very useful for the visualization of flows, especially when there is a conserved quantity. They can be tricky when some of the flows are much smaller than others. In the latest release of transitionMatrix we include an example of a log-scale version of Sankey

Reading Time: 5 min.
Using Sankey Diagrams: Sankey Diagrams are a type of flow diagram composed of interconnected arrows. The width of the arrows is proportional to the flow rate. Sankey diagrams are often used in physical sciences (physics, chemistry, biology) and engineering but also in economics. They can be used to represent the relative role and significance of various inputs and outputs in a given process. Sankey diagrams emphasize the major transfers within a system.
openNPL 0.2 REST API implementation

openNPL 0.2 REST API implementation

The 0.2 release of openNPL exposes a RESTful API that provides easy standardized online access to NPL credit portfolio data conforming to the EBA NPL templates

Reading Time: 4 min.
openNPL 0.2 release The open source openNPL platform supports the management of standardized credit portfolio data for non-performing loans. In this respect it implements the detailed European Banking Authority NPL loan templates. It aims to be at the same time easy to integrate in human workflows (using a familiar web interface) and integrate into automated (computer driven) workflows. The latest (0.2) release exposes a REST API that offers machine oriented access using, what is by now, the most established mechanism for achieving flexible online data transfers.
openNPL now Available in Dockerized Form

openNPL now Available in Dockerized Form

Open Source, cloud based management of Non-Performing Loan data following the European Banking Authority's templates with just a few keystrokes!

Reading Time: 1 min.
openNPL now Available in Dockerized Form Following up on the first release of openNPL the platform is now available to install using Docker. Running openNPL via docker is the installation option that simplifies the manual process (but a working docker installation is required!). Docker Hub You can pull the latest openNPL image from Docker Hub (This method is recommended if you do not want to mess with the source distribution).
21 Ways to Visualize a Timeseries

21 Ways to Visualize a Timeseries

We explore a variety of distinct ways to visualize the same simple dataset

Reading Time: 26 min.
What this blog post is about (and what it isn’t): With the ever more widespread adoption of Data Science, defined as the intensive use of data in various forms of decision making, there is a renewed interest in Visualization as an effective channel for humans to understand data at various stages of the data lifecycle. There is a large variety of data visualization tools which can produce an ever more bewildering variety of visualization types
openNPL: Open Source NPL Platform - First Release

openNPL: Open Source NPL Platform - First Release

We introduce an open source platform that allows the easy management of non-performing loan data

Reading Time: 4 min.
Non-Performing Loans: The covid-19 crisis will certainly impact the concentration of Non-Performing Loans but given the special nature of this economic crisis compared (in particular) with the 2008 financial crisis it is unclear how precisely things will evolve. In a previous post and white paper (OpenRiskWP07_022616) we discussed the importance of advancing open and transparent methodologies for managing the risks associated with such credit portfolios. Effective management of NPL is also a top regulatory priority.
Open Source Securitisation

Open Source Securitisation

Reading Time: 5 min.
Open Source Securitisation: Motivation After the Great Financial Crisis securitisation has become the poster child of a financial product exhibiting complexity and opaqueness. The issues and lessons learned post-crisis were many, involving all aspects of the securitisation process, from the nature and quality of the underlying assets, the incentives of the various agents involved and the ability of investors to analyze the products they invested in. While the most egregious complications involved various types of re-securitisation and/or the interplay of structured credit derivatives undoubtedly even vanilla securitisation structure has a considerable amount of business logic.