How to Join and Visualize Multiple Datasets in Vega-Lite

Observable Reference Code: https://observablehq.com/@viscourse/t...
Prior video:    • Mastering Data Filters in Vega-Lite: ...  

code:
vl.markCircle()
.data({
'url': 'https://raw.githubusercontent.com/lac...
})
.transform(
vl.lookup('Id')
.from(
vl.data({
'url': 'https://raw.githubusercontent.com/lac...
})
.key('Id')
.fields('economic_damages')
),
vl.groupby('Year', 'disaster')
.aggregate([
vl.sum('economic_damages').as('Total_Damages'),
vl.sum('deaths').as('Total_Deaths')
])
)
.encode(
vl.x().fieldT('Year'),
vl.y().fieldN('disaster')
.sort(vl.average('Total_Deaths').order('descending')),
vl.size().fieldQ('Total_Deaths'),
vl.tooltip().fieldQ('Total_Damages')
)
.width(600)
.render()

In this video, Dr. Padilla walks you through the process of joining multiple datasets in Vega-Lite, a powerful technique that allows you to combine and analyze complex data. While joining data in Vega-Lite can be more challenging compared to other programming languages like R or Python, this tutorial provides a real-world example to help you master the process. Learn how to use the lookup function to link datasets by key fields, aggregate data, and visualize the combined information effectively.

Throughout the video, you'll see how to connect two datasets: one containing total deaths from natural disasters and another detailing economic damages. Dr. Padilla demonstrates step-by-step how to integrate these datasets, providing insights into how to handle common challenges such as matching keys and dealing with messy data.

Whether you're new to Vega-Lite or looking to enhance your data visualization skills, this tutorial offers valuable tips and practical examples to help you better understand and apply the join transform in your projects.

Timestamps:
00:00 Introduction to Joining Datasets in Vega-Lite
01:45 Overview of the Datasets Used
03:30 Writing the Lookup Function
07:15 Aggregating Data for Visualization
10:00 Troubleshooting Common Issues
12:45 Finalizing the Visualization
14:00 Tips for Customizing and Enhancing Your Visuals
Resources:

Previous Video: Filtering Data in Vega-Lite:    • Mastering Data Filters in Vega-Lite: ...  

If you find this tutorial helpful, don't forget to like, subscribe, and hit the notification bell to stay updated with more Vega-Lite tips and tutorials!