> ## Documentation Index
> Fetch the complete documentation index at: https://anaconda.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Anaconda Assistant

The Anaconda Assistant is an intuitive chat interface to help you generate, explain, and debug code, learn new topics, and more.

To access the Assistant, click **Chat-based Python help** under **Anaconda Assistant**.

## Ask the Assistant

Use the Assistant to create Python code for analyzing your data.

1. Under **Help with coding tasks**, click **Generate python code to…**.
2. Pose prompts to the Assistant for guidance on analyzing the data in your workbook.
3. When provided code to run, set the placement in your workbook and click **Run**.

## Generate a chart

Use the Assistant to create Python code for rendering charts.

1. Under **Work with Tables and Ranges**, click **Generate a chart from a table or range**.

2. Click the input cell that appears, then, in the dropdown, select a specific sheet or manually select a range of cells.

3. The Assistant provides a list of possible charts it can generate Python code for. Use the text box to choose which chart you would like generated or to ask for a new set of possibilities. Type something like the following:

   * 1
   * Generate the second idea
   * chart #3, please
   * Give me new options!

4. Once the Assistant has provided the code, click the **Placement in Workbook** cell and select a cell in your workbook to render the code.

5. Click **Run**.

   <Frame>
     <img src="https://mintcdn.com/anaconda-29683c67/RrcW9wMhKvv6SrIo/images/assistant_chart.png?fit=max&auto=format&n=RrcW9wMhKvv6SrIo&q=85&s=78edb26ebf3ff5415d550028abcc82df" alt="" width="1922" height="1082" data-path="images/assistant_chart.png" />
   </Frame>

6. The chart renders in the cell you set under **Output**. To view an enlarged copy of the chart, select the cell, then click **Create Reference**.

   <Frame>
     <img src="https://mintcdn.com/anaconda-29683c67/9H-5W4tTlP7-Fn32/images/assistant_chart_render.png?fit=max&auto=format&n=9H-5W4tTlP7-Fn32&q=85&s=ac5bb0d229eecdd24c2fa71ae7bbb61d" alt="" width="1922" height="1082" data-path="images/assistant_chart_render.png" />
   </Frame>

## Aggregate or summarize a table or range

Use the Assistant to create Python code to aggregate your data.

1. Under **Work with Tables and Ranges**, click **Aggregate or summarize a table or range**.

2. Click the input cell that appears, then, in the dropdown, select a specific sheet or manually select a range of cells.

3. The Assistant provides a list of possible calculations it can generate Python code for. Use the text box to choose which chart you would like generated or to ask for a new set of possibilities. Type something like the following:

   * 1
   * Generate the second idea
   * calculation #3, please
   * Give me new options!

4. Once the Assistant has provided the code, click the **Placement in Workbook** cell and select a cell in your workbook to render the code.

5. Click **Run**.

   <Frame>
     <img src="https://mintcdn.com/anaconda-29683c67/GDUTnZBDljPyzxUW/images/aggregate_render.png?fit=max&auto=format&n=GDUTnZBDljPyzxUW&q=85&s=4f1b54ff8a88fe8263fc2f9dfa7041f2" alt="" width="1922" height="1082" data-path="images/aggregate_render.png" />
   </Frame>

6. The results render in the cell you set under **Output**.

   <Note>
     If the results shows up in the Diagnostics pane, manually remove the `print(` and closing `)` from the formula bar above the sheet.
   </Note>

## Start a new chat

To start a new chat, click **New Chat**.

<Frame>
  <img src="https://mintcdn.com/anaconda-29683c67/suT8p96bcArryiKX/images/new_chat.png?fit=max&auto=format&n=suT8p96bcArryiKX&q=85&s=c9ae75da03ffc768afbc01e9ba78443c" alt="" width="1922" height="1035" data-path="images/new_chat.png" />
</Frame>
