Query Your CSV using LIDA: Automatic Generation of Visualizations with LLMs

Welcome to my tutorial on "Query Your CSV using LIDA: Automatic Generation of Visualizations with LLMs"! In this video, I'll guide you through the Streamlit app, which leverages the power of LIDA for on-the-fly graph generation based on your queries.

Diving deep into LIDA, it's a state-of-the-art tool designed for the automatic creation of grammar-agnostic visualizations and infographics. Its foundation is built on the intricate synergy between large language models (LLMs) and image generation models (IGMs). Here's a quick breakdown of LIDA's components:

SUMMARIZER: Transforms data into a concise natural language summary.
GOAL EXPLORER: Enumerates the potential visualization objectives given the data at hand.
VISGENERATOR: Responsible for generating, refining, executing, and filtering the visualization code.
INFOGRAPHER: Produces stylized graphics that stay true to the original data, powered by IGMs.
Not only does LIDA come with a handy Python API, but it also offers a versatile user interface that allows for both direct manipulation and multilingual natural language inputs. Whether you're keen on crafting interactive charts, infographics, or captivating data stories, LIDA has got you covered!

If you found this tutorial helpful, please don't forget to like, comment, and subscribe for more insightful content! Thanks for your support.

#ai #generativeai #python

[ayush_singh_]

can you help me out in something - I want to establish a relation between multiple tables who are dependent upon each other and i want to query a search to retrieve some data that is dependent on other table . how can i establish relation between them so that my Gen ai chat interface can fetch data and process the user query and return the correct response ?

[RedCloudServices]

wait..can this tool simply allow chat with csv better than previous options? does every answer have to be a graph?

[priyanshudubey]

Sir please make a playlist of Natural Language Processing. Your explanation is too good and easy to digest.

[sohailshaik]

Hi Bro
This code is not working with Azure OpenAI credentials.Can you help me out if you are aware of the solution

[CesarVegaL]

Thank you for your work. Very up-to-date, so it is appreciated.

[PurushothamReddy-ffvp]

Hello, is there anyway to return the raster image directly into the streamlit rather than converting it into images? i lose a a lot of functionality when im converting into an image.

[latentbhindi]

Does this give good results for non-numeric data or rather a dataset which is a mixture of numeric and non-numeric data?

[vaibhavsinghania]

hello . I am getting TypeError: 'OpenAI' object is not callable. After having tried everything. Can someone pls help? sir?

[NileshKumarPandey-vrpw]

is there any graph representation module I can use with LAMA3 with Ollama?

[wptgkft]

I am getting error: streamlit:command not found. Even after pip installing it.

[myfc]

Hi, thanks for the video, on the part of the open source (llama2) or other model like Groq, Gemini Pro, it is not so clear to set it up. Any chance you could drop the code here to set it up. That would be a great help. TQ

[rameshh]

Does this work with SQL Agent/ SQL chain?

[yuvrajharsh]

Thanks a lot for making this video Sir.

[muhammadtalmeez]

Can it answer the questions from data like: which country has highest happy rate?

[iuidehx]

Amazing idea... Thank you for this video.

[ironman]

Which version of llmx to use on windows?

[jillanisofttech]

sir can you build proper application using this model and like chat with lida and also have memoery store function please. Proper End to End project b ban jyee ga

[tsxucis]

ModuleNotFoundError: No module named 'lida' if i run i got this error why?

[aadarshjain]

Hey there,
Can we use LIDA without using any API Key, Can we fully download all the things in our system locally as the Base Model / LLM and then apply prompt Engineering or Fine Tuning on that model/LLM with our own data ( That may be confidential ).
I want to perform Data Analytics Task on Specific data and therefore i am looking for the open source LLM's to download them locally as the Base Model and then Train it on Specific Data to answer my queries on the same (Not only Summarization but also Visualization ).

[roshansawant]

ImportError: cannot import name 'AzureOpenAI' from 'openai'

any solution?