{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/a2006ac27b0545189cb5b9b2e011bc72\" frameborder=\"0\" width=\"1728\" height=\"1296\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1296,"width":1728,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1296,"thumbnail_width":1728,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/a2006ac27b0545189cb5b9b2e011bc72-00001.gif","duration":179.8333333333333,"title":"SmartDatalake on PandasAI: converse with multiple dataframes","description":"Summary\n👉 Notebook: https://colab.research.google.com/drive/1ZnO-njhL7TBOYPZaqvMvGtsjckZKrv2E?authuser=1\n\nIn 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's data frame and a seller's data frame to determine who gets paid the most. Additionally, I show how to merge two different data frames, even when they don'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."}