openai-assistant-code-interpreter.cs

var azureClient = new AzureOpenAIClient(new Uri(endpoint), new ApiKeyCredential(key));

OpenAIFileClient fileClient = azureClient.GetOpenAIFileClient();
AssistantClient assistantClient = azureClient.GetAssistantClient();

OpenAIFile infoFile = await fileClient.UploadFileAsync("C:\\Customers.xlsx", FileUploadPurpose.Assistants);

AssistantCreationOptions assistantOptions = new()
{
    Name = "CodeInterpreterProMAX",
    Instructions =
    "You are an assistant that looks up sales data and helps visualize the information based"
    + " on user queries. When asked to generate a graph, chart, or other visualization, use"
    + " the code interpreter tool to do so.",
    Tools =
    {
        new CodeInterpreterToolDefinition()
    },
    ToolResources = new()
    {
        CodeInterpreter = new()
        {
            FileIds = { infoFile.Id },
        }
    }
};

Assistant assistant = assistantClient.CreateAssistant(deploymentName, assistantOptions);

ThreadCreationOptions threadOptions = new()
{
    InitialMessages = { "Which customer has purchased the most licenses?" },
};

ThreadRun threadRun = assistantClient.CreateThreadAndRun(assistant.Id, threadOptions);

do
{
    Thread.Sleep(TimeSpan.FromSeconds(1));
    Console.WriteLine($"Thread run status: {threadRun.Status}");
    threadRun = assistantClient.GetRun(threadRun.ThreadId, threadRun.Id);
} while (!threadRun.Status.IsTerminal);


CollectionResult<ThreadMessage> messages = assistantClient.GetMessages(threadRun.ThreadId, new MessageCollectionOptions() { Order = MessageCollectionOrder.Ascending });

foreach (ThreadMessage message in messages)
{
    Console.Write($"[{message.Role.ToString().ToUpper()}]: ");
    foreach (MessageContent contentItem in message.Content)
    {
        if (!string.IsNullOrEmpty(contentItem.Text))
        {
            Console.WriteLine($"{contentItem.Text}");
        }
    }
}

output.md

[USER]: Which customer has purchased the most licenses?

[ASSISTANT]: Let's first take a look at the content of the uploaded file to understand its structure. I'll load the file and inspect the first few rows of data.

[ASSISTANT]: The data contains information about customers, including their names, email addresses, the number of licenses they purchased, and the total amount they paid.

To identify the customer who has purchased the most licenses, we will find the customer with the maximum value in the "Licenses Purchased" column.

[ASSISTANT]: The customer who has purchased the most licenses is Alice Johnson, with a total of 25 licenses purchased.