Skip to main content

entity - What is the syntax for `EntityProperty` `"Date"` and `"DateRange"` Qualifiers?


Does anyone know how to get EntityProperty "Date" and "DateRange" qualifiers to return data?


It seems reasonable that you should be able to use the DateRange function parameters on the "DateRange" qualifier. Sadly that does not seem to be the case.


CountryData["UnitedStates", 
  EntityProperty["Country", "InflationRate", 
   {"DateRange" -> {DateObject@{1980, 12, 31}, DateObject@{2017, 12, 31}, "Year"}, 
    "Frequency" -> "Annual"}]]


It also seems reasonable that you should be able to pass a list of DateObjects to a "Date" qualifier but sadly that too does not seem to be the case.


CountryData["UnitedStates", 
  EntityProperty["Country", "InflationRate", 
   {"Date" -> DateRange[DateObject@{1980, 12, 31}, DateObject@{2017, 12, 31}, "Year"], 
    "Frequency" -> "Annual"}]]

So how are these qualifiers specified. No hints are given in the "QualifierValues" entity property either.



I have since tried a few additional methods with no luck.



The very inefficient mapping over each date which produces multiple internet calls to WRI entity server. This produces a large jumble of an error without an error message.


CountryData["UnitedStates",
   EntityProperty["Country", 
    "InflationRate", {"Date" -> #, "Frequency" -> "Annual"}]] & /@ 
 DateRange[DateObject@{1980, 12, 31}, DateObject@{2017, 12, 31}, "Year"]


Mathematica graphics



Also tried using Dated to see if it would avoid this error. All calls fail with this method.



CountryData["UnitedStates",
   Dated[EntityProperty["Country", 
     "InflationRate", {"Frequency" -> "Annual"}], #]] & /@ 
 DateRange[DateObject@{1980, 12, 31}, DateObject@{2017, 12, 31}, "Year"]


Mathematica graphics



I think these two may be bugs. Well, definitely the first one. I might be using Dated wrong in the second but the syntax seems to conform.



Answer




Interval seems to be the right way to specify a date range for an EntityValue call on a "Country" entity. Using Ctrl-="US inflation rate from 1999 to 2010" to query for the linguistics, gives a returned expression,


Entity["Country", "UnitedStates"][
 EntityProperty["Country", "Inflation", 
     {"Date" -> Interval[{DateObject[{1999}], DateObject[{2010}]}], 
       "Frequency" -> "Monthly", 
   "SeasonalAdjustment" -> "NotSeasonallyAdjusted"}]]

This shows the syntax for a date range for this property is Interval[{__DateObject}]


This is a good use case for EntityInstance,


entity = 

 EntityInstance[
  Entity["Country", 
   "UnitedStates"], {"Date" -> 
    Interval[{DateObject[{1978}], DateObject[{2010}]}]}]

Then query for properties,


entity["InflationRate"]
(* Quantity[250.686, "Percent"] *)

entity["Inflation"]


enter image description here


DateListPlot@%

enter image description here


Comments

Post a Comment

Popular posts from this blog

functions - Get leading series expansion term?

Given a function f[x] , I would like to have a function leadingSeries that returns just the leading term in the series around x=0 . For example: leadingSeries[(1/x + 2)/(4 + 1/x^2 + x)] x and leadingSeries[(1/x + 2 + (1 - 1/x^3)/4)/(4 + x)] -(1/(16 x^3)) Is there such a function in Mathematica? Or maybe one can implement it efficiently? EDIT I finally went with the following implementation, based on Carl Woll 's answer: lds[ex_,x_]:=( (ex/.x->(x+O[x]^2))/.SeriesData[U_,Z_,L_List,Mi_,Ma_,De_]:>SeriesData[U,Z,{L[[1]]},Mi,Mi+1,De]//Quiet//Normal) The advantage is, that this one also properly works with functions whose leading term is a constant: lds[Exp[x],x] 1 Answer Update 1 Updated to eliminate SeriesData and to not return additional terms Perhaps you could use: leadingSeries[expr_, x_] := Normal[expr /. x->(x+O[x]^2) /. a_List :> Take[a, 1]] Then for your examples: leadingSeries[(1/x + 2)/(4 + 1/x^2 + x), x] leadingSeries[Exp[x], x] leadingSeries[(1/x + 2 + (1 - 1/x...
Post a Comment
Read more

How to thread a list

I have data in format data = {{a1, a2}, {b1, b2}, {c1, c2}, {d1, d2}} Tableform: I want to thread it to : tdata = {{{a1, b1}, {a2, b2}}, {{a1, c1}, {a2, c2}}, {{a1, d1}, {a2, d2}}} Tableform: And I would like to do better then pseudofunction[n_] := Transpose[{data2[[1]], data2[[n]]}]; SetAttributes[pseudofunction, Listable]; Range[2, 4] // pseudofunction Here is my benchmark data, where data3 is normal sample of real data. data3 = Drop[ExcelWorkBook[[Column1 ;; Column4]], None, 1]; data2 = {a #, b #, c #, d #} & /@ Range[1, 10^5]; data = RandomReal[{0, 1}, {10^6, 4}]; Here is my benchmark code kptnw[list_] := Transpose[{Table[First@#, {Length@# - 1}], Rest@#}, {3, 1, 2}] &@list kptnw2[list_] := Transpose[{ConstantArray[First@#, Length@# - 1], Rest@#}, {3, 1, 2}] &@list OleksandrR[list_] := Flatten[Outer[List, List@First[list], Rest[list], 1], {{2}, {1, 4}}] paradox2[list_] := Partition[Riffle[list[[1]], #], 2] & /@ Drop[list, 1] RM[list_] := FoldList[Transpose[{First@li...
Post a Comment
Read more

front end - keyboard shortcut to invoke Insert new matrix

I frequently need to type in some matrices, and the menu command Insert > Table/Matrix > New... allows matrices with lines drawn between columns and rows, which is very helpful. I would like to make a keyboard shortcut for it, but cannot find the relevant frontend token command (4209405) for it. Since the FullForm[] and InputForm[] of matrices with lines drawn between rows and columns is the same as those without lines, it's hard to do this via 3rd party system-wide text expanders (e.g. autohotkey or atext on mac). How does one assign a keyboard shortcut for the menu item Insert > Table/Matrix > New... , preferably using only mathematica? Thanks! Answer In the MenuSetup.tr (for linux located in the $InstallationDirectory/SystemFiles/FrontEnd/TextResources/X/ directory), I changed the line MenuItem["&New...", "CreateGridBoxDialog"] to read MenuItem["&New...", "CreateGridBoxDialog", MenuKey["m", Modifiers-...
Post a Comment
Read more