For those who acquire COVID-19 and recover, how long does the illness last ?
(Time to event analysis of COVID-19 recovery data from India.)
** Disclaimer : This is an unofficial analysis of sparsely populated data, by a data science enthusiast. I am not a health care professional and the answers obtained here should not be considered official much less definitive. The objective is to glean what insights we can from the data exposed to us, and generate discussion on ways to tackle such questions.**
** (Uses Patient level COVID-19 data from India,
Source of Data: https://api.covid19india.org/csv/)**
For the complete Jupyter Notebook, visit: https://github.com/gowrithampi/covid19-recovery-analysis
Constructive criticism of this analysis is more than welcome, I'm looking forward to some. Maybe we can work on improving it together! If you enjoy this analysis, I'm looking for opportunities in Data Science and Machine learning, you can contact me @ [email protected].
Table of Contents
- Questions we want to answer
- About the Data
- Why focus on recovery?
- Overall recovery time
- Recovery rates by Sex
- Recovery rates by Age Buckets
- Recovery rates by Age and sex
- What did we learn?
- References
1. Questions we want to answer:
The main questions we wish to delve into are as follows:
- Given that a person falls ill with COVID-19 and then makes a recovery, how long does the illness last?
- What factors do the time to recovery depend on? The analysis considers Sex and Age as factors that could potentially impact recovery times.
2. About the Data
Patient level COVID-19 data from India was sourced from https://api.covid19india.org/csv/. By their own description the website is a volunteer-driven, crowdsourced database for COVID-19 stats and patient tracing in India. The source for each patient's information is given as links to newspaper and magazine articles.
The data has a column each, for the date the case was announced (Date Announced), the current status of the case (Current Status among: deceased, hospitalized, recovered) and the date the status changed to the current status (Status Change Date).
The difference between the Status Change Date and the Date Announced was used as the time to recovery in this model. Though the Date Announced wouldn't be the date the patient got ill, it would be quite close to the date serious symptoms were reported.
Data collection could not be perfect in such a crowd sourced venture during a pandemic. Often the Status Change Date, was the same as the Date Announced. This is probably due to lack of information about when the case status changed. Attributes like gender and age are quite sparsely populated. The number of recoveries recorded were just 181 out of 17,306 observations. In most cases the current status was listed as hospitalized, probably as the recovery of the case wasn't tracked. I did not include the hospitalized cases as censored observations in my analysis as is often done in Time To Event modelling because they were the overwhelming majority and their timelines weren't tracked. Hence including them would reduce the insights we could glean from the few cases where timelines and other attributes like gender and age were properly logged.
The website itself states that due to the inability to track the changes in each case, they are deprecating the Current Status field. However, the data used in this analysis was of earlier cases (Those announced before April 19th 2020) and hence this information is sometimes available and can be used.
Despite the shortcomings, we do get enough data to get information that answers some of our questions and points us in the direction of further research. We also develop a methodology for analysis that can be done if better anonymized data is available from hospitals.
For further questions about the data and my methodology please email me at [email protected]
3. Why focus on recovery?
- Several models exist which try to predict the fatality rate and the factors affecting it.
- Being ill for a long period of time has negative consequences too, eg: losses in productivity (I only know too well as a survivor of severe Repetitive Stress Injury)
4. Overall recovery time
Boxplots show the median (line through the box), minimum, maximum( lower and upper whiskers) and the first and third quartile (within the rectangle) of a value. Value plotted here is the time to recovery, of the 181 patients who recovered and we have Time to Recovery information about.
Median time to recovery is 14 days
What percentage of patients remain sick, a given number of days after diagnosis?
To visualize this, we draw what are known as Kaplan-Meier curves. In these curves, derived from our data, the Y axis shows what percentage of the total population who finally recovered, are still sick, and the X axis shows the number of days after diagnosis. For example, 10 days after diagnosis, roughly 75% of the people who finally recovered are still sick. The steeper the slope of this curve, the faster the recovery time. Since everyone in our population finally recovered, we see that by the longest recovery time we have in our data (25 days) nobody is still sick.
5. Recovery rates by Sex
For this part of the analysis we further filter out the data, leaving only those who also have the sex column filled out. We have 92 patients, 64 male and 28 female. The median time to recovery is greater for females(16 days) than males(14 days), that does run contrary to the fact that women have lower fatality rates from COVID-19 than men. The dataset is small, and the sexes are not equally represented in it, also there may be confounding due to a second variable (like age) disproportionately distributed in the two sexes, but to me this indicates a need for further research.
A t-test run on the mean recovery times for the two sexes resulted in a p-value of 0.11, this indicates that we only have an eighty nine percent confidence that the mean recovery times for the two groups are different, not high enough to be conclusive at all, but it does merit investigation with a larger dataset when available.
------ -- Male 64 Female 28 ------ -- Median time to recovery for males is 14 days. Median time to recovery for females is 16 days.
How many people remain sick a given number of days after diagnosis ?
We again draw Kaplan-Meier curves for each sex, superimposed on the same axes. The steeper slope for males would indicate that males recover faster. The confidence intervals for each curve are shown by the shaded region. Overlapping confidence intervals indicate our lack of confidence that the actual recovery times for the populations of males and females differ from each other, given the data we have.
6. Recovery rates by Age
For this part of the analysis we filter out the data, leaving only those who also have the age column filled out. We bucket the age groups into those under and over 50. Due to the sparsity of data, creating more buckets would lead to very few observations in each.
We have 94 patients, 63 under 50 years of and 31 over 50 years of age. The median time to recovery is much greater for those over 50(21 days) than those under 50 (14 days), this is more in line with what we know about the virus, and the increased fatality rate with age.
A t-test run on the mean recovery times for the two age groups, resulted in a p-value really close to zero.
-------- -- under 50 63 over 50 31 -------- -- Median time to recovery for the under 50 age group is 14 days. Median time to recovery for the over 50 age group is 21 days.
p-value 0.000
How many people remain sick a given number of days after diagnosis ?
We again draw Kaplan-Meier curves for each age group, superimposed on the same axes. The steeper slope for those under 50 indicate a quicker recovery for that age group.
7. Recovery rates by age and sex
For this analysis by age and sex, we use a slightly different approach. We use the Cox Proportional Hazard Model, which estimates the hazard function, which is the instaneous probability of an event's occurence, given it hasn't occured so far. That is, for a given patient, if they haven't recovered until day k, what is the probability that they will recover on day k?
The analysis chooses a baseline group, in this case women over 50, and then assumes proportional hazards for the other groups. That is, the hazard curves for the other groups (females under 50, males under 50 and males over 50) are proportional and can't cross. That is, if an individual has an instantaneous probability of recovery at the initial time point that is twice as high as that of another individual, then at all later times the instantaneous probability of recovery remains twice as high.
Once the model is fit, we notice an extremely high p-value on the male coefficient, this means that there is very low confidence that there is a difference in the instantaneous probability of recovery between men and women.
We also notice a very low p-value in the age coefficient, showing a high level of confidence that there is a difference in the instantaneous probability of recovery of those over 50 compared to those under 50. (By this analysis, on a given day a woman under 50 has a probability of recovery 4.43 times as high as a woman over 50)
Gender F M Age Bucket over 50 11 8 under 50 11 45
8. What did we learn ?
Many different assumptions were made in this analysis and we were plagued by sparse, unreliable data, but despite this we did get indications pointing us in the right direction (faster recovery times in younger people). I expect some good criticism of this analysis, but we did learn the following.
- With a high degree of confidence younger people recover faster than older people.
- The differences between sexes wasn't as apparent, in fact we couldn't say much with a good degree of confidence.
- Confounding effects (like disproportionate distribution of age over the sexes) could lead to surprising results like males recovering faster than females.
- Such analysis may lead to more fruitful results in a larger dataset with more variables. For eg: we could analyze the result of different medications and treatments on recovery times.
- Recovery times may follow trends similar to fatality rates, with older people taking longer to recovery.
9. References
https://www.sthda.com/english/wiki/cox-proportional-hazards-model
https://lifelines.readthedocs.io/en/latest/
Constructive criticism of this analysis is more than welcome. I'm looking forward to some. Maybe we can work on improving it together! If you enjoyed this analysis, I'm looking for opportunities in Data Science and Machine learning, you can contact me @ [email protected].
Experienced analytics leader
4 年Nicely done Gowri!
Director of Product Management | Lowe's
4 年Good stuff. the Age factor definitely jumps out in multiple studies.