notebook.community

Edit and run

Let us get some data from statistical providers using SDMX. As always, we begin by importing the module.





In [1]:



    


import sdmx

This module implement by default a few bookmarks to various sdmx repositories that are known to work with pysdmx. Other statistical providers are not guaranted to function properly with this client.





In [2]:



    


sdmx.__all__



    


















    
Out[2]:








('ecb', 'ilo', 'fao', 'eurostat', 'Repository')

We can see attributes for ECB, Eurostat, ILO and FAO. The Repository object allows you to define other repositories. This notebook will only cover the providers implemented by default.





In [3]:



    


dir(sdmx.ecb)



    


















    
Out[3]:








['__class__',
 '__delattr__',
 '__dict__',
 '__dir__',
 '__doc__',
 '__eq__',
 '__format__',
 '__ge__',
 '__getattribute__',
 '__gt__',
 '__hash__',
 '__init__',
 '__le__',
 '__lt__',
 '__module__',
 '__ne__',
 '__new__',
 '__reduce__',
 '__reduce_ex__',
 '__repr__',
 '__setattr__',
 '__sizeof__',
 '__str__',
 '__subclasshook__',
 '__weakref__',
 '_dataflows',
 'agencyID',
 'categories',
 'category_scheme_url',
 'codes',
 'data',
 'data_for_computers',
 'dataflow_url',
 'dataflows',
 'fh',
 'frmt',
 'lgr',
 'query_rest',
 'raw_data',
 'request',
 'sdmx_url',
 'version']

Let us have a look at a few interesting atributes. First, the version of the SDMX specification used by the provider.





In [4]:



    


sdmx.ecb.version



    


















    
Out[4]:








'2_0'

It may differ for other sources.





In [5]:



    


sdmx.eurostat.version



    


















    
Out[5]:








'2_1'

pysdmx provides a few information that are typical of SDMX. It may be useful if you are using other tools exploiting that standard.





In [6]:



    


sdmx.ecb.agencyID



    


















    
Out[6]:








'ECB'

















In [7]:



    


sdmx.ecb.sdmx_url



    


















    
Out[7]:








'http://sdw-ws.ecb.europa.eu'

At first, you probably want to have a look at the categories. The data are organized in a tree. Each leaf corresponds to a set of data.





In [8]:



    


c = sdmx.ecb.categories



    


















    






INFO:pysdmx:Requesting http://sdw-ws.ecb.europa.eu/CategoryScheme

We can check the top-level categories.





In [9]:



    


[subcategory['name'] for subcategory in c['subcategories']]



    


















    
Out[9]:








['Monetary operations',
 'Prices, output, demand and labour market',
 'Monetary and financial statistics',
 'Euro area accounts',
 'Government finance',
 'External transactions and positions',
 'Exchange rates',
 'Payments and securities trading, clearing, settlement',
 'Banknotes and Coins',
 'Indicators of financial integration ',
 'Real Time Database (research database) ']

Let us explore one category in particular.





In [10]:



    


c['subcategories'][6]



    


















    
Out[10]:








{'name': 'Exchange rates',
 'subcategories': [{'name': 'Bilateral', 'flowrefs': ['2034483']},
  {'name': 'Effective', 'flowrefs': ['2034482']},
  {'name': 'Harmonised competitiveness indicators',
   'flowrefs': ['6275201', '6275202', '6275203', '6275204', '9391627']},
  {'name': 'Trade weights', 'flowrefs': ['9384602']}]}

We can achieve the same result using a slightly more expressive statement.





In [11]:



    


next((c_ for c_ in c['subcategories'] if c_['name'] == 'Exchange rates'))



    


















    
Out[11]:








{'name': 'Exchange rates',
 'subcategories': [{'name': 'Bilateral', 'flowrefs': ['2034483']},
  {'name': 'Effective', 'flowrefs': ['2034482']},
  {'name': 'Harmonised competitiveness indicators',
   'flowrefs': ['6275201', '6275202', '6275203', '6275204', '9391627']},
  {'name': 'Trade weights', 'flowrefs': ['9384602']}]}

In SDMX, the flowrefs are identifiers of data flows. These allow you to select a set of data.





In [12]:



    


sdmx.ecb.raw_data('2034483',{'CURRENCY':'CHF', 'FREQ':'M'})



    


















    






