Multiple output response in single query

[Alan-zhong]

When I ask the model to generate multiple types of outputs at once, it returns an error. Example query:

​​"Analyze the 2025 bidding information from the following three perspectives:​​

​​Bidding project analysis​​ (presented in table form).
​​Winning bidder competitiveness analysis​​ (presented as a statistical chart).
​​Risk warnings and recommendations​​ (presented in text form)."
The following two errors occur:

2025-06-30 12:04:06,223 - root - ERROR - 查询处理失败: Invalid output type: multi
Traceback (most recent call last):
File "/home/alan/text2sql/main2_test.py", line 465, in handle_query
response = pai.chat(request.query, *loaded_tables)
File "/home/alan/anaconda3/envs/text2sql_/lib/python3.10/site-packages/pandasai/init.py", line 233, in chat
return current_agent.chat(query)
File "/home/alan/anaconda3/envs/text2sql/lib/python3.10/site-packages/pandasai/agent/base.py", line 88, in chat
return self.process_query(query, output_type)
File "/home/alan/anaconda3/envs/text2sql/lib/python3.10/site-packages/pandasai/agent/base.py", line 267, in process_query
result = self.execute_with_retries(code)
File "/home/alan/anaconda3/envs/text2sql/lib/python3.10/site-packages/pandasai/agent/base.py", line 187, in execute_with_retries
return self.response_parser.parse(result, code)
File "/home/alan/anaconda3/envs/text2sql/lib/python3.10/site-packages/pandasai/core/response/parser.py", line 18, in parse
return self.generate_response(result, last_code_executed)
File "/home/alan/anaconda3/envs/text2sql/lib/python3.10/site-packages/pandasai/core/response/parser.py", line 30, in _generate_response
raise InvalidOutputValueMismatch(f"Invalid output type: {result['type']}")
pandasai.exceptions.InvalidOutputValueMismatch: Invalid output type: multi

result = {'type': 'dictionary', 'value': {'招标项目分析': {'type': 'dataframe', 'value': project_analysis_df}, '中标企业竞争力分析': {'type': 'plot', 'value': 'exports/charts/temp_chart_a70bb68a-fe24-4eeb-9961-bb5b503f9520.png'}, '风险预警及建议': {'type': 'string', 'value': risk_warning}}}
2025-06-30 12:09:25,970 - root - ERROR - 查询处理失败: Invalid output type: dictionary
Traceback (most recent call last):
File "/home/alan/text2sql/main2_test.py", line 437, in handle_query
response = pai.chat(request.query, *loaded_tables)
File "/home/alan/anaconda3/envs/text2sql_/lib/python3.10/site-packages/pandasai/init.py", line 233, in chat
return current_agent.chat(query)
File "/home/alan/anaconda3/envs/text2sql/lib/python3.10/site-packages/pandasai/agent/base.py", line 88, in chat
return self.process_query(query, output_type)
File "/home/alan/anaconda3/envs/text2sql/lib/python3.10/site-packages/pandasai/agent/base.py", line 267, in process_query
result = self.execute_with_retries(code)
File "/home/alan/anaconda3/envs/text2sql/lib/python3.10/site-packages/pandasai/agent/base.py", line 187, in execute_with_retries
return self.response_parser.parse(result, code)
File "/home/alan/anaconda3/envs/text2sql/lib/python3.10/site-packages/pandasai/core/response/parser.py", line 18, in parse
return self.generate_response(result, last_code_executed)
File "/home/alan/anaconda3/envs/text2sql/lib/python3.10/site-packages/pandasai/core/response/parser.py", line 30, in _generate_response
raise InvalidOutputValueMismatch(f"Invalid output type: {result['type']}")
pandasai.exceptions.InvalidOutputValueMismatch: Invalid output type: dictionary

[gventuri]

Hi @Alan-zhong, PandasAI is meant to return only one output type at a time. This is to grant further accuracy, as pipelines are executed to validate the output. We're working on a solution to make it more flexible though. We'll be releasing something soon. In the meanwhile, you could parallelize the differente requests!

[Alan-zhong]

Thank you for your response. Looking forward to your updates regarding these features

[jwsky]

Same, Looking forward to this updates, as the workflow should be better for explorationanalysis

[dosubot]

Hi, @Alan-zhong. I'm Dosu, and I'm helping the pandas-ai team manage their backlog and am marking this issue as stale.

Issue Summary:

• You reported an error when requesting multiple output types (table, chart, text) in a single query.
• PandasAI currently supports only one output type at a time for accuracy and validation.
• The maintainer confirmed this limitation is intentional but mentioned a more flexible solution is in development.
• You and another user expressed interest in the upcoming updates to improve exploratory analysis workflows.

Next Steps:

• Please let me know if this issue is still relevant with the latest version of pandas-ai by commenting here.
• If I don’t hear back within 7 days, this issue will be automatically closed.

Thank you for your understanding and contribution!