Gemini Built-in Code Execution: Python Sandbox Mastery

{
  "tools": [
    {
      "codeExecution": {}
    }
  ]
}

Solve this problem step by step:

1. Write Python code to solve the problem
2. Execute the code and report the output
3. If the output matches expectations, explain why it's correct
4. If the output is wrong, analyze what went wrong, fix the code,
   and re-execute
5. Repeat until correct, or report that you can't solve it after 3 attempts

PROBLEM: Calculate the probability of drawing at least two aces
in a 5-card poker hand dealt from a standard 52-card deck.
Show your work.

I'll provide a dataset. Use code execution to analyze it.

1. Load the data into a pandas DataFrame
2. Run descriptive statistics: mean, median, std, quartiles for all
   numeric columns
3. Identify and report any outliers (values > 3 std from mean)
4. Generate a correlation matrix for numeric columns
5. Create visualizations (matplotlib):
   - Histogram of the primary metric
   - Scatter plot of the two most correlated variables
   - Box plot by category if categorical columns exist
6. Summarize the 3 most important findings from the analysis

DATA:
[your dataset]

APPROACH: Iterative improvement

1. Start with the simplest approach that might work
2. Write code, execute, observe results
3. Based on results, refine the approach
4. Repeat until the solution is optimal or 5 iterations pass

At each iteration, report:
- Approach: what you're trying
- Code: the implementation
- Results: what happened when executed
- Insights: what you learned
- Next step: what you'll try differently

PROBLEM: Find the shortest path through a 50-city traveling
salesman problem using heuristic approaches. Cities are at
random coordinates in a 100x100 grid.

For any calculation in your response:
1. Show the formula
2. Implement it in Python and execute
3. Report the computed result
4. Compare with your text answer

If there's a discrepancy, the computed result is authoritative.

Calculate the compound annual growth rate of an investment
that grew from $10,000 to $52,000 over 8.5 years. Use Python
to compute the exact value and show the formula.

What's the CAGR for $10K to $52K over 8.5 years?

Please use the code_execution tool to compute this.

For any code execution:

1. Wrap your main logic in a try/except block
2. Catch specific exceptions (ValueError, ZeroDivisionError, etc.)
3. If execution fails:
   a. Report the exact error message
   b. Explain what caused it in plain language
   c. Attempt a fix and re-execute (max 2 retries)
4. If execution times out:
   a. Report that the computation was too expensive
   b. Suggest an optimized or approximate approach

Never silently fail. Always report errors.

Create a visualization of this sales data:

Month,Product A,Product B,Product C
Jan,1200,900,1500
Feb,1350,950,1400
...

Generate:
1. A line chart showing all three products over time
2. A stacked bar chart showing monthly composition
3. A pie chart of total annual sales by product

For each chart:
- Include title, axis labels, and legend
- Use a professional color scheme
- Display the chart
- Provide 2-3 sentences interpreting what the chart shows