Data Visualization Part II

解决方案架构

AI 应用层

Text 2 Data Vis 解决方案

Steps

• text to params

  • given prompt template and example selectors

    • extract measures, metrics, dimensions and conditions from text

• text to sql

  • given prompt template and example selectors

    • prompt template (pseudo code)

      select {metrics, dimensions} from {#source table} group by {measure} where {conditions}

• data to chart

Key Components

• LLama2
• SQLDatabaseChain
• Ollama
• pandas

Todos

• TBD

References

• facebookresearch / This demo shows how to use LangChain's SQLDatabaseChain with Llama2 to query structured data stored in a SQL DB.

• langchain / LLaMA2 chat with SQL

• langchian / qa_structured