INFO:pysdmx:Requesting http://sdw-ws.ecb.europa.eu/GenericData?dataflow=2034483&FREQ=M&CURRENCY=CHF
DEBUG:pysdmx:Extracting the series from the SDMX message
DEBUG:pysdmx:Code OrderedDict([('FREQ', 'M'), ('CURRENCY', 'CHF'), ('CURRENCY_DENOM', 'EUR'), ('EXR_TYPE', 'SP00'), ('EXR_SUFFIX', 'A')])
DEBUG:pysdmx:Time vector 1999-01
DEBUG:pysdmx:Time vector 1999-02
DEBUG:pysdmx:Time vector 1999-03
DEBUG:pysdmx:Time vector 1999-04
DEBUG:pysdmx:Time vector 1999-05
DEBUG:pysdmx:Time vector 1999-06
DEBUG:pysdmx:Time vector 1999-07
DEBUG:pysdmx:Time vector 1999-08
DEBUG:pysdmx:Time vector 1999-09
DEBUG:pysdmx:Time vector 1999-10
DEBUG:pysdmx:Time vector 1999-11
DEBUG:pysdmx:Time vector 1999-12
DEBUG:pysdmx:Time vector 2000-01
DEBUG:pysdmx:Time vector 2000-02
DEBUG:pysdmx:Time vector 2000-03
DEBUG:pysdmx:Time vector 2000-04
DEBUG:pysdmx:Time vector 2000-05
DEBUG:pysdmx:Time vector 2000-06
DEBUG:pysdmx:Time vector 2000-07
DEBUG:pysdmx:Time vector 2000-08
DEBUG:pysdmx:Time vector 2000-09
DEBUG:pysdmx:Time vector 2000-10
DEBUG:pysdmx:Time vector 2000-11
DEBUG:pysdmx:Time vector 2000-12
DEBUG:pysdmx:Time vector 2001-01
DEBUG:pysdmx:Time vector 2001-02
DEBUG:pysdmx:Time vector 2001-03
DEBUG:pysdmx:Time vector 2001-04
DEBUG:pysdmx:Time vector 2001-05
DEBUG:pysdmx:Time vector 2001-06
DEBUG:pysdmx:Time vector 2001-07
DEBUG:pysdmx:Time vector 2001-08
DEBUG:pysdmx:Time vector 2001-09
DEBUG:pysdmx:Time vector 2001-10
DEBUG:pysdmx:Time vector 2001-11
DEBUG:pysdmx:Time vector 2001-12
DEBUG:pysdmx:Time vector 2002-01
DEBUG:pysdmx:Time vector 2002-02
DEBUG:pysdmx:Time vector 2002-03
DEBUG:pysdmx:Time vector 2002-04
DEBUG:pysdmx:Time vector 2002-05
DEBUG:pysdmx:Time vector 2002-06
DEBUG:pysdmx:Time vector 2002-07
DEBUG:pysdmx:Time vector 2002-08
DEBUG:pysdmx:Time vector 2002-09
DEBUG:pysdmx:Time vector 2002-10
DEBUG:pysdmx:Time vector 2002-11
DEBUG:pysdmx:Time vector 2002-12
DEBUG:pysdmx:Time vector 2003-01
DEBUG:pysdmx:Time vector 2003-02
DEBUG:pysdmx:Time vector 2003-03
DEBUG:pysdmx:Time vector 2003-04
DEBUG:pysdmx:Time vector 2003-05
DEBUG:pysdmx:Time vector 2003-06
DEBUG:pysdmx:Time vector 2003-07
DEBUG:pysdmx:Time vector 2003-08
DEBUG:pysdmx:Time vector 2003-09
DEBUG:pysdmx:Time vector 2003-10
DEBUG:pysdmx:Time vector 2003-11
DEBUG:pysdmx:Time vector 2003-12
DEBUG:pysdmx:Time vector 2004-01
DEBUG:pysdmx:Time vector 2004-02
DEBUG:pysdmx:Time vector 2004-03
DEBUG:pysdmx:Time vector 2004-04
DEBUG:pysdmx:Time vector 2004-05
DEBUG:pysdmx:Time vector 2004-06
DEBUG:pysdmx:Time vector 2004-07
DEBUG:pysdmx:Time vector 2004-08
DEBUG:pysdmx:Time vector 2004-09
DEBUG:pysdmx:Time vector 2004-10
DEBUG:pysdmx:Time vector 2004-11
DEBUG:pysdmx:Time vector 2004-12
DEBUG:pysdmx:Time vector 2005-01
DEBUG:pysdmx:Time vector 2005-02
DEBUG:pysdmx:Time vector 2005-03
DEBUG:pysdmx:Time vector 2005-04
DEBUG:pysdmx:Time vector 2005-05
DEBUG:pysdmx:Time vector 2005-06
DEBUG:pysdmx:Time vector 2005-07
DEBUG:pysdmx:Time vector 2005-08
DEBUG:pysdmx:Time vector 2005-09
DEBUG:pysdmx:Time vector 2005-10
DEBUG:pysdmx:Time vector 2005-11
DEBUG:pysdmx:Time vector 2005-12
DEBUG:pysdmx:Time vector 2006-01
DEBUG:pysdmx:Time vector 2006-02
DEBUG:pysdmx:Time vector 2006-03
DEBUG:pysdmx:Time vector 2006-04
DEBUG:pysdmx:Time vector 2006-05
DEBUG:pysdmx:Time vector 2006-06
DEBUG:pysdmx:Time vector 2006-07
DEBUG:pysdmx:Time vector 2006-08
DEBUG:pysdmx:Time vector 2006-09
DEBUG:pysdmx:Time vector 2006-10
DEBUG:pysdmx:Time vector 2006-11
DEBUG:pysdmx:Time vector 2006-12
DEBUG:pysdmx:Time vector 2007-01
DEBUG:pysdmx:Time vector 2007-02
DEBUG:pysdmx:Time vector 2007-03
DEBUG:pysdmx:Time vector 2007-04
DEBUG:pysdmx:Time vector 2007-05
DEBUG:pysdmx:Time vector 2007-06
DEBUG:pysdmx:Time vector 2007-07
DEBUG:pysdmx:Time vector 2007-08
DEBUG:pysdmx:Time vector 2007-09
DEBUG:pysdmx:Time vector 2007-10
DEBUG:pysdmx:Time vector 2007-11
DEBUG:pysdmx:Time vector 2007-12
DEBUG:pysdmx:Time vector 2008-01
DEBUG:pysdmx:Time vector 2008-02
DEBUG:pysdmx:Time vector 2008-03
DEBUG:pysdmx:Time vector 2008-04
DEBUG:pysdmx:Time vector 2008-05
DEBUG:pysdmx:Time vector 2008-06
DEBUG:pysdmx:Time vector 2008-07
DEBUG:pysdmx:Time vector 2008-08
DEBUG:pysdmx:Time vector 2008-09
DEBUG:pysdmx:Time vector 2008-10
DEBUG:pysdmx:Time vector 2008-11
DEBUG:pysdmx:Time vector 2008-12
DEBUG:pysdmx:Time vector 2009-01
DEBUG:pysdmx:Time vector 2009-02
DEBUG:pysdmx:Time vector 2009-03
DEBUG:pysdmx:Time vector 2009-04
DEBUG:pysdmx:Time vector 2009-05
DEBUG:pysdmx:Time vector 2009-06
DEBUG:pysdmx:Time vector 2009-07
DEBUG:pysdmx:Time vector 2009-08
DEBUG:pysdmx:Time vector 2009-09
DEBUG:pysdmx:Time vector 2009-10
DEBUG:pysdmx:Time vector 2009-11
DEBUG:pysdmx:Time vector 2009-12
DEBUG:pysdmx:Time vector 2010-01
DEBUG:pysdmx:Time vector 2010-02
DEBUG:pysdmx:Time vector 2010-03
DEBUG:pysdmx:Time vector 2010-04
DEBUG:pysdmx:Time vector 2010-05
DEBUG:pysdmx:Time vector 2010-06
DEBUG:pysdmx:Time vector 2010-07
DEBUG:pysdmx:Time vector 2010-08
DEBUG:pysdmx:Time vector 2010-09
DEBUG:pysdmx:Time vector 2010-10
DEBUG:pysdmx:Time vector 2010-11
DEBUG:pysdmx:Time vector 2010-12
DEBUG:pysdmx:Time vector 2011-01
DEBUG:pysdmx:Time vector 2011-02
DEBUG:pysdmx:Time vector 2011-03
DEBUG:pysdmx:Time vector 2011-04
DEBUG:pysdmx:Time vector 2011-05
DEBUG:pysdmx:Time vector 2011-06
DEBUG:pysdmx:Time vector 2011-07
DEBUG:pysdmx:Time vector 2011-08
DEBUG:pysdmx:Time vector 2011-09
DEBUG:pysdmx:Time vector 2011-10
DEBUG:pysdmx:Time vector 2011-11
DEBUG:pysdmx:Time vector 2011-12
DEBUG:pysdmx:Time vector 2012-01
DEBUG:pysdmx:Time vector 2012-02
DEBUG:pysdmx:Time vector 2012-03
DEBUG:pysdmx:Time vector 2012-04
DEBUG:pysdmx:Time vector 2012-05
DEBUG:pysdmx:Time vector 2012-06
DEBUG:pysdmx:Time vector 2012-07
DEBUG:pysdmx:Time vector 2012-08
DEBUG:pysdmx:Time vector 2012-09
DEBUG:pysdmx:Time vector 2012-10
DEBUG:pysdmx:Time vector 2012-11
DEBUG:pysdmx:Time vector 2012-12
DEBUG:pysdmx:Time vector 2013-01
DEBUG:pysdmx:Time vector 2013-02
DEBUG:pysdmx:Time vector 2013-03
DEBUG:pysdmx:Time vector 2013-04
DEBUG:pysdmx:Time vector 2013-05
DEBUG:pysdmx:Time vector 2013-06
DEBUG:pysdmx:Time vector 2013-07
DEBUG:pysdmx:Time vector 2013-08
DEBUG:pysdmx:Time vector 2013-09
DEBUG:pysdmx:Time vector 2013-10
DEBUG:pysdmx:Time vector 2013-11
DEBUG:pysdmx:Time vector 2013-12
DEBUG:pysdmx:Time vector 2014-01
DEBUG:pysdmx:Time vector 2014-02
DEBUG:pysdmx:Time vector 2014-03
DEBUG:pysdmx:Time vector 2014-04
DEBUG:pysdmx:Time vector 2014-05
DEBUG:pysdmx:Time vector 2014-06
DEBUG:pysdmx:Time vector 2014-07
DEBUG:pysdmx:Time vector 2014-08
DEBUG:pysdmx:Time vector 2014-09
DEBUG:pysdmx:Time vector 2014-10
DEBUG:pysdmx:Time vector 2014-11
DEBUG:pysdmx:Time vector 2014-12
DEBUG:pysdmx:Time vector 2015-01
DEBUG:pysdmx:Time vector 2015-02
DEBUG:pysdmx:Time vector 2015-03
DEBUG:pysdmx:Time vector 2015-04
DEBUG:pysdmx:Time vector 2015-05
DEBUG:pysdmx:Time vector 2015-06
DEBUG:pysdmx:Time vector 2015-07
DEBUG:pysdmx:Extracting the series from the SDMX message
DEBUG:pysdmx:Code OrderedDict([('FREQ', 'M'), ('CURRENCY', 'CHF'), ('CURRENCY_DENOM', 'EUR'), ('EXR_TYPE', 'SP00'), ('EXR_SUFFIX', 'E')])
DEBUG:pysdmx:Time vector 1999-01
DEBUG:pysdmx:Time vector 1999-02
DEBUG:pysdmx:Time vector 1999-03
DEBUG:pysdmx:Time vector 1999-04
DEBUG:pysdmx:Time vector 1999-05
DEBUG:pysdmx:Time vector 1999-06
DEBUG:pysdmx:Time vector 1999-07
DEBUG:pysdmx:Time vector 1999-08
DEBUG:pysdmx:Time vector 1999-09
DEBUG:pysdmx:Time vector 1999-10
DEBUG:pysdmx:Time vector 1999-11
DEBUG:pysdmx:Time vector 1999-12
DEBUG:pysdmx:Time vector 2000-01
DEBUG:pysdmx:Time vector 2000-02
DEBUG:pysdmx:Time vector 2000-03
DEBUG:pysdmx:Time vector 2000-04
DEBUG:pysdmx:Time vector 2000-05
DEBUG:pysdmx:Time vector 2000-06
DEBUG:pysdmx:Time vector 2000-07
DEBUG:pysdmx:Time vector 2000-08
DEBUG:pysdmx:Time vector 2000-09
DEBUG:pysdmx:Time vector 2000-10
DEBUG:pysdmx:Time vector 2000-11
DEBUG:pysdmx:Time vector 2000-12
DEBUG:pysdmx:Time vector 2001-01
DEBUG:pysdmx:Time vector 2001-02
DEBUG:pysdmx:Time vector 2001-03
DEBUG:pysdmx:Time vector 2001-04
DEBUG:pysdmx:Time vector 2001-05
DEBUG:pysdmx:Time vector 2001-06
DEBUG:pysdmx:Time vector 2001-07
DEBUG:pysdmx:Time vector 2001-08
DEBUG:pysdmx:Time vector 2001-09
DEBUG:pysdmx:Time vector 2001-10
DEBUG:pysdmx:Time vector 2001-11
DEBUG:pysdmx:Time vector 2001-12
DEBUG:pysdmx:Time vector 2002-01
DEBUG:pysdmx:Time vector 2002-02
DEBUG:pysdmx:Time vector 2002-03
DEBUG:pysdmx:Time vector 2002-04
DEBUG:pysdmx:Time vector 2002-05
DEBUG:pysdmx:Time vector 2002-06
DEBUG:pysdmx:Time vector 2002-07
DEBUG:pysdmx:Time vector 2002-08
DEBUG:pysdmx:Time vector 2002-09
DEBUG:pysdmx:Time vector 2002-10
DEBUG:pysdmx:Time vector 2002-11
DEBUG:pysdmx:Time vector 2002-12
DEBUG:pysdmx:Time vector 2003-01
DEBUG:pysdmx:Time vector 2003-02
DEBUG:pysdmx:Time vector 2003-03
DEBUG:pysdmx:Time vector 2003-04
DEBUG:pysdmx:Time vector 2003-05
DEBUG:pysdmx:Time vector 2003-06
DEBUG:pysdmx:Time vector 2003-07
DEBUG:pysdmx:Time vector 2003-08
DEBUG:pysdmx:Time vector 2003-09
DEBUG:pysdmx:Time vector 2003-10
DEBUG:pysdmx:Time vector 2003-11
DEBUG:pysdmx:Time vector 2003-12
DEBUG:pysdmx:Time vector 2004-01
DEBUG:pysdmx:Time vector 2004-02
DEBUG:pysdmx:Time vector 2004-03
DEBUG:pysdmx:Time vector 2004-04
DEBUG:pysdmx:Time vector 2004-05
DEBUG:pysdmx:Time vector 2004-06
DEBUG:pysdmx:Time vector 2004-07
DEBUG:pysdmx:Time vector 2004-08
DEBUG:pysdmx:Time vector 2004-09
DEBUG:pysdmx:Time vector 2004-10
DEBUG:pysdmx:Time vector 2004-11
DEBUG:pysdmx:Time vector 2004-12
DEBUG:pysdmx:Time vector 2005-01
DEBUG:pysdmx:Time vector 2005-02
DEBUG:pysdmx:Time vector 2005-03
DEBUG:pysdmx:Time vector 2005-04
DEBUG:pysdmx:Time vector 2005-05
DEBUG:pysdmx:Time vector 2005-06
DEBUG:pysdmx:Time vector 2005-07
DEBUG:pysdmx:Time vector 2005-08
DEBUG:pysdmx:Time vector 2005-09
DEBUG:pysdmx:Time vector 2005-10
DEBUG:pysdmx:Time vector 2005-11
DEBUG:pysdmx:Time vector 2005-12
DEBUG:pysdmx:Time vector 2006-01
DEBUG:pysdmx:Time vector 2006-02
DEBUG:pysdmx:Time vector 2006-03
DEBUG:pysdmx:Time vector 2006-04
DEBUG:pysdmx:Time vector 2006-05
DEBUG:pysdmx:Time vector 2006-06
DEBUG:pysdmx:Time vector 2006-07
DEBUG:pysdmx:Time vector 2006-08
DEBUG:pysdmx:Time vector 2006-09
DEBUG:pysdmx:Time vector 2006-10
DEBUG:pysdmx:Time vector 2006-11
DEBUG:pysdmx:Time vector 2006-12
DEBUG:pysdmx:Time vector 2007-01
DEBUG:pysdmx:Time vector 2007-02
DEBUG:pysdmx:Time vector 2007-03
DEBUG:pysdmx:Time vector 2007-04
DEBUG:pysdmx:Time vector 2007-05
DEBUG:pysdmx:Time vector 2007-06
DEBUG:pysdmx:Time vector 2007-07
DEBUG:pysdmx:Time vector 2007-08
DEBUG:pysdmx:Time vector 2007-09
DEBUG:pysdmx:Time vector 2007-10
DEBUG:pysdmx:Time vector 2007-11
DEBUG:pysdmx:Time vector 2007-12
DEBUG:pysdmx:Time vector 2008-01
DEBUG:pysdmx:Time vector 2008-02
DEBUG:pysdmx:Time vector 2008-03
DEBUG:pysdmx:Time vector 2008-04
DEBUG:pysdmx:Time vector 2008-05
DEBUG:pysdmx:Time vector 2008-06
DEBUG:pysdmx:Time vector 2008-07
DEBUG:pysdmx:Time vector 2008-08
DEBUG:pysdmx:Time vector 2008-09
DEBUG:pysdmx:Time vector 2008-10
DEBUG:pysdmx:Time vector 2008-11
DEBUG:pysdmx:Time vector 2008-12
DEBUG:pysdmx:Time vector 2009-01
DEBUG:pysdmx:Time vector 2009-02
DEBUG:pysdmx:Time vector 2009-03
DEBUG:pysdmx:Time vector 2009-04
DEBUG:pysdmx:Time vector 2009-05
DEBUG:pysdmx:Time vector 2009-06
DEBUG:pysdmx:Time vector 2009-07
DEBUG:pysdmx:Time vector 2009-08
DEBUG:pysdmx:Time vector 2009-09
DEBUG:pysdmx:Time vector 2009-10
DEBUG:pysdmx:Time vector 2009-11
DEBUG:pysdmx:Time vector 2009-12
DEBUG:pysdmx:Time vector 2010-01
DEBUG:pysdmx:Time vector 2010-02
DEBUG:pysdmx:Time vector 2010-03
DEBUG:pysdmx:Time vector 2010-04
DEBUG:pysdmx:Time vector 2010-05
DEBUG:pysdmx:Time vector 2010-06
DEBUG:pysdmx:Time vector 2010-07
DEBUG:pysdmx:Time vector 2010-08
DEBUG:pysdmx:Time vector 2010-09
DEBUG:pysdmx:Time vector 2010-10
DEBUG:pysdmx:Time vector 2010-11
DEBUG:pysdmx:Time vector 2010-12
DEBUG:pysdmx:Time vector 2011-01
DEBUG:pysdmx:Time vector 2011-02
DEBUG:pysdmx:Time vector 2011-03
DEBUG:pysdmx:Time vector 2011-04
DEBUG:pysdmx:Time vector 2011-05
DEBUG:pysdmx:Time vector 2011-06
DEBUG:pysdmx:Time vector 2011-07
DEBUG:pysdmx:Time vector 2011-08
DEBUG:pysdmx:Time vector 2011-09
DEBUG:pysdmx:Time vector 2011-10
DEBUG:pysdmx:Time vector 2011-11
DEBUG:pysdmx:Time vector 2011-12
DEBUG:pysdmx:Time vector 2012-01
DEBUG:pysdmx:Time vector 2012-02
DEBUG:pysdmx:Time vector 2012-03
DEBUG:pysdmx:Time vector 2012-04
DEBUG:pysdmx:Time vector 2012-05
DEBUG:pysdmx:Time vector 2012-06
DEBUG:pysdmx:Time vector 2012-07
DEBUG:pysdmx:Time vector 2012-08
DEBUG:pysdmx:Time vector 2012-09
DEBUG:pysdmx:Time vector 2012-10
DEBUG:pysdmx:Time vector 2012-11
DEBUG:pysdmx:Time vector 2012-12
DEBUG:pysdmx:Time vector 2013-01
DEBUG:pysdmx:Time vector 2013-02
DEBUG:pysdmx:Time vector 2013-03
DEBUG:pysdmx:Time vector 2013-04
DEBUG:pysdmx:Time vector 2013-05
DEBUG:pysdmx:Time vector 2013-06
DEBUG:pysdmx:Time vector 2013-07
DEBUG:pysdmx:Time vector 2013-08
DEBUG:pysdmx:Time vector 2013-09
DEBUG:pysdmx:Time vector 2013-10
DEBUG:pysdmx:Time vector 2013-11
DEBUG:pysdmx:Time vector 2013-12
DEBUG:pysdmx:Time vector 2014-01
DEBUG:pysdmx:Time vector 2014-02
DEBUG:pysdmx:Time vector 2014-03
DEBUG:pysdmx:Time vector 2014-04
DEBUG:pysdmx:Time vector 2014-05
DEBUG:pysdmx:Time vector 2014-06
DEBUG:pysdmx:Time vector 2014-07
DEBUG:pysdmx:Time vector 2014-08
DEBUG:pysdmx:Time vector 2014-09
DEBUG:pysdmx:Time vector 2014-10
DEBUG:pysdmx:Time vector 2014-11
DEBUG:pysdmx:Time vector 2014-12
DEBUG:pysdmx:Time vector 2015-01
DEBUG:pysdmx:Time vector 2015-02
DEBUG:pysdmx:Time vector 2015-03
DEBUG:pysdmx:Time vector 2015-04
DEBUG:pysdmx:Time vector 2015-05
DEBUG:pysdmx:Time vector 2015-06
DEBUG:pysdmx:Time vector 2015-07










    






