From Raw CSV to Insightful Report: A Data Analysis Task for Lexi

In the world of business, data is everywhere. It flows in from customer feedback forms, sales logs, user activity trackers, and market research tools. Often, this valuable information sits dormant in raw file formats like CSVs—a treasure trove of insights waiting to be unlocked. The problem? The process of transforming that raw data into a clean, actionable report is traditionally a manual, time-consuming, and resource-intensive endeavor.

It involves downloading files, wrangling spreadsheets, writing scripts, and meticulously crafting summaries. This is a workflow that pulls your team away from strategic thinking and mires them in tactical execution. But what if you could delegate this entire process to a dedicated team member who works at the speed of software?

Meet Lexi, your autonomous AI digital worker. Lexi isn't just a tool; it's a new kind of employee you can hire via an API. It's designed to understand high-level goals and autonomously execute the complex, multi-step workflows required to achieve them. Let's walk through how you can assign Lexi a common business task: analyzing a raw CSV of user feedback and generating a comprehensive report.

The Challenge: The Manual Data Grind

Imagine you've just received the quarterly user feedback log, user-feedback-Q3.csv. Your goal is to understand general sentiment and identify key themes. The traditional workflow looks something like this:

1. Open the File: Load the CSV into Excel, Google Sheets, or a data analysis environment like a Jupyter Notebook.
2. Clean & Process: Scan the data for inconsistencies.
3. Analyze Sentiment: Manually read through hundreds or thousands of feedback entries, tagging each one as positive, negative, or neutral. Or, write a script using a sentiment analysis library.
4. Categorize & Summarize: Group the feedback by sentiment, count the occurrences, and try to pull out common topics or requests within each category.
5. Build the Report: Compile all these findings into a presentable document with charts, summaries, and key takeaways for management.

This entire process can take hours, if not days, and requires a specific skill set. With Lexi, you can condense it into a single API call.

The Solution: Assigning the Task to Lexi

Lexi operates on the .do platform, turning intricate processes into simple, on-demand services. Instead of giving a machine a list of rigid commands, you give Lexi a goal in plain English, just as you would with a human team member.

Here’s how you can hire Lexi and assign this data analysis task using the .do SDK:

import { Do } from '@do-inc/sdk';

// Initialize the platform client
const secret = new Do(process.env.DO_API_KEY);

// Hire Lexi, the autonomous digital worker
const lexi = secret.agent('lexi');

// Assign a task to Lexi with a specific goal
const result = await lexi.run({
  task: "Analyze the attached user feedback logs, categorize them by sentiment, and generate a summary report.",
  attachments: ["user-feedback-Q3.csv"]
});

// Get the structured output from Lexi
console.log(result.reportUrl);

Let's break down what's happening here. It's powerful in its simplicity.

Step 1: Hiring Your Digital Worker

const lexi = secret.agent('lexi');

This line isn't just initializing a library; it's the equivalent of hiring a specialist for a job. You are programmatically onboarding Lexi, an autonomous agent ready to take on complex knowledge work.

Step 2: Defining the Goal

task: "Analyze the attached user feedback logs, categorize them by sentiment, and generate a summary report."

This is the core of the agentic workflow. Notice you're not telling Lexi how to perform sentiment analysis or what chart type to use. You are providing a high-level objective. Lexi uses its built-in capabilities to understand this goal and formulate a plan to achieve it. It knows what "analyze," "categorize by sentiment," and "generate a summary report" mean in a business context.

Step 3: Providing the Materials

attachments: ["user-feedback-Q3.csv"]

Here, you're giving Lexi the raw material it needs to get started. Because Lexi is designed for integration, it can also be configured to securely access data from your cloud applications, databases, and other internal tools.

Step 4: Receiving the Finished Product

console.log(result.reportUrl);

The task doesn't return a messy string of data. Lexi delivers a structured, predictable output. In this case, it’s a URL pointing to a fully generated report, ready for you to review and share with your team. You've successfully transformed a services problem (data analysis) into a software solution (an API that returns a report).

What Does Lexi Do? The Autonomous Agentic Workflow

When you assign this task, Lexi initiates an autonomous workflow. While the exact steps are dynamic, here’s what’s happening behind the scenes:

1. Deconstruction: Lexi parses the natural language instruction to understand the core objectives: analyze a CSV, perform sentiment analysis, and create a report.
2. Planning: It formulates a multi-step execution plan. This might include reading the CSV, identifying the feedback column, applying a sentiment analysis model to each row, aggregating the results, extracting key themes, and structuring the data for a final summary.
3. Execution: Lexi uses its internal toolset—which can include data analysis libraries, language models, and reporting engines—to execute the plan step-by-step.
4. Generation: It compiles the findings into a polished, human-readable report and delivers the result as a secure, structured output.

The Future of Business Automation is Here

This example is just the beginning. Lexi can be hired to perform a vast range of knowledge-based tasks that have traditionally resisted automation:

• Conducting market research on competitors.
• Summarizing long legal documents into key points.
• Monitoring social media for brand mentions and creating a daily digest.
• Enriching sales leads with publicly available information.

By integrating an autonomous AI worker like Lexi into your applications, you're not just automating a task; you're building a more efficient, intelligent, and scalable organization. You free up your human team to focus on what they do best: strategy, creativity, and building relationships.

Ready to delegate your complex workflows?

Visit lexi.do to learn more and hire your first autonomous AI digital worker today.