<?xml version="1.0" encoding="UTF-8"?><oembed><type>video</type><version>1.0</version><html>&lt;iframe src=&quot;https://www.loom.com/embed/a2006ac27b0545189cb5b9b2e011bc72&quot; frameborder=&quot;0&quot; width=&quot;1728&quot; height=&quot;1296&quot; webkitallowfullscreen mozallowfullscreen allowfullscreen&gt;&lt;/iframe&gt;</html><height>1296</height><width>1728</width><provider_name>Loom</provider_name><provider_url>https://www.loom.com</provider_url><thumbnail_height>1296</thumbnail_height><thumbnail_width>1728</thumbnail_width><thumbnail_url>https://cdn.loom.com/sessions/thumbnails/a2006ac27b0545189cb5b9b2e011bc72-00001.gif</thumbnail_url><duration>179.8333333333333</duration><title>SmartDatalake on PandasAI: converse with multiple dataframes</title><description>Summary
👉 Notebook: https://colab.research.google.com/drive/1ZnO-njhL7TBOYPZaqvMvGtsjckZKrv2E?authuser=1

In this video, I demonstrate how to work with multiple data frames using Pandacea. I introduce the concept of a smart data lake, which allows us to perform tasks involving more than one data frame at a time. I provide an example using an employee&apos;s data frame and a seller&apos;s data frame to determine who gets paid the most. Additionally, I show how to merge two different data frames, even when they don&apos;t have a common field. Finally, I showcase how a smart data lake can help us analyze data, such as determining the number of photos uploaded by a specific user.</description></oembed>