Stack Overflow
Stack Overflow

Questions tagged [sdmx]

Statistical Data and Metadata eXchange

Official site: https://sdmx.org/

Tools

Listed on official site: https://sdmx.org/?page_id=4500

Listed on GitHub: https://github.com/search?utf8=%E2%9C%93&q=sdmx

46 questions
0
votes
2 answers

Cannot read Statistics Canada sdmx file

I am trying to read some Canadian census data from Statistics Canada (the XML option for the "Canada, provinces and territories" geograpic level). I see that the xml file is in the SDMX format and that there is a structure file provided, but I…
ramesesjd
  • 181
  • 1
  • 11
0
votes
1 answer

how to download data from ECB using pandaSDMX?

I am trying to download the NEER data from this target page. Here is a good example:Most efficient way of converting RESTful output to dataframe Here is the code to get the OECD data. import pandasdmx as sdmx df = sdmx.Request('OECD').data( …
ERIC
  • 460
  • 6
  • 16
0
votes
1 answer

How to set attributes in pandasdmx

The "pandasdmx" documentation has an example of how to set dimensions, but no how to set attributes. I tried passing "key" to the variable, but an error occurs. Perhaps setting attributes requires a different syntax? At the end of my sample code, I…
inquirer
  • 4,286
  • 2
  • 9
  • 16
0
votes
1 answer

How can i access ECB Dataflow? TooManyRedirects: Exceeded 30 redirects

I am using Request package form pandasdmx library to to access some exchange rates from the European Central Bank. I tried to follow the stepts highlighted in the following walkthrough: https://pandasdmx.readthedocs.io/en/v1.0/walkthrough.html# bur…
Guillermo Cambronero Pérez
  • 57
  • 5
0
votes
2 answers

How to transform JSON International Financial Statistics into pandas data frame

I am struggling with data from the International Monetary Fund, which is in JSON format. After inspecting some of the posts, I couldn't figure out how to do it. What I tried import requests import pandas as pd import json # These are the variables…
Jorge Alonso
  • 103
  • 11
0
votes
0 answers

SPARQL query on sdmx-dimension:refPeriod

I'm trying to run a SPARQL query on sdmx-dimension:refPeriod in order to get the date. The triple that contains the date is in the format: exp:obs0 sdmx-dimension:refPeriod exp:2020-08-03 so when I go to extract the date with: SELECT ?date WHERE…
iacopo pacifici
  • 13
  • 1
  • 5
0
votes
2 answers

pandasdmx: sdmx.Request leading to SSL Error - bad handshake

I am using the pandasdmx library and would like to access the IMF datasource. The following code produces a SSLError. from pathlib import Path import pandasdmx as sdmx http_proxy = "my/proxy_server/address" proxies = { "http": http_proxy, …
Andi
  • 3,196
  • 2
  • 24
  • 44
0
votes
1 answer

How to get data from Australia Bureau of Statistics using pandasmdx

Is there anyone who got ABS data using pandasmsdx library? Here is the code to get data from European Central Bank (ECB) which is working. from pandasdmx import Request ecb = Request('ECB') flow_response =…
Jaliya
  • 337
  • 5
  • 20
0
votes
1 answer

Create Proper Dataframe from SDMX Response, Python 3.6

I want to prepare dataset from the data available in http://stat.data.abs.gov.au/Index.aspx?DataSetCode=ATSI_BIRTHS_SUMM Data API:…
Learnings
  • 2,780
  • 9
  • 35
  • 55
0
votes
1 answer

Download data from UnData of ONU

I want to know the population of some countries over the period 1960-2015. I found this site that contains this data and I'm interested in downloading it using Node.js. I read that there are some APIs but I didn't understand how to use them. I went…
user3808470
0
votes
1 answer

UNESCO SDMX api data into pandas DataFrame

I am trying to download a table from the UNESCO data api and transform it into a pandas DataFrame. So far I arrived this far: from pandasdmx import Request as rq auth = {'Ocp-Apim-Subscription-Key': '...'} uis = rq('unesco', headers =…
nocibambi
  • 2,065
  • 1
  • 16
  • 22
0
votes
0 answers

SDMX-ML: SAS libname XML

Eurostat data can be downloaded via a REST API. The response format of the API is a XML file formatted according to the SDMX-ML standard. With SAS, very conveniently, one can access XML files with the libname statement and the XML or XMLv2…
Johannes Bleher
  • 321
  • 3
  • 15
0
votes
3 answers

Reading oddly formatter CSV file

I'm looking at downloading some data from the statistics.gov.scot website. For example, I would like to source some data on the rates of hospital admissions. The query to source the data table I'm interested in is of…
Konrad
  • 17,740
  • 16
  • 106
  • 167
0
votes
0 answers

Convert XML document to MATLAB

I want to convert a XML document to a useful matlab object which can iterate through the nodes to fetch information. The XML document is a bit complicated look like this: