Batch Quality Analysis and Production Summary
Requirement
Introduction: Evaluating the quality of batches by determining the pass and fail status for each product, calculating the percentage of successful batches, and providing a summary of batch production details.
Requirements:
Read the table 'purgo_playground.batch_qc'.
calculate the quality status by column of quality check score is less than 97 is fail.
calculate the product wise batches with product name of total batches, passed batches, failed batches and percentage of batches.
calculate the batchwise summary of production with total batches, total passed batches, total failed batches.
Final output: product wise analysis, batch wise quality status with batch id, product name and quality score, batch wise summary of production.
Write the pyspark code without syntax error.
Unity Catalog Details: 'purgo_playground.batch_qc'