Introduction

At its core, data analysis is about using data to inform decisions. The goal isn’t analysis for its own sake. It’s to produce an artifact that helps someone act: a chart for leadership, an experiment readout for a product team, a model evaluation for researchers, or a dashboard that guides daily operations.

A useful framework, popularized by R for Data Science, is a loop: import and tidy data, then iterate between transform, visualize, and model to build understanding before you communicate results.

ChatGPT Work fits well into this workflow. It helps you clean data, explore hypotheses, generate analyses, and produce reproducible artifacts. The target isn’t a one-off notebook. It’s an analysis that other people can review, trust, and rerun.

Define your use case

Choose one concrete question you want to answer with your data. The more specific the question, the easier it is to identify the right inputs, checks, and result.

Running example: Property values near the highway

As an example, we’ll explore the following question:

To what extent are houses near the highway lower in property valuation?

Suppose one dataset contains property values or sale prices, and another contains location, parcel, or highway-proximity information. The work isn’t only to run a model. It’s to make the inputs trustworthy, document the joins, pressure-test the result, and end with an artifact that somebody else can use.

You can attach CSVs or Excel workbooks, name an approved Google Sheet with @google-drive, or use the desktop app when your data is stored on your computer.

ChatGPT Work

Import the data

Start by attaching the files and asking ChatGPT to inspect them. This helps answer basic but important questions:

• What file formats are here?
• What does each dataset seem to represent?
• Which columns might be targets, identifiers, dates, locations, or measures?
• Where are the clear quality issues?

Don’t ask for conclusions yet. Ask for inventory and explanation first.

Tidy and merge the inputs

Most real work starts here. You have two or more datasets, the primary key isn’t clear, and a naive merge could lose data or create duplicates.

Ask ChatGPT to profile the merge before performing it:

• Check uniqueness for candidate keys.
• Measure null rates and formatting differences.
• Normalize clear formatting issues such as casing, whitespace, or address formatting.
• Run trial joins and report match rates.
• Recommend the safest merge strategy before it writes the final merged file.

If you need to derive the best key, such as a normalized address, a parcel identifier built from a few columns, or a location join, ask ChatGPT to explain the tradeoffs and edge cases before you accept the merge.

Explore with charts

Use charts to understand the data before choosing a model. In the running example, compare homes near the highway with homes farther away, examine outliers, inspect missing-value patterns, and check whether the apparent effect reflects neighborhood composition, home size, or another factor.

Keep each chart tied to the original question. Save the useful comparisons so another person can inspect the analysis.

Model the question

Not every analysis needs a complex model. Start with an interpretable baseline.

For the highway question, a sensible first pass is a regression or other transparent model that estimates the relationship between highway proximity and property value while controlling for relevant factors such as size, age, and location.

Ask ChatGPT to be explicit about:

• The target variable and feature definitions.
• Which controls to include and why.
• Leakage risks and exclusions.
• How it chose the split, evaluation, or uncertainty estimate.
• What the result means in plain language.

If the first model is weak, that’s still useful. It tells you whether the problem is the model, the features, the join quality, or the question itself.

Communicate the result

The analysis is only useful when someone else can consume it. Ask ChatGPT to produce the artifact the audience needs:

• A Markdown memo for technical collaborators.
• A spreadsheet or CSV for downstream operations.
• A formatted document or PDF for decision-makers.
• A notebook, dashboard, or static report for a reusable analysis.

Ask it to include caveats. If the join quality is imperfect, sampling bias is present, or model assumptions are fragile, the deliverable should say so plainly.

Optional: set up a Python environment

If the project needs reusable scripts or a notebook, ask ChatGPT to use the existing Python environment or set up a small, reproducible one. Keep source files unchanged and save the analysis, charts, and final report separately. You don’t need to set up Python before analyzing attached files in ChatGPT Work.

Suggested prompts

Load the datasets and explain them

Check the merge before joining

Build an interpretable first model

Package the results for stakeholders