Approach to Unstructured Data

Describe your approach when you are given a large, unstructured dataset and asked to begin your analysis for Energy Aspects’ data-driven insights.

Use the provided tables to demonstrate the initial analysis by producing a trustworthy monthly summary from the raw observations.

Output

1. One row per commodity, region, and observation month.
2. Columns: commodity_name, region, observation_month, average_price, observation_count, and source_count.
3. Include only active commodities and sources, valid positive USD-per-barrel observations, and non-empty regions. Sort by commodity, region, and month ascending.