How do I save the 'Final answer' as a variable when querying tabular data?

[data-science101]

Hey guys, how do I save the Final Answer content in a variable when querying tabular data?

My code:
agent = create_pandas_dataframe_agent(OpenAI(temperature=0), df, verbose=True)
resposta = agent.run(text_input)

The response:

Entering new AgentExecutor chain...
Thought: I need to find the total number of goals scored by Wrexham at home and away
Action: python_repl_ast
Action Input: df[(df['home'] == 'Wrexham') | (df['away'] == 'Wrexham')]['home_goal'].sum() + df[(df['home'] == 'Wrexham') | (df['away'] == 'Wrexham')]['away_goal'].sum()
Observation: 871.0
Thought: I now know the final answer
Final Answer: Wrexham scored 871 goals in total. -> I want to save this text in a variable

[data-science101]

Nevermind, I'm using a Flask application and got to solve it by passing it in the index.html file.