['1999-01', '1999-02', '1999-03', '1999-04', '1999-05', '1999-06', '1999-07', '1999-08', '1999-09', '1999-10', '1999-11', '1999-12', '2000-01', '2000-02', '2000-03', '2000-04', '2000-05', '2000-06', '2000-07', '2000-08', '2000-09', '2000-10', '2000-11', '2000-12', '2001-01', '2001-02', '2001-03', '2001-04', '2001-05', '2001-06', '2001-07', '2001-08', '2001-09', '2001-10', '2001-11', '2001-12', '2002-01', '2002-02', '2002-03', '2002-04', '2002-05', '2002-06', '2002-07', '2002-08', '2002-09', '2002-10', '2002-11', '2002-12', '2003-01', '2003-02', '2003-03', '2003-04', '2003-05', '2003-06', '2003-07', '2003-08', '2003-09', '2003-10', '2003-11', '2003-12', '2004-01', '2004-02', '2004-03', '2004-04', '2004-05', '2004-06', '2004-07', '2004-08', '2004-09', '2004-10', '2004-11', '2004-12', '2005-01', '2005-02', '2005-03', '2005-04', '2005-05', '2005-06', '2005-07', '2005-08', '2005-09', '2005-10', '2005-11', '2005-12', '2006-01', '2006-02', '2006-03', '2006-04', '2006-05', '2006-06', '2006-07', '2006-08', '2006-09', '2006-10', '2006-11', '2006-12', '2007-01', '2007-02', '2007-03', '2007-04', '2007-05', '2007-06', '2007-07', '2007-08', '2007-09', '2007-10', '2007-11', '2007-12', '2008-01', '2008-02', '2008-03', '2008-04', '2008-05', '2008-06', '2008-07', '2008-08', '2008-09', '2008-10', '2008-11', '2008-12', '2009-01', '2009-02', '2009-03', '2009-04', '2009-05', '2009-06', '2009-07', '2009-08', '2009-09', '2009-10', '2009-11', '2009-12', '2010-01', '2010-02', '2010-03', '2010-04', '2010-05', '2010-06', '2010-07', '2010-08', '2010-09', '2010-10', '2010-11', '2010-12', '2011-01', '2011-02', '2011-03', '2011-04', '2011-05', '2011-06', '2011-07', '2011-08', '2011-09', '2011-10', '2011-11', '2011-12', '2012-01', '2012-02', '2012-03', '2012-04', '2012-05', '2012-06', '2012-07', '2012-08', '2012-09', '2012-10', '2012-11', '2012-12', '2013-01', '2013-02', '2013-03', '2013-04', '2013-05', '2013-06', '2013-07', '2013-08', '2013-09', '2013-10', '2013-11', '2013-12', '2014-01', '2014-02', '2014-03', '2014-04', '2014-05', '2014-06', '2014-07', '2014-08', '2014-09', '2014-10', '2014-11', '2014-12', '2015-01', '2015-02', '2015-03', '2015-04', '2015-05', '2015-06', '2015-07']
['1999-01', '1999-02', '1999-03', '1999-04', '1999-05', '1999-06', '1999-07', '1999-08', '1999-09', '1999-10', '1999-11', '1999-12', '2000-01', '2000-02', '2000-03', '2000-04', '2000-05', '2000-06', '2000-07', '2000-08', '2000-09', '2000-10', '2000-11', '2000-12', '2001-01', '2001-02', '2001-03', '2001-04', '2001-05', '2001-06', '2001-07', '2001-08', '2001-09', '2001-10', '2001-11', '2001-12', '2002-01', '2002-02', '2002-03', '2002-04', '2002-05', '2002-06', '2002-07', '2002-08', '2002-09', '2002-10', '2002-11', '2002-12', '2003-01', '2003-02', '2003-03', '2003-04', '2003-05', '2003-06', '2003-07', '2003-08', '2003-09', '2003-10', '2003-11', '2003-12', '2004-01', '2004-02', '2004-03', '2004-04', '2004-05', '2004-06', '2004-07', '2004-08', '2004-09', '2004-10', '2004-11', '2004-12', '2005-01', '2005-02', '2005-03', '2005-04', '2005-05', '2005-06', '2005-07', '2005-08', '2005-09', '2005-10', '2005-11', '2005-12', '2006-01', '2006-02', '2006-03', '2006-04', '2006-05', '2006-06', '2006-07', '2006-08', '2006-09', '2006-10', '2006-11', '2006-12', '2007-01', '2007-02', '2007-03', '2007-04', '2007-05', '2007-06', '2007-07', '2007-08', '2007-09', '2007-10', '2007-11', '2007-12', '2008-01', '2008-02', '2008-03', '2008-04', '2008-05', '2008-06', '2008-07', '2008-08', '2008-09', '2008-10', '2008-11', '2008-12', '2009-01', '2009-02', '2009-03', '2009-04', '2009-05', '2009-06', '2009-07', '2009-08', '2009-09', '2009-10', '2009-11', '2009-12', '2010-01', '2010-02', '2010-03', '2010-04', '2010-05', '2010-06', '2010-07', '2010-08', '2010-09', '2010-10', '2010-11', '2010-12', '2011-01', '2011-02', '2011-03', '2011-04', '2011-05', '2011-06', '2011-07', '2011-08', '2011-09', '2011-10', '2011-11', '2011-12', '2012-01', '2012-02', '2012-03', '2012-04', '2012-05', '2012-06', '2012-07', '2012-08', '2012-09', '2012-10', '2012-11', '2012-12', '2013-01', '2013-02', '2013-03', '2013-04', '2013-05', '2013-06', '2013-07', '2013-08', '2013-09', '2013-10', '2013-11', '2013-12', '2014-01', '2014-02', '2014-03', '2014-04', '2014-05', '2014-06', '2014-07', '2014-08', '2014-09', '2014-10', '2014-11', '2014-12', '2015-01', '2015-02', '2015-03', '2015-04', '2015-05', '2015-06', '2015-07']










    
Out[12]:








