Thursday, December 26, 2019

Exercises with External and Internal Data Files


tem=Import["ExampleData/temperatures.json"];
DateListPlot[Table[{DateList[DateObject[StringJoin["20",
StringTake[Keys[tem][[i]],7;;8],
StringTake[Keys[tem][[i]],1;;2],
StringTake[Keys[tem][[i]],4;;5]],
   DateFormat->{"Year","/","Month","/","Day"}]][[1;;3]],
Values[tem[[i]]]},{i,31}],ColorFunction->"TemperatureMap",
ImageSize->400, GridLines->True]
path="https://data.cityofnewyork.us/resource/";
SE=Import[StringJoin[path,"h7rb-945c.json"],HeaderLines->1];
FL=Keys[SE][[1,{1,26,75,79,80,82,34,35}]]; FL[[1;;5]]
Table[Values[SE[[i,{1,26,75,79,80,82,34,35}]]],{i,1}]


No comments:

Post a Comment