services/answer_generator.py

import ollama


def generate_final_answer(
    question,
    result,
    metadata=None
):

    prompt = f"""
You are a professional data analyst.

Question:
{question}

Analysis Result:
{result}

Write a short natural-language answer.

Rules:
- Answer directly.
- Mention the metric name if obvious.
- Round long decimals to 3 digits.
- Do not mention Python code.
- Do not explain your reasoning.
"""

    response = ollama.chat(
        model="qwen2:7b",
        messages=[
            {
                "role": "user",
                "content": prompt
            }
        ]
    )

    return response["message"]["content"]