Read covid data (json)

Newbie
1

Hi,
I wonder if there is any tool to convert https://covid.ourworldindata.org/data/owid-covid-data.json
to ROOT tree?

Thanks
Regards. Valeriy

_ROOT Version:git head
_Platform:windows
_Compiler:vs2019 head

2

This was discussed on this forum already for instance here.

3

Thanks Olivier.
Can it be done in more “automatic way”?

The problem:

  1. one day covid data is 57 Mbytes plane table
    covid-19-data/owid-covid-codebook.csv (json scheema)

  2. for ~2 years = (57 Mb)x(700 days) ~ 40 Gb of raw data
    an automatic sequential (read JSON)/(write ROOT) proc desperately needed.

  3. it would be nice to have an automatic bot to update this output ROOT file daily.

Any ideas?
Valeriy

++
If there is a brave volunteer who will not afraid of this boring job? :slight_smile:

4

I do not know. May be @linev has some ideas.

5

Hi Valeriy,

ROOT does not provide generic reader of JSON data into TTree - although
internally we do use JSON parser but only for ROOT-created JSON structures. In principle, one could implement this and any volunteer is welcome.

Regards,
Sergey

6

Hi Sergey,
after 2006 when I was a ROOT evangelist I’m for a long time a C# and Kotlin guy. There is Newtonsoft.Json and async HttpClient which can do Get->Parse->Deserialize JSON quite easy.
If there are any news about interop C#(PowerShell) <-> ROOT bridge?
I know about ROOT.NET: Build .NET wrappers for the ROOT scientific data analysis toolkit (github.com) but not sure if it helps.

Valeriy

++
Sergey, Bertrand, could describe the status and progress of JSROOT development?

Recently I found very useful guide on it at
ROOT: documentation/JSROOT/JSROOT.md | Fossies
BUT unfortunately I do not see anything similar to it on the main ROOT site. It’s a pity.

7

Hi Valeriy,

With some effort one should be able to find link on root.cern site:

https://root.cern/root/htmldoc/guides/JSROOT/JSROOT.html

But up-to-date source is in repository:

https://github.com/root-project/jsroot/blob/master/docs/JSROOT.md

Regards,
Sergey

8

Hi Valeriy,
The ROOT related manual can be found here: Topical Manuals - ROOT
We will revisit this soon.
Cheers,
Olivier

9

I just found out that this page had no proper JSROOT link.
I add proper link now.

1 Like
10

Thanks.
it was not easy to find it :frowning:
I suggest to put JSROOT demos directly to
Galleries of images produced with ROOT - ROOT
and to add the link to the guide directly there
JavaScript ROOT

11

I am not sure about the JSROOT galerie… but why not.

12

he-he … :slight_smile:
the whole covid data for all countries for the period
from 2020-02-14 to 2021-07-07 weights only ~57 Mbytes.

I’m going to prepare PowerShell7&ROOT scripts
which will put the whole covid data to the ROOT tree/file.

PowerShell7 can run on windows, linux, mac osx and Android.

btw, is it possible to run ROOT on smartphones, tablets
with Android on board?