({'M.CHF.EUR.SP00.A': ['1.6055',
   '1.5978',
   '1.5954',
   '1.6015',
   '1.6025',
   '1.5951',
   '1.604',
   '1.6004',
   '1.6015',
   '1.5943',
   '1.6051',
   '1.6012',
   '1.6103',
   '1.6069',
   '1.6042',
   '1.574',
   '1.5562',
   '1.5608',
   '1.5505',
   '1.5506',
   '1.5307',
   '1.513',
   '1.5216',
   '1.5137',
   '1.5291',
   '1.5358',
   '1.5355',
   '1.5287',
   '1.5334',
   '1.5225',
   '1.5135',
   '1.5144',
   '1.4913',
   '1.4793',
   '1.4663',
   '1.4749',
   '1.4745',
   '1.4775',
   '1.4678',
   '1.4658',
   '1.4572',
   '1.4721',
   '1.4624',
   '1.4636',
   '1.4649',
   '1.465',
   '1.4673',
   '1.4679',
   '1.4621',
   '1.4674',
   '1.4695',
   '1.4964',
   '1.5155',
   '1.5411',
   '1.5476',
   '1.54',
   '1.5474',
   '1.5485',
   '1.559',
   '1.5544',
   '1.5657',
   '1.5734',
   '1.567',
   '1.5547',
   '1.54',
   '1.5192',
   '1.527',
   '1.5387',
   '1.5431',
   '1.5426',
   '1.5216',
   '1.5364',
   '1.5469',
   '1.5501',
   '1.5494',
   '1.5475',
   '1.5449',
   '1.5391',
   '1.5578',
   '1.5528',
   '1.5496',
   '1.549',
   '1.5449',
   '1.5479',
   '1.5494',
   '1.558',
   '1.5691',
   '1.5748',
   '1.5564',
   '1.5601',
   '1.5687',
   '1.5775',
   '1.5841',
   '1.5898',
   '1.5922',
   '1.5969',
   '1.6155',
   '1.6212',
   '1.6124',
   '1.6375',
   '1.6506',
   '1.6543',
   '1.6567',
   '1.6383',
   '1.6475',
   '1.6706',
   '1.6485',
   '1.6592',
   '1.6203',
   '1.608',
   '1.572',
   '1.5964',
   '1.6247',
   '1.6139',
   '1.6193',
   '1.6212',
   '1.5942',
   '1.5194',
   '1.5162',
   '1.5393',
   '1.4935',
   '1.4904',
   '1.5083',
   '1.5147',
   '1.5118',
   '1.5148',
   '1.5202',
   '1.5236',
   '1.5148',
   '1.5138',
   '1.5105',
   '1.5021',
   '1.4765',
   '1.4671',
   '1.4482',
   '1.4337',
   '1.4181',
   '1.3767',
   '1.346',
   '1.3413',
   '1.3089',
   '1.3452',
   '1.3442',
   '1.2811',
   '1.2779',
   '1.2974',
   '1.2867',
   '1.2977',
   '1.2537',
   '1.2092',
   '1.1766',
   '1.1203',
   '1.2005',
   '1.2295',
   '1.2307',
   '1.2276',
   '1.2108',
   '1.2071',
   '1.2061',
   '1.2023',
   '1.2012',
   '1.2011',
   '1.2011',
   '1.2011',
   '1.2089',
   '1.2098',
   '1.2052',
   '1.2091',
   '1.2288',
   '1.2298',
   '1.2266',
   '1.2199',
   '1.2418',
   '1.2322',
   '1.2366',
   '1.2338',
   '1.2338',
   '1.2316',
   '1.2316',
   '1.2245',
   '1.2317',
   '1.2212',
   '1.2177',
   '1.2189',
   '1.2204',
   '1.2181',
   '1.215',
   '1.2118',
   '1.2076',
   '1.2078',
   '1.2027',
   '1.2026',
   '1.094',
   '1.0618',
   '1.0608',
   '1.0379',
   '1.0391',
   '1.0455',
   '1.0492'],
  'M.CHF.EUR.SP00.E': ['1.6123',
   '1.589',
   '1.5981',
   '1.6113',
   '1.5943',
   '1.6034',
   '1.5976',
   '1.5997',
   '1.5967',
   '1.603',
   '1.6021',
   '1.6051',
   '1.6091',
   '1.6067',
   '1.5907',
   '1.571',
   '1.5716',
   '1.5576',
   '1.5477',
   '1.5498',
   '1.524',
   '1.521',
   '1.5095',
   '1.5232',
   '1.5302',
   '1.5416',
   '1.5271',
   '1.5366',
   '1.5206',
   '1.5228',
   '1.5102',
   '1.5165',
   '1.4761',
   '1.4682',
   '1.4724',
   '1.4829',
   '1.4748',
   '1.4759',
   '1.467',
   '1.4621',
   '1.4644',
   '1.4721',
   '1.4546',
   '1.4694',
   '1.4611',
   '1.4633',
   '1.4754',
   '1.4524',
   '1.4678',
   '1.4629',
   '1.4764',
   '1.5131',
   '1.5277',
   '1.5544',
   '1.5464',
   '1.5369',
   '1.5404',
   '1.5506',
   '1.5484',
   '1.5579',
   '1.5626',
   '1.578',
   '1.5594',
   '1.5511',
   '1.5276',
   '1.5242',
   '1.5414',
   '1.5428',
   '1.5524',
   '1.5299',
   '1.5114',
   '1.5429',
   '1.5473',
   '1.5392',
   '1.5486',
   '1.5374',
   '1.5372',
   '1.5499',
   '1.5607',
   '1.5485',
   '1.5561',
   '1.5455',
   '1.5485',
   '1.5551',
   '1.5547',
   '1.5661',
   '1.5801',
   '1.5713',
   '1.56',
   '1.5672',
   '1.5713',
   '1.5751',
   '1.5881',
   '1.5887',
   '1.5916',
   '1.6069',
   '1.6214',
   '1.6136',
   '1.6247',
   '1.6458',
   '1.6477',
   '1.6553',
   '1.6519',
   '1.6451',
   '1.6601',
   '1.6762',
   '1.6541',
   '1.6547',
   '1.6051',
   '1.5885',
   '1.5738',
   '1.6147',
   '1.6276',
   '1.6056',
   '1.6354',
   '1.6164',
   '1.5774',
   '1.4686',
   '1.5455',
   '1.485',
   '1.4871',
   '1.4841',
   '1.5152',
   '1.5066',
   '1.5128',
   '1.5265',
   '1.5317',
   '1.5168',
   '1.5078',
   '1.5123',
   '1.5071',
   '1.4836',
   '1.4662',
   '1.4638',
   '1.4276',
   '1.4341',
   '1.423',
   '1.3283',
   '1.3541',
   '1.2935',
   '1.3287',
   '1.3708',
   '1.299',
   '1.2504',
   '1.2891',
   '1.284',
   '1.3005',
   '1.2867',
   '1.2275',
   '1.2071',
   '1.1418',
   '1.167',
   '1.217',
   '1.2191',
   '1.2265',
   '1.2156',
   '1.2048',
   '1.2051',
   '1.2045',
   '1.2018',
   '1.201',
   '1.203',
   '1.2014',
   '1.2009',
   '1.2099',
   '1.2076',
   '1.2054',
   '1.2072',
   '1.2342',
   '1.2209',
   '1.2195',
   '1.2238',
   '1.2406',
   '1.2338',
   '1.2317',
   '1.231',
   '1.2225',
   '1.2333',
   '1.2298',
   '1.2276',
   '1.222',
   '1.2153',
   '1.2194',
   '1.22',
   '1.2204',
   '1.2156',
   '1.2169',
   '1.2061',
   '1.2063',
   '1.2067',
   '1.2018',
   '1.2024',
   '1.0468',
   '1.0636',
   '1.0463',
   '1.0486',
   '1.0341',
   '1.0413',
   '1.0565']},
 {'M.CHF.EUR.SP00.A': ['1999-01',
   '1999-02',
   '1999-03',
   '1999-04',
   '1999-05',
   '1999-06',
   '1999-07',
   '1999-08',
   '1999-09',
   '1999-10',
   '1999-11',
   '1999-12',
   '2000-01',
   '2000-02',
   '2000-03',
   '2000-04',
   '2000-05',
   '2000-06',
   '2000-07',
   '2000-08',
   '2000-09',
   '2000-10',
   '2000-11',
   '2000-12',
   '2001-01',
   '2001-02',
   '2001-03',
   '2001-04',
   '2001-05',
   '2001-06',
   '2001-07',
   '2001-08',
   '2001-09',
   '2001-10',
   '2001-11',
   '2001-12',
   '2002-01',
   '2002-02',
   '2002-03',
   '2002-04',
   '2002-05',
   '2002-06',
   '2002-07',
   '2002-08',
   '2002-09',
   '2002-10',
   '2002-11',
   '2002-12',
   '2003-01',
   '2003-02',
   '2003-03',
   '2003-04',
   '2003-05',
   '2003-06',
   '2003-07',
   '2003-08',
   '2003-09',
   '2003-10',
   '2003-11',
   '2003-12',
   '2004-01',
   '2004-02',
   '2004-03',
   '2004-04',
   '2004-05',
   '2004-06',
   '2004-07',
   '2004-08',
   '2004-09',
   '2004-10',
   '2004-11',
   '2004-12',
   '2005-01',
   '2005-02',
   '2005-03',
   '2005-04',
   '2005-05',
   '2005-06',
   '2005-07',
   '2005-08',
   '2005-09',
   '2005-10',
   '2005-11',
   '2005-12',
   '2006-01',
   '2006-02',
   '2006-03',
   '2006-04',
   '2006-05',
   '2006-06',
   '2006-07',
   '2006-08',
   '2006-09',
   '2006-10',
   '2006-11',
   '2006-12',
   '2007-01',
   '2007-02',
   '2007-03',
   '2007-04',
   '2007-05',
   '2007-06',
   '2007-07',
   '2007-08',
   '2007-09',
   '2007-10',
   '2007-11',
   '2007-12',
   '2008-01',
   '2008-02',
   '2008-03',
   '2008-04',
   '2008-05',
   '2008-06',
   '2008-07',
   '2008-08',
   '2008-09',
   '2008-10',
   '2008-11',
   '2008-12',
   '2009-01',
   '2009-02',
   '2009-03',
   '2009-04',
   '2009-05',
   '2009-06',
   '2009-07',
   '2009-08',
   '2009-09',
   '2009-10',
   '2009-11',
   '2009-12',
   '2010-01',
   '2010-02',
   '2010-03',
   '2010-04',
   '2010-05',
   '2010-06',
   '2010-07',
   '2010-08',
   '2010-09',
   '2010-10',
   '2010-11',
   '2010-12',
   '2011-01',
   '2011-02',
   '2011-03',
   '2011-04',
   '2011-05',
   '2011-06',
   '2011-07',
   '2011-08',
   '2011-09',
   '2011-10',
   '2011-11',
   '2011-12',
   '2012-01',
   '2012-02',
   '2012-03',
   '2012-04',
   '2012-05',
   '2012-06',
   '2012-07',
   '2012-08',
   '2012-09',
   '2012-10',
   '2012-11',
   '2012-12',
   '2013-01',
   '2013-02',
   '2013-03',
   '2013-04',
   '2013-05',
   '2013-06',
   '2013-07',
   '2013-08',
   '2013-09',
   '2013-10',
   '2013-11',
   '2013-12',
   '2014-01',
   '2014-02',
   '2014-03',
   '2014-04',
   '2014-05',
   '2014-06',
   '2014-07',
   '2014-08',
   '2014-09',
   '2014-10',
   '2014-11',
   '2014-12',
   '2015-01',
   '2015-02',
   '2015-03',
   '2015-04',
   '2015-05',
   '2015-06',
   '2015-07'],
  'M.CHF.EUR.SP00.E': ['1999-01',
   '1999-02',
   '1999-03',
   '1999-04',
   '1999-05',
   '1999-06',
   '1999-07',
   '1999-08',
   '1999-09',
   '1999-10',
   '1999-11',
   '1999-12',
   '2000-01',
   '2000-02',
   '2000-03',
   '2000-04',
   '2000-05',
   '2000-06',
   '2000-07',
   '2000-08',
   '2000-09',
   '2000-10',
   '2000-11',
   '2000-12',
   '2001-01',
   '2001-02',
   '2001-03',
   '2001-04',
   '2001-05',
   '2001-06',
   '2001-07',
   '2001-08',
   '2001-09',
   '2001-10',
   '2001-11',
   '2001-12',
   '2002-01',
   '2002-02',
   '2002-03',
   '2002-04',
   '2002-05',
   '2002-06',
   '2002-07',
   '2002-08',
   '2002-09',
   '2002-10',
   '2002-11',
   '2002-12',
   '2003-01',
   '2003-02',
   '2003-03',
   '2003-04',
   '2003-05',
   '2003-06',
   '2003-07',
   '2003-08',
   '2003-09',
   '2003-10',
   '2003-11',
   '2003-12',
   '2004-01',
   '2004-02',
   '2004-03',
   '2004-04',
   '2004-05',
   '2004-06',
   '2004-07',
   '2004-08',
   '2004-09',
   '2004-10',
   '2004-11',
   '2004-12',
   '2005-01',
   '2005-02',
   '2005-03',
   '2005-04',
   '2005-05',
   '2005-06',
   '2005-07',
   '2005-08',
   '2005-09',
   '2005-10',
   '2005-11',
   '2005-12',
   '2006-01',
   '2006-02',
   '2006-03',
   '2006-04',
   '2006-05',
   '2006-06',
   '2006-07',
   '2006-08',
   '2006-09',
   '2006-10',
   '2006-11',
   '2006-12',
   '2007-01',
   '2007-02',
   '2007-03',
   '2007-04',
   '2007-05',
   '2007-06',
   '2007-07',
   '2007-08',
   '2007-09',
   '2007-10',
   '2007-11',
   '2007-12',
   '2008-01',
   '2008-02',
   '2008-03',
   '2008-04',
   '2008-05',
   '2008-06',
   '2008-07',
   '2008-08',
   '2008-09',
   '2008-10',
   '2008-11',
   '2008-12',
   '2009-01',
   '2009-02',
   '2009-03',
   '2009-04',
   '2009-05',
   '2009-06',
   '2009-07',
   '2009-08',
   '2009-09',
   '2009-10',
   '2009-11',
   '2009-12',
   '2010-01',
   '2010-02',
   '2010-03',
   '2010-04',
   '2010-05',
   '2010-06',
   '2010-07',
   '2010-08',
   '2010-09',
   '2010-10',
   '2010-11',
   '2010-12',
   '2011-01',
   '2011-02',
   '2011-03',
   '2011-04',
   '2011-05',
   '2011-06',
   '2011-07',
   '2011-08',
   '2011-09',
   '2011-10',
   '2011-11',
   '2011-12',
   '2012-01',
   '2012-02',
   '2012-03',
   '2012-04',
   '2012-05',
   '2012-06',
   '2012-07',
   '2012-08',
   '2012-09',
   '2012-10',
   '2012-11',
   '2012-12',
   '2013-01',
   '2013-02',
   '2013-03',
   '2013-04',
   '2013-05',
   '2013-06',
   '2013-07',
   '2013-08',
   '2013-09',
   '2013-10',
   '2013-11',
   '2013-12',
   '2014-01',
   '2014-02',
   '2014-03',
   '2014-04',
   '2014-05',
   '2014-06',
   '2014-07',
   '2014-08',
   '2014-09',
   '2014-10',
   '2014-11',
   '2014-12',
   '2015-01',
   '2015-02',
   '2015-03',
   '2015-04',
   '2015-05',
   '2015-06',
   '2015-07']},
 {'M.CHF.EUR.SP00.A': {'OBS_STATUS': 'A'},
  'M.CHF.EUR.SP00.E': {'OBS_STATUS': 'A'}},
 {'M.CHF.EUR.SP00.A': OrderedDict([('FREQ', 'M'), ('CURRENCY', 'CHF'), ('CURRENCY_DENOM', 'EUR'), ('EXR_TYPE', 'SP00'), ('EXR_SUFFIX', 'A')]),
  'M.CHF.EUR.SP00.E': OrderedDict([('FREQ', 'M'), ('CURRENCY', 'CHF'), ('CURRENCY_DENOM', 'EUR'), ('EXR_TYPE', 'SP00'), ('EXR_SUFFIX', 'E')])})

The method for retrieving the available dimensions is very buggy though. I am working on it. We can't expect from the user to know by heart that there are dimensions called CURRENCY or FREQ. Anyway, it works.

Content source: mmalter/pysdmx

Similar notebooks:

notebook.community | gallery | about