Analyzing Cold Chain Temperature Data: Violation Detection and Insights

Introduction: Cold chain temperature monitoring involves tracking and analyzing temperature data throughout the supply chain to ensure compliance with storage requirements. This process helps identify any violations and enables the aggregation of temperature data for detailed analysis, ensuring product safety and quality.

 

Requirements :

 

'purgo_playground.cold_chain_temperature'

 

Identify the violation based on temperature range, when below temperature maximum -8.0 degree and temperature minimum 0.0 degree. When violations founds beyond range make it yes. Aggregate the data by location with average temperature and count of violation founds to be yes.

 

Final Output: Show the output of existing table with violations of temperature and show the result of aggregation count of violations.

 

Write the Pyspark code without syntax error.

 

Unity Catalog details: 'purgo_playground.cold_chain_temperature'