OxfordIHTM / ihtm-hackathon-2024

Oxford IHTM Hackathon 2024
1 stars 0 forks source link

create a single `data.frame` that has admissions data, defaulter data, and performance indicators per state per month #71

Closed ernestguevarra closed 6 months ago

ernestguevarra commented 6 months ago

It is always good practice if you can have all your output results/indicators into a single data.frame object (whenever the aimed result allows for this). So, the resulting object would look like this (showing first 10 rows):

   State     month_year admissions defaulters cure_rate death_rate default_rate non_response_rate
 1 Blue Nile Jan 2016          684         51     0.918    0.00804       0.0684           0.00536
 2 Blue Nile Feb 2016          523         49     0.903    0.0157        0.0768           0.00470
 3 Blue Nile Mar 2016          664         45     0.905    0.00557       0.0835           0.00557
 4 Blue Nile Apr 2016         1154         62     0.897    0.0117        0.0904           0.00146
 5 Blue Nile May 2016          923         69     0.896    0.0104        0.0895           0.00389
 6 Blue Nile Jun 2016         2042         71     0.862    0.0203        0.111            0.00626
 7 Blue Nile Jul 2016         1338         95     0.874    0.0195        0.103            0.00325
 8 Blue Nile Aug 2016         1224         96     0.895    0.0178        0.0775           0.00969
 9 Blue Nile Sep 2016          892         75     0.893    0.0179        0.0838           0.00559
10 Blue Nile Oct 2016          457         85     0.893    0.0214        0.0825           0.00291
ernestguevarra commented 6 months ago

Getting to this data structure to get the performance indicators per month per state will help you be able to create the appropriate visualisation for:

Examples of how these would look like are found here - https://github.com/orgs/OxfordIHTM/discussions/32