How to save multiple values of a variable in a json file in R
I have had success using the fromJSON() function in the rjson package.
On Thu, Jan 16, 2020 at 4:22 PM Ioanna Ioannou <ii54250 at msn.com> wrote:
hello everyone,
and happy new year!
I have this problem: I want to save the name of the 'countries', the
'taxonomy_gem' and the 'minimum_im' and 'maximum_im' . The problem is that
there are several names of countries. How can i transfer the information
from the json file to an R data.frame? See below for the json file.
Best,
ioanna
{
"pk": 670,
"model": "vulnerability.generalinformation",
"fields": {
"category": "Structure class",
"article_title": "A GLOBAL DATABASE OF VULNERABILITY MODELS FOR
SEISMIC RISK ASSESSMENT",
"name": "CR/LFINF/DUL/H:2",
"publication_conference_name": "16EECE",
"llrs": null,
"material": null,
"web_link": "",
"owner": {
"pk": 1900,
"model": "people.profile",
"fields": {
"username": "lmartins",
"first_name": "",
"last_name": "",
"email": "luis.martins at globalquakemodel.org"
}
},
"general_comments": "",
"geo_applicability": {
"pk": 669,
"model": "vulnerability.geoapplicability",
"fields": {
"general_information": 670,
"area": "",
"countries": [
{
"pk": "CIV",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Cte d'Ivoire"
}
},
{
"pk": "CMR",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Cameroon"
}
},
{
"pk": "SDN",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Sudan"
}
},
{
"pk": "SSD",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "South Sudan"
}
},
{
"pk": "TUN",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Tunisia"
}
},
{
"pk": "TGO",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Togo"
}
},
{
"pk": "ZAF",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "South Africa"
}
},
{
"pk": "NER",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Niger"
}
},
{
"pk": "MAR",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Morocco"
}
},
{
"pk": "KEN",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Kenya"
}
},
{
"pk": "SYC",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Seychelles"
}
},
{
"pk": "ESH",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Western Sahara"
}
},
{
"pk": "SHN",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Saint Helena"
}
},
{
"pk": "REU",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Reunion"
}
},
{
"pk": "SLE",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Sierra Leone"
}
},
{
"pk": "DJI",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Djibouti"
}
},
{
"pk": "STP",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Sao Tome and Principe"
}
},
{
"pk": "BDI",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Burundi"
}
},
{
"pk": "MLI",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Mali"
}
},
{
"pk": "GMB",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Gambia"
}
},
{
"pk": "ZMB",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Zambia"
}
},
{
"pk": "RWA",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Rwanda"
}
},
{
"pk": "MWI",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Malawi"
}
},
{
"pk": "BFA",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Burkina Faso"
}
},
{
"pk": "GAB",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Gabon"
}
},
{
"pk": "TCD",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Chad"
}
},
{
"pk": "SEN",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Senegal"
}
},
{
"pk": "NAM",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Namibia"
}
},
{
"pk": "ATF",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "French Southern Territories"
}
},
{
"pk": "BWA",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Botswana"
}
},
{
"pk": "TZA",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Tanzania"
}
},
{
"pk": "ERI",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Eritrea"
}
},
{
"pk": "MYT",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Mayotte"
}
},
{
"pk": "SOM",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Somalia"
}
},
{
"pk": "UGA",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Uganda"
}
},
{
"pk": "LSO",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Lesotho"
}
},
{
"pk": "LBY",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Libya"
}
},
{
"pk": "LBR",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Liberia"
}
},
{
"pk": "COD",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Democratic Republic of the Congo"
}
},
{
"pk": "CPV",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Cape Verde"
}
},
{
"pk": "CAF",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Central African Republic"
}
},
{
"pk": "COM",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Comoros"
}
},
{
"pk": "ETH",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Ethiopia"
}
},
{
"pk": "GIN",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Guinea"
}
},
{
"pk": "COG",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Republic of Congo"
}
},
{
"pk": "GHA",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Ghana"
}
},
{
"pk": "SWZ",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Swaziland"
}
},
{
"pk": "GNB",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Guinea-Bissau"
}
},
{
"pk": "MDG",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Madagascar"
}
},
{
"pk": "ZWE",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Zimbabwe"
}
},
{
"pk": "MOZ",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Mozambique"
}
},
{
"pk": "MRT",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Mauritania"
}
},
{
"pk": "MUS",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Mauritius"
}
},
{
"pk": "NGA",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Nigeria"
}
},
{
"pk": "BEN",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Benin"
}
},
{
"pk": "GNQ",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Equatorial Guinea"
}
},
{
"pk": "EGY",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Egypt"
}
},
{
"pk": "AGO",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Angola"
}
},
{
"pk": "DZA",
"model": "vulnerability.country",
"fields": {
"is_visible": true,
"region": 2,
"name": "Algeria"
}
}
],
"lon": null,
"address": "",
"lat": null
}
},
"authors": "Martins and Silva",
"use_case_information": "",
"structure_type": "Building",
"taxonomy_gem":
"DX+D99/MAT99/L99/DY+D99/MAT99/L99/H99/Y99/OC99/BP99/PLF99/IR99/EW99/RSH99+RMT99+R99+RWC99/F99+FWC99/FOS99",
"year": 2018,
"type_of_assessment": "Vulnerability",
"taxonomy_type": {
"pk": 1,
"model": "vulnerability.taxonomytype",
"fields": {
"user_def": false,
"name": "GEM"
}
},
"taxonomy_text": "",
"vulnerability_func": {
"pk": 30,
"model": "vulnerability.vulnerabilityfunc",
"fields": {
"general_information": 670,
"predictor_var": {
"pk": 602,
"model": "vulnerability.predictorvar",
"fields": {
"type_of_period": "Telastic (s)",
"minimum_im": 0.05,
"intensity_measure_type": "Sa(T)",
"fragility_func": null,
"period": 0.3,
"vulnerability_func": 30,
"maximum_im": 8,
"intensity_measure_unit": "g"
}
},
"func_distr_vuln_discr": {
"pk": 23,
"model": "vulnerability.funcdistrvulndiscr",
"fields": {
"resp_var_mean_val":
"0.000025;0.000033;0.000045;0.000059;0.000078;0.000101;0.000131;0.00017;0.000217;0.000277;0.00035;0.00044;0.000551;0.000684;0.000844;0.001036;0.001264;0.001532;0.001846;0.002212;0.002635;0.003121;0.003676;0.004306;0.005016;0.005812;0.006701;0.007685;0.008772;0.009966;0.01127;0.012691;0.014233;0.0159;0.0177;0.019639;0.021726;0.023972;0.026388;0.028991;0.0318;0.034838;0.038132;0.041714;0.04562;0.049893;0.05458;0.059733;0.065409;0.07167;0.078582;0.086213;0.094633;0.103913;0.114125;0.125335;0.13761;0.151007;0.165578;0.181366;0.1984;0.216699;0.236266;0.257091;0.279144;0.302379;0.326733;0.352124;0.378455;0.40561;0.433459;0.461862;0.490663;0.519703;0.548813;0.577824;0.606566;0.634874;0.662589;0.68956;0.715649;0.740732;0.764702;0.787467;0.808956;0.829114;0.847907;0.865317;0.881347;0.896012;0.909344;0.921388;0.932199;0.941842;0.950388;0.957913;0.964497;0.97022;0.975163;0.979405",
"resp_var_val_coeff": "",
"predictor_var_im_val":
"0.05;0.05263;0.055398;0.058312;0.06138;0.064608;0.068007;0.071584;0.07535;0.079313;0.083485;0.087876;0.092499;0.097364;0.102486;0.107877;0.113551;0.119524;0.125811;0.132429;0.139395;0.146727;0.154445;0.162569;0.171121;0.180122;0.189596;0.199569;0.210067;0.221117;0.232748;0.24499;0.257877;0.271442;0.28572;0.300749;0.316569;0.333221;0.350749;0.369198;0.388619;0.40906;0.430577;0.453226;0.477066;0.502161;0.528575;0.556379;0.585645;0.61645;0.648876;0.683008;0.718935;0.756752;0.796558;0.838458;0.882561;0.928985;0.977851;1.029287;1.083429;1.140418;1.200405;1.263548;1.330012;1.399972;1.473613;1.551126;1.632717;1.7186;1.809;1.904156;2.004317;2.109746;2.220721;2.337534;2.460491;2.589915;2.726148;2.869546;3.020488;3.179369;3.346607;3.522643;3.707938;3.902979;4.108281;4.324381;4.551848;4.791281;5.043307;5.308591;5.587829;5.881755;6.191142;6.516804;6.859595;7.220418;7.60022;8",
"vulnerability_func": 30,
"func_distr_shape": null,
"data_pts_num": 100
}
},
"method_of_estimation": "Analytical",
"func_distr_type": "Discrete",
"resp_var": "Damage factor"
}
}
}
}
[[alternative HTML version deleted]]
______________________________________________ R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.