Comparison of average values for patients who receive thrombolysis and those that do not
Contents
Comparison of average values for patients who receive thrombolysis and those that do not#
Aims#
Compare feature means for patients who receive thrombolysis and those that do not.
This analysis is for only those patients arriving within 4 hours of known stroke onset, and is on data that has been coded and, where necessary, imputed.The data used in this analysis is the data used for machine learning.
Load and analyse data#
# import libraries
import matplotlib.pyplot as plt
import numpy as np
import pandas as pd
# Set up results DataFrame
results = pd.DataFrame()
# Display entire dataframes
pd.set_option("display.max_rows", 999, "display.max_columns", 150)
# Import data (concenate training and test set used in machine learning)
data = pd.concat([
pd.read_csv('./../data/10k_training_test/cohort_10000_train.csv'),
pd.read_csv('./../data/10k_training_test/cohort_10000_test.csv')])
# Add columns for scanned within 4 hours of arrival and onset
data['scan_within_4_hrs_arrival'] = data['S2BrainImagingTime_min'] <= 240
data['scan_within_4_hrs_onset'] = \
(data['S1OnsetToArrival_min'] + data['S2BrainImagingTime_min']) <= 240
# Convert boolean to integer
data['scan_within_4_hrs_arrival'] *= 1
data['scan_within_4_hrs_onset'] *= 1
data.dtypes
StrokeTeam object
S1AgeOnArrival float64
S1OnsetToArrival_min float64
S2RankinBeforeStroke int64
Loc int64
LocQuestions float64
LocCommands float64
BestGaze float64
Visual float64
FacialPalsy float64
MotorArmLeft float64
MotorArmRight float64
MotorLegLeft float64
MotorLegRight float64
LimbAtaxia float64
Sensory float64
BestLanguage float64
Dysarthria float64
ExtinctionInattention float64
S2NihssArrival float64
S2BrainImagingTime_min float64
MoreEqual80y_No int64
MoreEqual80y_Yes int64
S1Gender_Female int64
S1Gender_Male int64
S1Ethnicity_Asian int64
S1Ethnicity_Black int64
S1Ethnicity_Mixed int64
S1Ethnicity_Other int64
S1Ethnicity_White int64
S1OnsetInHospital_No int64
S1OnsetInHospital_Yes int64
S1OnsetDateType_Best estimate int64
S1OnsetDateType_Precise int64
S1OnsetDateType_Stroke during sleep int64
S1OnsetTimeType_Best estimate int64
S1OnsetTimeType_Not known int64
S1OnsetTimeType_Precise int64
S1ArriveByAmbulance_No int64
S1ArriveByAmbulance_Yes int64
S1ArriveByAmbulance_missing int64
S1AdmissionHour_00:00 to 02:59 int64
S1AdmissionHour_03:00 to 05:59 int64
S1AdmissionHour_06:00 to 08:59 int64
S1AdmissionHour_09:00 to 11:59 int64
S1AdmissionHour_12:00 to 14:59 int64
S1AdmissionHour_15:00 to 17:59 int64
S1AdmissionHour_18:00 to 20:59 int64
S1AdmissionHour_21:00 to 23:59 int64
S1AdmissionDay_Friday int64
S1AdmissionDay_Monday int64
S1AdmissionDay_Saturday int64
S1AdmissionDay_Sunday int64
S1AdmissionDay_Thursday int64
S1AdmissionDay_Tuesday int64
S1AdmissionDay_Wednesday int64
S1AdmissionQuarter_Q1 int64
S1AdmissionQuarter_Q2 int64
S1AdmissionQuarter_Q3 int64
S1AdmissionQuarter_Q4 int64
S1AdmissionYear_2016 int64
S1AdmissionYear_2017 int64
S1AdmissionYear_2018 int64
CongestiveHeartFailure_No int64
CongestiveHeartFailure_Yes int64
Hypertension_No int64
Hypertension_Yes int64
AtrialFibrillation_No int64
AtrialFibrillation_Yes int64
Diabetes_No int64
Diabetes_Yes int64
StrokeTIA_No int64
StrokeTIA_Yes int64
AFAntiplatelet_No int64
AFAntiplatelet_No but int64
AFAntiplatelet_Yes int64
AFAntiplatelet_missing int64
AFAnticoagulent_No int64
AFAnticoagulent_No but int64
AFAnticoagulent_Yes int64
AFAnticoagulent_missing int64
AFAnticoagulentVitK_No int64
AFAnticoagulentVitK_Yes int64
AFAnticoagulentVitK_missing int64
AFAnticoagulentDOAC_No int64
AFAnticoagulentDOAC_Yes int64
AFAnticoagulentDOAC_missing int64
AFAnticoagulentHeparin_No int64
AFAnticoagulentHeparin_Yes int64
AFAnticoagulentHeparin_missing int64
S2NewAFDiagnosis_No int64
S2NewAFDiagnosis_Yes int64
S2NewAFDiagnosis_missing int64
S2StrokeType_Infarction int64
S2StrokeType_Primary Intracerebral Haemorrhage int64
S2StrokeType_missing int64
S2TIAInLastMonth_No int64
S2TIAInLastMonth_No but int64
S2TIAInLastMonth_Yes int64
S2TIAInLastMonth_missing int64
S2Thrombolysis int64
scan_within_4_hrs_arrival int64
scan_within_4_hrs_onset int64
dtype: object
Summarise all 4 hour admissions#
all_4hr_admissions_summary = data.describe().T
results['all'] = all_4hr_admissions_summary['mean']
all_4hr_admissions_summary
count | mean | std | min | 25% | 50% | 75% | max | |
---|---|---|---|---|---|---|---|---|
S1AgeOnArrival | 88928.0 | 75.135447 | 13.825420 | 17.5 | 67.5 | 77.5 | 87.5 | 110.0 |
S1OnsetToArrival_min | 88928.0 | 111.392722 | 52.729071 | 1.0 | 71.0 | 100.0 | 146.0 | 240.0 |
S2RankinBeforeStroke | 88928.0 | 1.059689 | 1.420161 | 0.0 | 0.0 | 0.0 | 2.0 | 5.0 |
Loc | 88928.0 | 0.275178 | 0.667914 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 |
LocQuestions | 88928.0 | 0.675198 | 0.892330 | 0.0 | 0.0 | 0.0 | 2.0 | 2.0 |
LocCommands | 88928.0 | 0.372133 | 0.719221 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 |
BestGaze | 88928.0 | 0.354253 | 0.669124 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 |
Visual | 88928.0 | 0.506016 | 0.844272 | 0.0 | 0.0 | 0.0 | 1.0 | 3.0 |
FacialPalsy | 88928.0 | 0.885717 | 0.880693 | 0.0 | 0.0 | 1.0 | 2.0 | 3.0 |
MotorArmLeft | 88928.0 | 0.869546 | 1.377068 | 0.0 | 0.0 | 0.0 | 1.0 | 4.0 |
MotorArmRight | 88928.0 | 0.823531 | 1.369822 | 0.0 | 0.0 | 0.0 | 1.0 | 4.0 |
MotorLegLeft | 88928.0 | 0.869962 | 1.348570 | 0.0 | 0.0 | 0.0 | 1.0 | 4.0 |
MotorLegRight | 88928.0 | 0.834034 | 1.355595 | 0.0 | 0.0 | 0.0 | 1.0 | 4.0 |
LimbAtaxia | 88928.0 | 0.252339 | 0.560923 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 |
Sensory | 88928.0 | 0.517745 | 0.733587 | 0.0 | 0.0 | 0.0 | 1.0 | 2.0 |
BestLanguage | 88928.0 | 0.835777 | 1.099479 | 0.0 | 0.0 | 0.0 | 2.0 | 3.0 |
Dysarthria | 88928.0 | 0.746537 | 0.766312 | 0.0 | 0.0 | 1.0 | 1.0 | 2.0 |
ExtinctionInattention | 88928.0 | 0.492207 | 0.761407 | 0.0 | 0.0 | 0.0 | 1.0 | 2.0 |
S2NihssArrival | 88928.0 | 9.310172 | 8.173508 | 0.0 | 3.0 | 7.0 | 14.0 | 42.0 |
S2BrainImagingTime_min | 88928.0 | 117.212959 | 921.060766 | 1.0 | 15.0 | 28.0 | 57.0 | 85060.0 |
MoreEqual80y_No | 88928.0 | 0.576781 | 0.494072 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
MoreEqual80y_Yes | 88928.0 | 0.423219 | 0.494072 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1Gender_Female | 88928.0 | 0.482188 | 0.499685 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1Gender_Male | 88928.0 | 0.517812 | 0.499685 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
S1Ethnicity_Asian | 88928.0 | 0.030677 | 0.172441 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1Ethnicity_Black | 88928.0 | 0.011774 | 0.107866 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1Ethnicity_Mixed | 88928.0 | 0.003340 | 0.057695 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1Ethnicity_Other | 88928.0 | 0.071237 | 0.257222 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1Ethnicity_White | 88928.0 | 0.882973 | 0.321455 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S1OnsetInHospital_No | 88928.0 | 1.000000 | 0.000000 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S1OnsetInHospital_Yes | 88928.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
S1OnsetDateType_Best estimate | 88928.0 | 0.056934 | 0.231717 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1OnsetDateType_Precise | 88928.0 | 0.897411 | 0.303423 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S1OnsetDateType_Stroke during sleep | 88928.0 | 0.045655 | 0.208737 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1OnsetTimeType_Best estimate | 88928.0 | 0.379599 | 0.485290 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1OnsetTimeType_Not known | 88928.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
S1OnsetTimeType_Precise | 88928.0 | 0.620401 | 0.485290 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
S1ArriveByAmbulance_No | 88928.0 | 0.082381 | 0.274946 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1ArriveByAmbulance_Yes | 88928.0 | 0.917619 | 0.274946 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S1ArriveByAmbulance_missing | 88928.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
S1AdmissionHour_00:00 to 02:59 | 88928.0 | 0.051637 | 0.221295 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_03:00 to 05:59 | 88928.0 | 0.029260 | 0.168534 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_06:00 to 08:59 | 88928.0 | 0.069258 | 0.253894 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_09:00 to 11:59 | 88928.0 | 0.221696 | 0.415390 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_12:00 to 14:59 | 88928.0 | 0.202231 | 0.401666 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_15:00 to 17:59 | 88928.0 | 0.163649 | 0.369959 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_18:00 to 20:59 | 88928.0 | 0.153214 | 0.360196 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_21:00 to 23:59 | 88928.0 | 0.109055 | 0.311709 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Friday | 88928.0 | 0.143802 | 0.350891 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Monday | 88928.0 | 0.146624 | 0.353733 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Saturday | 88928.0 | 0.137561 | 0.344440 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Sunday | 88928.0 | 0.136594 | 0.343420 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Thursday | 88928.0 | 0.143959 | 0.351050 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Tuesday | 88928.0 | 0.144746 | 0.351847 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Wednesday | 88928.0 | 0.146714 | 0.353823 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionQuarter_Q1 | 88928.0 | 0.251181 | 0.433695 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1AdmissionQuarter_Q2 | 88928.0 | 0.251428 | 0.433837 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1AdmissionQuarter_Q3 | 88928.0 | 0.244760 | 0.429947 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionQuarter_Q4 | 88928.0 | 0.252631 | 0.434524 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1AdmissionYear_2016 | 88928.0 | 0.331021 | 0.470583 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1AdmissionYear_2017 | 88928.0 | 0.335800 | 0.472272 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1AdmissionYear_2018 | 88928.0 | 0.333180 | 0.471353 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
CongestiveHeartFailure_No | 88928.0 | 0.949555 | 0.218863 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
CongestiveHeartFailure_Yes | 88928.0 | 0.050445 | 0.218863 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
Hypertension_No | 88928.0 | 0.465174 | 0.498788 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
Hypertension_Yes | 88928.0 | 0.534826 | 0.498788 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
AtrialFibrillation_No | 88928.0 | 0.792765 | 0.405328 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
AtrialFibrillation_Yes | 88928.0 | 0.207235 | 0.405328 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
Diabetes_No | 88928.0 | 0.809037 | 0.393063 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
Diabetes_Yes | 88928.0 | 0.190963 | 0.393063 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
StrokeTIA_No | 88928.0 | 0.727847 | 0.445071 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
StrokeTIA_Yes | 88928.0 | 0.272153 | 0.445071 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
AFAntiplatelet_No | 88928.0 | 0.135267 | 0.342010 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAntiplatelet_No but | 88928.0 | 0.029619 | 0.169536 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAntiplatelet_Yes | 88928.0 | 0.042349 | 0.201385 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAntiplatelet_missing | 88928.0 | 0.792765 | 0.405328 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
AFAnticoagulent_No | 88928.0 | 0.326062 | 0.468773 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
AFAnticoagulent_No but | 88928.0 | 0.046757 | 0.211119 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAnticoagulent_Yes | 88928.0 | 0.121525 | 0.326739 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAnticoagulent_missing | 88928.0 | 0.505656 | 0.499971 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
AFAnticoagulentVitK_No | 88928.0 | 0.355895 | 0.478786 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
AFAnticoagulentVitK_Yes | 88928.0 | 0.019398 | 0.137919 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAnticoagulentVitK_missing | 88928.0 | 0.624708 | 0.484201 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
AFAnticoagulentDOAC_No | 88928.0 | 0.343795 | 0.474976 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
AFAnticoagulentDOAC_Yes | 88928.0 | 0.031497 | 0.174659 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAnticoagulentDOAC_missing | 88928.0 | 0.624708 | 0.484201 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
AFAnticoagulentHeparin_No | 88928.0 | 0.374550 | 0.484009 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
AFAnticoagulentHeparin_Yes | 88928.0 | 0.000742 | 0.027233 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAnticoagulentHeparin_missing | 88928.0 | 0.624708 | 0.484201 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
S2NewAFDiagnosis_No | 88928.0 | 0.256713 | 0.436822 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S2NewAFDiagnosis_Yes | 88928.0 | 0.023311 | 0.150890 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S2NewAFDiagnosis_missing | 88928.0 | 0.719976 | 0.449013 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
S2StrokeType_Infarction | 88928.0 | 0.849552 | 0.357512 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S2StrokeType_Primary Intracerebral Haemorrhage | 88928.0 | 0.148918 | 0.356010 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S2StrokeType_missing | 88928.0 | 0.001529 | 0.039077 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S2TIAInLastMonth_No | 88928.0 | 0.074442 | 0.262491 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S2TIAInLastMonth_No but | 88928.0 | 0.010896 | 0.103816 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S2TIAInLastMonth_Yes | 88928.0 | 0.004408 | 0.066247 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S2TIAInLastMonth_missing | 88928.0 | 0.910253 | 0.285820 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S2Thrombolysis | 88928.0 | 0.295261 | 0.456163 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
scan_within_4_hrs_arrival | 88928.0 | 0.947890 | 0.222249 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
scan_within_4_hrs_onset | 88928.0 | 0.830357 | 0.375321 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
Summarise 4 hour admissions who receive thrombolysis#
mask = data['S2Thrombolysis'] == 1
thrombolysis_admissions = data[mask]
thrombolysis_admissions_summary = thrombolysis_admissions.describe().T
results['thrombolysis'] = thrombolysis_admissions_summary['mean']
thrombolysis_admissions_summary
count | mean | std | min | 25% | 50% | 75% | max | |
---|---|---|---|---|---|---|---|---|
S1AgeOnArrival | 26257.0 | 73.092318 | 13.964103 | 17.5 | 62.5 | 77.5 | 82.5 | 110.0 |
S1OnsetToArrival_min | 26257.0 | 96.968808 | 45.638922 | 1.0 | 64.0 | 87.0 | 122.0 | 240.0 |
S2RankinBeforeStroke | 26257.0 | 0.727806 | 1.184651 | 0.0 | 0.0 | 0.0 | 1.0 | 5.0 |
Loc | 26257.0 | 0.206650 | 0.509833 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 |
LocQuestions | 26257.0 | 0.801653 | 0.921942 | 0.0 | 0.0 | 0.0 | 2.0 | 2.0 |
LocCommands | 26257.0 | 0.405263 | 0.727145 | 0.0 | 0.0 | 0.0 | 1.0 | 2.0 |
BestGaze | 26257.0 | 0.467266 | 0.720925 | 0.0 | 0.0 | 0.0 | 1.0 | 2.0 |
Visual | 26257.0 | 0.678829 | 0.899433 | 0.0 | 0.0 | 0.0 | 2.0 | 3.0 |
FacialPalsy | 26257.0 | 1.193548 | 0.878565 | 0.0 | 0.0 | 1.0 | 2.0 | 3.0 |
MotorArmLeft | 26257.0 | 1.069886 | 1.486363 | 0.0 | 0.0 | 0.0 | 2.0 | 4.0 |
MotorArmRight | 26257.0 | 1.031763 | 1.478511 | 0.0 | 0.0 | 0.0 | 2.0 | 4.0 |
MotorLegLeft | 26257.0 | 1.040332 | 1.420773 | 0.0 | 0.0 | 0.0 | 2.0 | 4.0 |
MotorLegRight | 26257.0 | 1.011121 | 1.436217 | 0.0 | 0.0 | 0.0 | 2.0 | 4.0 |
LimbAtaxia | 26257.0 | 0.291998 | 0.598986 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 |
Sensory | 26257.0 | 0.685036 | 0.777973 | 0.0 | 0.0 | 0.0 | 1.0 | 2.0 |
BestLanguage | 26257.0 | 1.070610 | 1.132034 | 0.0 | 0.0 | 1.0 | 2.0 | 3.0 |
Dysarthria | 26257.0 | 0.950489 | 0.755430 | 0.0 | 0.0 | 1.0 | 2.0 | 2.0 |
ExtinctionInattention | 26257.0 | 0.682370 | 0.818104 | 0.0 | 0.0 | 0.0 | 1.0 | 2.0 |
S2NihssArrival | 26257.0 | 11.586815 | 7.016364 | 0.0 | 6.0 | 10.0 | 17.0 | 42.0 |
S2BrainImagingTime_min | 26257.0 | 22.984195 | 19.822777 | 1.0 | 11.0 | 19.0 | 29.0 | 492.0 |
MoreEqual80y_No | 26257.0 | 0.643409 | 0.479002 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
MoreEqual80y_Yes | 26257.0 | 0.356591 | 0.479002 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1Gender_Female | 26257.0 | 0.460220 | 0.498425 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1Gender_Male | 26257.0 | 0.539780 | 0.498425 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
S1Ethnicity_Asian | 26257.0 | 0.031154 | 0.173736 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1Ethnicity_Black | 26257.0 | 0.011654 | 0.107325 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1Ethnicity_Mixed | 26257.0 | 0.003656 | 0.060357 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1Ethnicity_Other | 26257.0 | 0.082873 | 0.275696 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1Ethnicity_White | 26257.0 | 0.870663 | 0.335579 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S1OnsetInHospital_No | 26257.0 | 1.000000 | 0.000000 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S1OnsetInHospital_Yes | 26257.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
S1OnsetDateType_Best estimate | 26257.0 | 0.021975 | 0.146605 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1OnsetDateType_Precise | 26257.0 | 0.972807 | 0.162648 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S1OnsetDateType_Stroke during sleep | 26257.0 | 0.005218 | 0.072046 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1OnsetTimeType_Best estimate | 26257.0 | 0.180104 | 0.384282 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1OnsetTimeType_Not known | 26257.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
S1OnsetTimeType_Precise | 26257.0 | 0.819896 | 0.384282 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S1ArriveByAmbulance_No | 26257.0 | 0.059603 | 0.236755 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1ArriveByAmbulance_Yes | 26257.0 | 0.940397 | 0.236755 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S1ArriveByAmbulance_missing | 26257.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
S1AdmissionHour_00:00 to 02:59 | 26257.0 | 0.048292 | 0.214386 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_03:00 to 05:59 | 26257.0 | 0.017405 | 0.130777 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_06:00 to 08:59 | 26257.0 | 0.063297 | 0.243502 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_09:00 to 11:59 | 26257.0 | 0.232548 | 0.422464 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_12:00 to 14:59 | 26257.0 | 0.215942 | 0.411482 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_15:00 to 17:59 | 26257.0 | 0.172183 | 0.377546 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_18:00 to 20:59 | 26257.0 | 0.143885 | 0.350980 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_21:00 to 23:59 | 26257.0 | 0.106448 | 0.308416 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Friday | 26257.0 | 0.147008 | 0.354121 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Monday | 26257.0 | 0.148151 | 0.355256 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Saturday | 26257.0 | 0.132765 | 0.339327 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Sunday | 26257.0 | 0.139658 | 0.346638 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Thursday | 26257.0 | 0.144952 | 0.352059 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Tuesday | 26257.0 | 0.141715 | 0.348764 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Wednesday | 26257.0 | 0.145752 | 0.352864 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionQuarter_Q1 | 26257.0 | 0.245078 | 0.430141 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionQuarter_Q2 | 26257.0 | 0.256427 | 0.436669 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1AdmissionQuarter_Q3 | 26257.0 | 0.248353 | 0.432066 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionQuarter_Q4 | 26257.0 | 0.250143 | 0.433103 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1AdmissionYear_2016 | 26257.0 | 0.325209 | 0.468462 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1AdmissionYear_2017 | 26257.0 | 0.336291 | 0.472449 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1AdmissionYear_2018 | 26257.0 | 0.338500 | 0.473209 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
CongestiveHeartFailure_No | 26257.0 | 0.955440 | 0.206339 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
CongestiveHeartFailure_Yes | 26257.0 | 0.044560 | 0.206339 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
Hypertension_No | 26257.0 | 0.477854 | 0.499519 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
Hypertension_Yes | 26257.0 | 0.522146 | 0.499519 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
AtrialFibrillation_No | 26257.0 | 0.860113 | 0.346876 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
AtrialFibrillation_Yes | 26257.0 | 0.139887 | 0.346876 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
Diabetes_No | 26257.0 | 0.823818 | 0.380982 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
Diabetes_Yes | 26257.0 | 0.176182 | 0.380982 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
StrokeTIA_No | 26257.0 | 0.792551 | 0.405488 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
StrokeTIA_Yes | 26257.0 | 0.207449 | 0.405488 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAntiplatelet_No | 26257.0 | 0.084549 | 0.278215 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAntiplatelet_No but | 26257.0 | 0.014091 | 0.117870 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAntiplatelet_Yes | 26257.0 | 0.041246 | 0.198863 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAntiplatelet_missing | 26257.0 | 0.860113 | 0.346876 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
AFAnticoagulent_No | 26257.0 | 0.378261 | 0.484962 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
AFAnticoagulent_No but | 26257.0 | 0.046845 | 0.211310 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAnticoagulent_Yes | 26257.0 | 0.036943 | 0.188624 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAnticoagulent_missing | 26257.0 | 0.537952 | 0.498567 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
AFAnticoagulentVitK_No | 26257.0 | 0.373767 | 0.483812 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
AFAnticoagulentVitK_Yes | 26257.0 | 0.007846 | 0.088229 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAnticoagulentVitK_missing | 26257.0 | 0.618387 | 0.485792 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
AFAnticoagulentDOAC_No | 26257.0 | 0.375557 | 0.484276 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
AFAnticoagulentDOAC_Yes | 26257.0 | 0.006056 | 0.077583 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAnticoagulentDOAC_missing | 26257.0 | 0.618387 | 0.485792 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
AFAnticoagulentHeparin_No | 26257.0 | 0.381422 | 0.485745 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
AFAnticoagulentHeparin_Yes | 26257.0 | 0.000190 | 0.013798 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAnticoagulentHeparin_missing | 26257.0 | 0.618387 | 0.485792 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
S2NewAFDiagnosis_No | 26257.0 | 0.277145 | 0.447597 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S2NewAFDiagnosis_Yes | 26257.0 | 0.036828 | 0.188344 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S2NewAFDiagnosis_missing | 26257.0 | 0.686027 | 0.464115 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
S2StrokeType_Infarction | 26257.0 | 1.000000 | 0.000000 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S2StrokeType_Primary Intracerebral Haemorrhage | 26257.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
S2StrokeType_missing | 26257.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
S2TIAInLastMonth_No | 26257.0 | 0.059222 | 0.236045 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S2TIAInLastMonth_No but | 26257.0 | 0.007960 | 0.088864 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S2TIAInLastMonth_Yes | 26257.0 | 0.003199 | 0.056472 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S2TIAInLastMonth_missing | 26257.0 | 0.929619 | 0.255793 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S2Thrombolysis | 26257.0 | 1.000000 | 0.000000 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
scan_within_4_hrs_arrival | 26257.0 | 0.999581 | 0.020464 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
scan_within_4_hrs_onset | 26257.0 | 0.985185 | 0.120815 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
Summarise 4 hour admissions who do not receive thrombolysis#
mask = data['S2Thrombolysis'] == 0
no_thrombolysis_admissions = data[mask]
no_thrombolysis_admissions_summary = no_thrombolysis_admissions.describe().T
results['no_thrombolysis'] = no_thrombolysis_admissions_summary['mean']
no_thrombolysis_admissions_summary
count | mean | std | min | 25% | 50% | 75% | max | |
---|---|---|---|---|---|---|---|---|
S1AgeOnArrival | 62671.0 | 75.991447 | 13.676585 | 17.5 | 67.5 | 77.5 | 87.5 | 110.0 |
S1OnsetToArrival_min | 62671.0 | 117.435848 | 54.303876 | 1.0 | 75.0 | 107.0 | 156.0 | 240.0 |
S2RankinBeforeStroke | 62671.0 | 1.198736 | 1.486076 | 0.0 | 0.0 | 0.0 | 2.0 | 5.0 |
Loc | 62671.0 | 0.303889 | 0.722028 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 |
LocQuestions | 62671.0 | 0.622218 | 0.874215 | 0.0 | 0.0 | 0.0 | 2.0 | 2.0 |
LocCommands | 62671.0 | 0.358252 | 0.715425 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 |
BestGaze | 62671.0 | 0.306904 | 0.640291 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 |
Visual | 62671.0 | 0.433614 | 0.809170 | 0.0 | 0.0 | 0.0 | 1.0 | 3.0 |
FacialPalsy | 62671.0 | 0.756746 | 0.849037 | 0.0 | 0.0 | 1.0 | 1.0 | 3.0 |
MotorArmLeft | 62671.0 | 0.785611 | 1.319609 | 0.0 | 0.0 | 0.0 | 1.0 | 4.0 |
MotorArmRight | 62671.0 | 0.736290 | 1.311854 | 0.0 | 0.0 | 0.0 | 1.0 | 4.0 |
MotorLegLeft | 62671.0 | 0.798583 | 1.310588 | 0.0 | 0.0 | 0.0 | 1.0 | 4.0 |
MotorLegRight | 62671.0 | 0.759841 | 1.313287 | 0.0 | 0.0 | 0.0 | 1.0 | 4.0 |
LimbAtaxia | 62671.0 | 0.235723 | 0.543330 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 |
Sensory | 62671.0 | 0.447655 | 0.702432 | 0.0 | 0.0 | 0.0 | 1.0 | 2.0 |
BestLanguage | 62671.0 | 0.737390 | 1.070351 | 0.0 | 0.0 | 0.0 | 1.0 | 3.0 |
Dysarthria | 62671.0 | 0.661087 | 0.754620 | 0.0 | 0.0 | 0.0 | 1.0 | 2.0 |
ExtinctionInattention | 62671.0 | 0.412535 | 0.721618 | 0.0 | 0.0 | 0.0 | 1.0 | 2.0 |
S2NihssArrival | 62671.0 | 8.356337 | 8.431479 | 0.0 | 2.0 | 5.0 | 13.0 | 42.0 |
S2BrainImagingTime_min | 62671.0 | 156.691580 | 1094.689958 | 1.0 | 19.0 | 35.0 | 81.0 | 85060.0 |
MoreEqual80y_No | 62671.0 | 0.548866 | 0.497610 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
MoreEqual80y_Yes | 62671.0 | 0.451134 | 0.497610 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1Gender_Female | 62671.0 | 0.491392 | 0.499930 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1Gender_Male | 62671.0 | 0.508608 | 0.499930 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
S1Ethnicity_Asian | 62671.0 | 0.030477 | 0.171896 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1Ethnicity_Black | 62671.0 | 0.011824 | 0.108093 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1Ethnicity_Mixed | 62671.0 | 0.003207 | 0.056542 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1Ethnicity_Other | 62671.0 | 0.066362 | 0.248917 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1Ethnicity_White | 62671.0 | 0.888130 | 0.315209 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S1OnsetInHospital_No | 62671.0 | 1.000000 | 0.000000 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S1OnsetInHospital_Yes | 62671.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
S1OnsetDateType_Best estimate | 62671.0 | 0.071580 | 0.257794 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1OnsetDateType_Precise | 62671.0 | 0.865823 | 0.340845 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S1OnsetDateType_Stroke during sleep | 62671.0 | 0.062597 | 0.242238 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1OnsetTimeType_Best estimate | 62671.0 | 0.463181 | 0.498646 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1OnsetTimeType_Not known | 62671.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
S1OnsetTimeType_Precise | 62671.0 | 0.536819 | 0.498646 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
S1ArriveByAmbulance_No | 62671.0 | 0.091924 | 0.288922 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1ArriveByAmbulance_Yes | 62671.0 | 0.908076 | 0.288922 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S1ArriveByAmbulance_missing | 62671.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
S1AdmissionHour_00:00 to 02:59 | 62671.0 | 0.053039 | 0.224113 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_03:00 to 05:59 | 62671.0 | 0.034226 | 0.181812 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_06:00 to 08:59 | 62671.0 | 0.071756 | 0.258085 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_09:00 to 11:59 | 62671.0 | 0.217150 | 0.412309 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_12:00 to 14:59 | 62671.0 | 0.196486 | 0.397344 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_15:00 to 17:59 | 62671.0 | 0.160074 | 0.366678 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_18:00 to 20:59 | 62671.0 | 0.157122 | 0.363919 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionHour_21:00 to 23:59 | 62671.0 | 0.110147 | 0.313075 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Friday | 62671.0 | 0.142458 | 0.349522 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Monday | 62671.0 | 0.145985 | 0.353094 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Saturday | 62671.0 | 0.139570 | 0.346543 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Sunday | 62671.0 | 0.135310 | 0.342057 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Thursday | 62671.0 | 0.143543 | 0.350629 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Tuesday | 62671.0 | 0.146016 | 0.353126 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionDay_Wednesday | 62671.0 | 0.147117 | 0.354226 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionQuarter_Q1 | 62671.0 | 0.253738 | 0.435153 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1AdmissionQuarter_Q2 | 62671.0 | 0.249334 | 0.432631 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionQuarter_Q3 | 62671.0 | 0.243254 | 0.429051 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S1AdmissionQuarter_Q4 | 62671.0 | 0.253674 | 0.435117 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1AdmissionYear_2016 | 62671.0 | 0.333456 | 0.471452 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1AdmissionYear_2017 | 62671.0 | 0.335594 | 0.472201 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
S1AdmissionYear_2018 | 62671.0 | 0.330951 | 0.470559 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
CongestiveHeartFailure_No | 62671.0 | 0.947089 | 0.223858 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
CongestiveHeartFailure_Yes | 62671.0 | 0.052911 | 0.223858 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
Hypertension_No | 62671.0 | 0.459862 | 0.498390 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
Hypertension_Yes | 62671.0 | 0.540138 | 0.498390 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
AtrialFibrillation_No | 62671.0 | 0.764548 | 0.424284 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
AtrialFibrillation_Yes | 62671.0 | 0.235452 | 0.424284 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
Diabetes_No | 62671.0 | 0.802843 | 0.397855 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
Diabetes_Yes | 62671.0 | 0.197157 | 0.397855 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
StrokeTIA_No | 62671.0 | 0.700739 | 0.457938 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
StrokeTIA_Yes | 62671.0 | 0.299261 | 0.457938 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
AFAntiplatelet_No | 62671.0 | 0.156516 | 0.363347 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAntiplatelet_No but | 62671.0 | 0.036125 | 0.186603 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAntiplatelet_Yes | 62671.0 | 0.042811 | 0.202432 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAntiplatelet_missing | 62671.0 | 0.764548 | 0.424284 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
AFAnticoagulent_No | 62671.0 | 0.304192 | 0.460068 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
AFAnticoagulent_No but | 62671.0 | 0.046720 | 0.211041 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAnticoagulent_Yes | 62671.0 | 0.156963 | 0.363768 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAnticoagulent_missing | 62671.0 | 0.492126 | 0.499942 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
AFAnticoagulentVitK_No | 62671.0 | 0.348407 | 0.476469 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
AFAnticoagulentVitK_Yes | 62671.0 | 0.024238 | 0.153788 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAnticoagulentVitK_missing | 62671.0 | 0.627356 | 0.483512 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
AFAnticoagulentDOAC_No | 62671.0 | 0.330488 | 0.470393 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
AFAnticoagulentDOAC_Yes | 62671.0 | 0.042157 | 0.200948 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAnticoagulentDOAC_missing | 62671.0 | 0.627356 | 0.483512 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
AFAnticoagulentHeparin_No | 62671.0 | 0.371671 | 0.483255 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 |
AFAnticoagulentHeparin_Yes | 62671.0 | 0.000973 | 0.031183 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
AFAnticoagulentHeparin_missing | 62671.0 | 0.627356 | 0.483512 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
S2NewAFDiagnosis_No | 62671.0 | 0.248153 | 0.431945 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S2NewAFDiagnosis_Yes | 62671.0 | 0.017648 | 0.131668 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S2NewAFDiagnosis_missing | 62671.0 | 0.734199 | 0.441762 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 |
S2StrokeType_Infarction | 62671.0 | 0.786520 | 0.409767 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S2StrokeType_Primary Intracerebral Haemorrhage | 62671.0 | 0.211310 | 0.408241 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S2StrokeType_missing | 62671.0 | 0.002170 | 0.046534 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S2TIAInLastMonth_No | 62671.0 | 0.080819 | 0.272559 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S2TIAInLastMonth_No but | 62671.0 | 0.012127 | 0.109453 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S2TIAInLastMonth_Yes | 62671.0 | 0.004915 | 0.069932 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 |
S2TIAInLastMonth_missing | 62671.0 | 0.902140 | 0.297128 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
S2Thrombolysis | 62671.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
scan_within_4_hrs_arrival | 62671.0 | 0.926234 | 0.261392 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
scan_within_4_hrs_onset | 62671.0 | 0.765490 | 0.423696 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 |
Show summary of all groups#
Add ratio of yes/no thrombolysis (and sort by ratio), and save.
results['ratio'] = results['thrombolysis'] / results['no_thrombolysis']
results.sort_values('ratio', inplace=True)
results.to_csv('output/thrombolse_yes_no_means.csv')
results
all | thrombolysis | no_thrombolysis | ratio | |
---|---|---|---|---|
S2StrokeType_Primary Intracerebral Haemorrhage | 0.148918 | 0.000000 | 0.211310 | 0.000000 |
S2StrokeType_missing | 0.001529 | 0.000000 | 0.002170 | 0.000000 |
S1OnsetDateType_Stroke during sleep | 0.045655 | 0.005218 | 0.062597 | 0.083353 |
AFAnticoagulentDOAC_Yes | 0.031497 | 0.006056 | 0.042157 | 0.143643 |
S2BrainImagingTime_min | 117.212959 | 22.984195 | 156.691580 | 0.146684 |
AFAnticoagulentHeparin_Yes | 0.000742 | 0.000190 | 0.000973 | 0.195642 |
AFAnticoagulent_Yes | 0.121525 | 0.036943 | 0.156963 | 0.235359 |
S1OnsetDateType_Best estimate | 0.056934 | 0.021975 | 0.071580 | 0.307000 |
AFAnticoagulentVitK_Yes | 0.019398 | 0.007846 | 0.024238 | 0.323691 |
S1OnsetTimeType_Best estimate | 0.379599 | 0.180104 | 0.463181 | 0.388842 |
AFAntiplatelet_No but | 0.029619 | 0.014091 | 0.036125 | 0.390074 |
S1AdmissionHour_03:00 to 05:59 | 0.029260 | 0.017405 | 0.034226 | 0.508523 |
AFAntiplatelet_No | 0.135267 | 0.084549 | 0.156516 | 0.540194 |
AtrialFibrillation_Yes | 0.207235 | 0.139887 | 0.235452 | 0.594119 |
S2RankinBeforeStroke | 1.059689 | 0.727806 | 1.198736 | 0.607144 |
S1ArriveByAmbulance_No | 0.082381 | 0.059603 | 0.091924 | 0.648393 |
S2TIAInLastMonth_Yes | 0.004408 | 0.003199 | 0.004915 | 0.650954 |
S2TIAInLastMonth_No but | 0.010896 | 0.007960 | 0.012127 | 0.656378 |
Loc | 0.275178 | 0.206650 | 0.303889 | 0.680018 |
StrokeTIA_Yes | 0.272153 | 0.207449 | 0.299261 | 0.693205 |
S2TIAInLastMonth_No | 0.074442 | 0.059222 | 0.080819 | 0.732778 |
MoreEqual80y_Yes | 0.423219 | 0.356591 | 0.451134 | 0.790432 |
S1OnsetToArrival_min | 111.392722 | 96.968808 | 117.435848 | 0.825717 |
CongestiveHeartFailure_Yes | 0.050445 | 0.044560 | 0.052911 | 0.842157 |
S1AdmissionHour_06:00 to 08:59 | 0.069258 | 0.063297 | 0.071756 | 0.882124 |
Diabetes_Yes | 0.190963 | 0.176182 | 0.197157 | 0.893613 |
S1AdmissionHour_00:00 to 02:59 | 0.051637 | 0.048292 | 0.053039 | 0.910500 |
S1AdmissionHour_18:00 to 20:59 | 0.153214 | 0.143885 | 0.157122 | 0.915756 |
S2NewAFDiagnosis_missing | 0.719976 | 0.686027 | 0.734199 | 0.934387 |
S1Gender_Female | 0.482188 | 0.460220 | 0.491392 | 0.936565 |
S1AdmissionDay_Saturday | 0.137561 | 0.132765 | 0.139570 | 0.951239 |
S1AgeOnArrival | 75.135447 | 73.092318 | 75.991447 | 0.961849 |
AFAntiplatelet_Yes | 0.042349 | 0.041246 | 0.042811 | 0.963450 |
S1AdmissionQuarter_Q1 | 0.251181 | 0.245078 | 0.253738 | 0.965869 |
S1AdmissionHour_21:00 to 23:59 | 0.109055 | 0.106448 | 0.110147 | 0.966419 |
Hypertension_Yes | 0.534826 | 0.522146 | 0.540138 | 0.966691 |
S1AdmissionDay_Tuesday | 0.144746 | 0.141715 | 0.146016 | 0.970538 |
S1AdmissionYear_2016 | 0.331021 | 0.325209 | 0.333456 | 0.975268 |
S1Ethnicity_White | 0.882973 | 0.870663 | 0.888130 | 0.980333 |
S1Ethnicity_Black | 0.011774 | 0.011654 | 0.011824 | 0.985655 |
AFAnticoagulentVitK_missing | 0.624708 | 0.618387 | 0.627356 | 0.985705 |
AFAnticoagulentDOAC_missing | 0.624708 | 0.618387 | 0.627356 | 0.985705 |
AFAnticoagulentHeparin_missing | 0.624708 | 0.618387 | 0.627356 | 0.985705 |
S1AdmissionQuarter_Q4 | 0.252631 | 0.250143 | 0.253674 | 0.986080 |
S1AdmissionDay_Wednesday | 0.146714 | 0.145752 | 0.147117 | 0.990716 |
S1OnsetInHospital_No | 1.000000 | 1.000000 | 1.000000 | 1.000000 |
S1AdmissionYear_2017 | 0.335800 | 0.336291 | 0.335594 | 1.002078 |
AFAnticoagulent_No but | 0.046757 | 0.046845 | 0.046720 | 1.002664 |
CongestiveHeartFailure_No | 0.949555 | 0.955440 | 0.947089 | 1.008818 |
S1AdmissionDay_Thursday | 0.143959 | 0.144952 | 0.143543 | 1.009813 |
S1AdmissionDay_Monday | 0.146624 | 0.148151 | 0.145985 | 1.014840 |
S1AdmissionQuarter_Q3 | 0.244760 | 0.248353 | 0.243254 | 1.020959 |
S1Ethnicity_Asian | 0.030677 | 0.031154 | 0.030477 | 1.022213 |
S1AdmissionYear_2018 | 0.333180 | 0.338500 | 0.330951 | 1.022812 |
Diabetes_No | 0.809037 | 0.823818 | 0.802843 | 1.026126 |
AFAnticoagulentHeparin_No | 0.374550 | 0.381422 | 0.371671 | 1.026236 |
S1AdmissionQuarter_Q2 | 0.251428 | 0.256427 | 0.249334 | 1.028448 |
S2TIAInLastMonth_missing | 0.910253 | 0.929619 | 0.902140 | 1.030460 |
S1AdmissionDay_Friday | 0.143802 | 0.147008 | 0.142458 | 1.031940 |
S1AdmissionDay_Sunday | 0.136594 | 0.139658 | 0.135310 | 1.032135 |
S1ArriveByAmbulance_Yes | 0.917619 | 0.940397 | 0.908076 | 1.035593 |
Hypertension_No | 0.465174 | 0.477854 | 0.459862 | 1.039124 |
S1Gender_Male | 0.517812 | 0.539780 | 0.508608 | 1.061288 |
S1AdmissionHour_09:00 to 11:59 | 0.221696 | 0.232548 | 0.217150 | 1.070908 |
AFAnticoagulentVitK_No | 0.355895 | 0.373767 | 0.348407 | 1.072789 |
S1AdmissionHour_15:00 to 17:59 | 0.163649 | 0.172183 | 0.160074 | 1.075644 |
scan_within_4_hrs_arrival | 0.947890 | 0.999581 | 0.926234 | 1.079189 |
AFAnticoagulent_missing | 0.505656 | 0.537952 | 0.492126 | 1.093119 |
S1AdmissionHour_12:00 to 14:59 | 0.202231 | 0.215942 | 0.196486 | 1.099020 |
S2NewAFDiagnosis_No | 0.256713 | 0.277145 | 0.248153 | 1.116831 |
S1OnsetDateType_Precise | 0.897411 | 0.972807 | 0.865823 | 1.123564 |
AtrialFibrillation_No | 0.792765 | 0.860113 | 0.764548 | 1.124996 |
AFAntiplatelet_missing | 0.792765 | 0.860113 | 0.764548 | 1.124996 |
StrokeTIA_No | 0.727847 | 0.792551 | 0.700739 | 1.131021 |
LocCommands | 0.372133 | 0.405263 | 0.358252 | 1.131225 |
AFAnticoagulentDOAC_No | 0.343795 | 0.375557 | 0.330488 | 1.136372 |
S1Ethnicity_Mixed | 0.003340 | 0.003656 | 0.003207 | 1.139979 |
MoreEqual80y_No | 0.576781 | 0.643409 | 0.548866 | 1.172252 |
LimbAtaxia | 0.252339 | 0.291998 | 0.235723 | 1.238735 |
AFAnticoagulent_No | 0.326062 | 0.378261 | 0.304192 | 1.243495 |
S1Ethnicity_Other | 0.071237 | 0.082873 | 0.066362 | 1.248796 |
S2StrokeType_Infarction | 0.849552 | 1.000000 | 0.786520 | 1.271423 |
scan_within_4_hrs_onset | 0.830357 | 0.985185 | 0.765490 | 1.287000 |
LocQuestions | 0.675198 | 0.801653 | 0.622218 | 1.288380 |
MotorLegLeft | 0.869962 | 1.040332 | 0.798583 | 1.302722 |
MotorLegRight | 0.834034 | 1.011121 | 0.759841 | 1.330700 |
MotorArmLeft | 0.869546 | 1.069886 | 0.785611 | 1.361853 |
S2NihssArrival | 9.310172 | 11.586815 | 8.356337 | 1.386590 |
MotorArmRight | 0.823531 | 1.031763 | 0.736290 | 1.401301 |
Dysarthria | 0.746537 | 0.950489 | 0.661087 | 1.437767 |
BestLanguage | 0.835777 | 1.070610 | 0.737390 | 1.451890 |
BestGaze | 0.354253 | 0.467266 | 0.306904 | 1.522513 |
S1OnsetTimeType_Precise | 0.620401 | 0.819896 | 0.536819 | 1.527322 |
Sensory | 0.517745 | 0.685036 | 0.447655 | 1.530277 |
Visual | 0.506016 | 0.678829 | 0.433614 | 1.565515 |
FacialPalsy | 0.885717 | 1.193548 | 0.756746 | 1.577212 |
ExtinctionInattention | 0.492207 | 0.682370 | 0.412535 | 1.654090 |
S2NewAFDiagnosis_Yes | 0.023311 | 0.036828 | 0.017648 | 2.086858 |
S2Thrombolysis | 0.295261 | 1.000000 | 0.000000 | inf |
S1OnsetInHospital_Yes | 0.000000 | 0.000000 | 0.000000 | NaN |
S1OnsetTimeType_Not known | 0.000000 | 0.000000 | 0.000000 | NaN |
S1ArriveByAmbulance_missing | 0.000000 | 0.000000 | 0.000000 | NaN |
Observations#
For patients arriving within 4 hours of known stroke onset, compared to those that do not receive thrombolysis, patients who receive thrombolysis:
Have a confirmed ischaemic stroke
Do not have stroke onset during sleep
Arrive outside of the hours 3am to 6am
Are younger (mean age 73 vs 76)
Arrive sooner (mean onset to arrival 97 vs 117 minutes)
Have higher stroke severity (mean NIHSS 11.6 vs 8.4)
Are scanned within 4 hours of arrival (100% vs 93%) and 4 hours of onset (99% vs 77%)
Are more likely to have a precisely determined stroke onset time (97% vs 87%)
Have arrived by ambulance (94% vs 91%)
Not have atrial fibrillation (14% vs 24% having AF)
Not have a history of TIA (21% vs 30% having had TIA)
Not be on anticoagulant