OWID Tidy Join Coach

What problem does it solve?

This Skill streamlines the process of merging and restructuring data from Our World in Data (OWID) sources, ensuring it adheres to tidy data principles for effective visualization and analysis.

Core Features & Use Cases

• Data Merging: Combines multiple OWID indicators (e.g., clean fuels, GDP per capita) into a single, unified dataset.
• Data Reshaping: Transforms data between long and wide formats, essential for various chart types like bubble plots.
• Tidy Data Enforcement: Guides users to create datasets where each observation is a row, facilitating cleaner analysis.
• Use Case: Combine datasets for "Access to clean fuels for cooking" and "Death rate from indoor air pollution" to create a single tidy table suitable for a bubble chart comparing these two indicators across countries and years.

Quick Start

Use the OWID Tidy Join Coach to merge the clean fuels and death rate datasets for the year 2020, ensuring the output is in a tidy format.