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.

  6. The plot renders in the cell you set under Output. Right-click the plot, and in the dropdown select Picture in Cell > Place over Cells.

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.

  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.

Start a new chat#

To start a new chat, click History, then New Chat.