I have a sample data of the data given to me and instructions of what I should be doing. I have access to Jupyter notebook and have already uploaded the data.
instructions:
Descriptive statistics for 5 groups: 1) total cohort, 2) diabetes only, 3) kidney disease only, 4) diabetes+kidney disease, 5) no diabetes+no kidney disease
Use the columns Diabetes with/without complications and renal disease to define group status
Constrain only to rows of the unique/first visit (use your new column D)
Demographics
Age (needs normality tests for each subgroup; generate either mean(SD) or median (IQR))
Payer type (categorical variable, generate N(%))
Sex (categorical variable, generate N(%))
Ethnicity (categorical variable, generate N(%))
Race (categorical variable, generate N(%))
ADI national (ordinal variable, generate median (IQR))
ADI state (ordinal variable, generate median (IQR))
Distance (needs normality tests for each subgroup; generate either mean(SD) or median (IQR))
Health status
CCI (ordinal variable, generate median (IQR))
Dx category (categorical variable, generate N(%))
Ortho: subdiagnosis category
Healthcare utilization
RFL to schedule (needs normality tests for each subgroup; generate either mean(SD) or median (IQR))
Schedule to first (needs normality tests for each subgroup; generate either mean(SD) or median (IQR))
RFL to first (needs normality tests for each subgroup; generate either mean(SD) or median (IQR))
RatioRFL-sched (needs normality tests for each subgroup; generate either mean(SD) or median (IQR))
RatioSched-first (needs normality tests for each subgroup; generate either mean(SD) or median (IQR))
Number of visits (needs normality tests for each subgroup; generate either mean(SD) or median (IQR))
Number of cancellations (needs normality tests for each subgroup; generate either mean(SD) or median (IQR))
Number of same day cancellations (needs normality tests for each subgroup; generate either mean(SD) or median (IQR))
EXAMPLE TABLE FOR REFERENCE is attached
EXAMPLE of the data is attached
I need a pdf (or screenshot) of every code that I need to use with the correct column names and codes to get to the Descriptive statistics for all 5 groups.
I need both a pdf with ALL the codes and steps to follow and that you have followed and it has worked, and also a table of all the results together like the one that is uploaded as a sample
SO I NEED:
1- a pdf (or screenshot) with ALL the codes and steps to follow and that you have followed and it has worked, (USING ACTUAL COLUMN NAMED & RUNNING IT)
2- a table of all the results together like the one that is uploaded as a sample
I BELIEVE THE NEEDED COLUMNS ARE:
* For Group Definitions (using the columns Diabetes and Renal Disease):
* DM_without_Complication
* DM_WITH_Complications
* Renal_Disease
* For Unique/First Visit:
* Constrained to only unique+first visit (assuming this column indicates the first visit)
* Demographics:
* Age
* FIN_CLASS (assuming this is related to payer type)
* Gender (assuming this corresponds to sex)
* Ethnicity
* FIRST_RACE (assuming this is the race)
* ADI_National
* ADI_State
* Distance (miles)
* Health Status:
* CCI
* Dx Category (assuming this is diagnosis category):
* Dx Category (Main Group)
* Dx (Sub grp) (assuming this is Ortho: subdiagnosis category)
* Healthcare Utilization:
* RFL_to_Schedule_PT_Appt__Not_IN
* Days_b_w_Scheduled_Date_and_Fir
* RFL_to_First_PT_date__Not_INCD_
* RatioRFLsched
* RatioSCHEDfirst
* NUM_OF_VISITS
* Total_Number_of_Cancel
* Total_Number_of_Cancel_Same_Day
