Product Level Analysis of Clinical Study Trials

Introduction: The purpose of this ticket is to implement a Product Level Analysis for clinical study trials to evaluate study performance by analyzing the total number of studies, average duration, and completion rate for each product_name. This analysis will help stakeholders identify high-performing products and improve study designs for underperforming ones.

 

Requirement: Create a pyspark logic for study product analysis, Read the “study_product_analysis” file. For Study Duration Calculation Computes duration between Fsr (start date) and Far (end date). Aggregates data by product_name for total studies, average study duration, and study completion rate for product analysis. Uses study_conduct_status to determine completed studies of percentage for Completion Rate calculation.

 

Final Output: Display the result with the column of product_name for total studies, average study duration, and study completion rate

 

Unity Catalog:.”purgo_playground.study_product_analysis”