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
1
vote
0 answers

Read SDMX into a Dataframe R

I am struggling with using readSDMX into a dataframe. My code is below, along with the error. Any help on this would be greatly appreciated. This is my first time using the RSDMX library, so pretty new to this.Thanks in advance! tmp <-…
1
vote
1 answer

XML SDMX reading in python

Im strugling to read SDMX XML file with python from below links: https://www.newyorkfed.org/xml/fedfunds.html or direct Ideally i would like to get fund rates into dataframe but i was trying to use pandasdmx which doesnt seem to work with this…
Drac0
  • 101
  • 1
  • 2
  • 12
1
vote
1 answer

SDMX-Json Parsing - No Time_Period problem - OECD Dataset python extract

I am using the python library pandaSDMX to extract entire datasets from the OECD database, and convert them to a CSV format (any readable format would be OK, because I want to put the final output in an SQL database). To have access to a OECD…
1
vote
1 answer

Fetching data from OECD into R via SDMX(XML)

I want to extract data from the OECD website particularily the dataset "REGION_ECONOM" with the dimensions "GDP" (GDP of the respective regions) and "POP_AVG" (the average population of the respective region). This is the first time I am doing this:…
Luna
  • 47
  • 1
  • 5
1
vote
1 answer

How to read IMF xls- or sdmx-data from url?

From the IMF I want to read a .xls file from an URL directly into R, but all attempts fail so far. Weirdly, I can download the file manually or by download.file() and open it without problems in Microsoft Outlook or in a text editor. However, even…
jay.sf
  • 60,139
  • 8
  • 53
  • 110
1
vote
1 answer

SDMX to dataframe with RSDMX in R

I'm trying to get data from the Lithuanian Statistics Department. They offer SDMX API with either XML or JSON (LSD). The example XML shown is : https://osp-rs.stat.gov.lt/rest_xml/data/S3R629_M3010217 which downloads the XML file. I tried…
Justas Mundeikis
  • 935
  • 1
  • 10
  • 19
1
vote
0 answers

readSDMX to data.frame results in NULL?

I can't seem to get my rsdmx results to convert into a data frame. All the help tutorials I can find parrot the same thing, but when I try it I get a NULL df. There's data coming from my readSDMX, but as.data.frame results in NULL. What am I…
AJDncnsn
  • 53
  • 1
  • 5
1
vote
1 answer

how to parse sdmx file in c#?

I am trying to parse the following page: http://sdw-wsrest.ecb.europa.eu/service/data/YC/B.U2.EUR.4F.G_N_A.SV_C_YM.BETA0+BETA1+BETA2+BETA3+TAU1+TAU2?lastNObservations=1 in order to get the value of BETA0, BETA1, etc.... I am struggling as it…
akasolace
  • 572
  • 1
  • 5
  • 17
1
vote
1 answer

Best way of 'automating data' from Statistics Sweden to Excel?

This question hopefully serves as a purpose for other general questions of using SDMX/JSON or other request types of achieving data requests into excel. I am new to this sort of data request, but was wondering how data could be pulled in a…
Curious Student
  • 669
  • 4
  • 13
  • 25
1
vote
1 answer

Python BS4 with SDMX

I would like to retrieve data given in a SDMX file (like https://www.bundesbank.de/cae/servlet/StatisticDownload?tsId=BBK01.ST0304&its_fileFormat=sdmx&mode=its). I tried to use BeautifulSoup, but it seems, it does not see the tags. In the following…
Daniel
  • 304
  • 2
  • 12
1
vote
1 answer

Eurostat SDMX dataflow description python

Using python I want to collect a list of all possible dataflows from Eurostat. I have the following code; from pandasdmx import Request as rq estat=rq('ESTAT') cat_rsp=estat.get(resource_type='dataflow') cat_msg=cat_rsp.msg print [i.encode('utf-8')…
Nikki101
  • 69
  • 2
  • 8
1
vote
1 answer

Eurostat Bulk SDMX data download into R?

I'm having some troubles trying to download bulk data from Eurostat, hope that you can help me out. I based my code from this post. library(devtools) require(devtools) install_github("rsdmx", "opensdmx") require(rsdmx) # Make a temporary file (tf)…
Mario GS
  • 859
  • 8
  • 22
0
votes
0 answers

Obtain Euribor Rates with ECB SDMX Rest API

I need to obtain the euribor rate for 3 months with the ECB SDMX REST API (https://sdw-wsrest.ecb.europa.eu/help/) in node. Which URL should I use? I tried to use this…
Cláudia
  • 45
  • 1
  • 6
0
votes
1 answer

R+Java+RJSDMX and Updating Certificates on Debian Stable

I run debian stable on several boxes. This morning I installed some security updates affecting Java on different boxes. The problem is that now I have some issues in using RJSDMX on one of them, despite they all having similar…
larry77
  • 1,309
  • 14
  • 29
0
votes
1 answer

Pandasdmx fails because DataflowDefinition contains underscore

I am trying to use Python to extract data from a sdmx file using the walkthrough [example][1] The code below should do the trick, but the DataflowDefinition is a series of digits and results in a syntax error. I assumed it could have been the…
Rosario
  • 183
  • 1
  • 11