Writing queries
Describe your tables and the question; get SQL with comments explaining each part.
use-cases/data-analysis
Use case · data and analytics
Data analysis with GLM-5
GLM-5 can turn a question about your data into a SQL query or a pandas script, explain what the result means, and spot problems in messy tables. GLM-5.3 Flash can also read a chart or a screenshot of a dashboard. Here is how to use it safely.
Which modelGLM-5.3Use GLM-5.3 for complex queries, statistical reasoning and multi-step analysis. Use GLM-5.3 Flash to read charts and dashboard screenshots, or for quick formulas.
§ 01What it does well
Data tasks GLM-5 handles well
Python and pandas
Ask for a script to clean, join or aggregate data, with checks for missing values.
Explaining results
Paste a result table and ask what it shows, what it does not show, and what to check next.
Reading charts
Attach a chart image to GLM-5.3 Flash and ask for the key trends and any odd points.
§ 02Prompts
Copy-ready prompts
Open any prompt in the chat, then replace the bracketed parts with your own material.
Question to SQL
I have these tables: [describe tables and columns]. Write a SQL query for [question]. Use CTEs, comment each step, and point out any assumptions you made about the data.
Clean a dataset
Write a pandas script that loads [file], fixes these problems: [list problems], and prints a short report of what changed. Include checks for missing values and duplicates.
Explain a result
Here is the output of my analysis. Explain in plain language what it shows, what it does not prove, and three follow-up questions I should check. [paste table]
§ 03Tips
Do this, avoid that
Do
- Describe the schema and data types.
- Use sample or anonymised data.
- Ask it to state its assumptions.
- Run the code and check the numbers yourself.
Avoid
- Do not paste personal or confidential records.
- Do not trust totals you have not verified.
- Do not confuse correlation with causation.
- Do not run destructive queries without review.
§ 04FAQ
Questions
Q01Can GLM-5 run my code or query my database?
Not in our chat. It writes the code; you run it in your own environment and paste back the results if you want an explanation.
Q02Can I upload a CSV file?
The chat does not accept file uploads. Paste a sample of the rows as text, or a screenshot for GLM-5.3 Flash.
Q03Which model is best for analysis?
GLM-5.3 for complex, multi-step reasoning; GLM-5.3 Flash for charts and quick tasks.
§ 05More
Other use cases
Try it now
Ask GLM-5.3 something real.
No account, no card, no install. Type a question and watch GLM-5.3 Flash answer in seconds — switch to GLM-5.3 for the hardest problems.
Open the free chatFree daily limits apply so the chat stays open for everyone.