Project: Readmissions Reduction
1
2
3
4
5
6
7
Upload Method
File Upload
File Select
Primary key
Aggregation
Target
Variable Selection
Prescriptions
Step 5: Aggregation

Based on the earlier steps, below is the sample of the aggregated data.

encounter_id patient_nbr race gender age weight admission_type_id discharge_disposition_id admission_source_id time_in_hospital payer_code medical_specialty num_lab_procedures num_procedures num_medications number_outpatient number_emergency number_inpatient diag_1 diag_2 diag_3 number_diagnoses max_glu_serum A1Cresult metformin repaglinide nateglinide chlorpropamide glimepiride acetohexamide glipizide glyburide tolbutamide pioglitazone rosiglitazone acarbose miglitol troglitazone tolazamide examide citoglipton insulin glyburide-metformin glipizide-metformin glimepiride-pioglitazone metformin-rosiglitazone metformin-pioglitazone change diabetesMed readmitted
2278392 8222157 Caucasian Female [0-10) ? 6 25 1 1 ? Pediatrics-Endocrinology 41 0 1 0 0 0 250.83 ? ? 1 None None No No No No No No No No No No No No No No No No No No No NO No No NO No No NO
149190 55629189 Caucasian Female [10-20) ? 1 1 7 3 ? ? 59 0 18 0 0 0 276.0 250.01 255 9 nan nan No No No No No No No No No No No No No No No No Up No No No No No No Ch Yes Yes
64410 86047875 AfricanAmerican Female [20-30) ? 1 1 7 2 ? ? 11 5 13 2 0 1 648.0 250 V27 6 nan nan No No No No No No Steady No No No No No No No No No No No No No No No No No Yes NO
500364 82442376 Caucasian Male [30-40) ? 1 1 7 2 ? ? 44 1 16 0 0 0 8.0 250.43 403 7 nan nan No No No No No No No No No No No No No No No No No Up No No No No No Ch Yes NO
16680 42519267 Caucasian Male [40-50) ? 1 1 7 1 ? ? 51 0 8 0 0 0 197.0 157 250 5 nan nan No No No No No No Steady No No No No No No No No No No Steady No No No No No Ch Yes NO
35754 82637451 Caucasian Male [50-60) ? 2 1 2 3 ? ? 31 6 16 0 0 0 414.0 411 250 9 nan nan No No No No No No No No No No No No No No No No No No Steady No No No No No No Yes
55842 84259809 Caucasian Male [60-70) ? 3 1 2 4 ? ? 70 1 21 0 0 0 414.0 411 V45 7 nan nan Steady No No No Steady No No No No No No No No No No No No Steady No No No No No Ch Yes NO
63768 114882984 Caucasian Male [70-80) ? 1 1 7 5 ? ? 73 0 12 0 0 0 428.0 492 250 8 nan nan No No No No No No No Steady No No No No No No No No No No No No No No No No No Yes
12522 48330783 Caucasian Female [80-90) ? 2 1 4 13 ? ? 68 2 28 0 0 0 398.0 427 38 8 nan nan No No No No No No Steady No No No No No No No No No No Steady No No No No No Ch Yes NO
15738 63555939 Caucasian Female [90-100) ? 3 3 4 12 ? InternalMedicine 33 3 18 0 0 0 434.0 198 486 8 nan nan No No No No No No No No No No No No No No No No No No No Steady No No No No No No
Does the above snapshot and summary represent your data?