Gemini Code Execution Mastery — 12 Prompts

Run Python Code Directly Inside Gemini — Analyze, Visualize, Automate

Gemini can write AND execute Python code in a sandboxed environment. These 12 prompts are engineered to leverage code execution for tasks that need actual computation — not just text generation. Upload your data, get real charts, real statistics, and real results.

What's Inside (12 Code Execution Prompts)

• CSV Data Analysis with Visualization — Upload any CSV file. Prompt generates and runs: summary statistics, missing value analysis, correlation matrix, distribution plots, and outlier detection. Returns actual matplotlib charts.
• Web Scraping with BeautifulSoup — Scrape structured data from any public webpage. Prompt handles pagination, table extraction, nested elements, and exports to clean CSV format. Includes error handling for common scraping issues.
• API Testing and Debugging — Test REST APIs with various HTTP methods, headers, and payloads. Validates response schemas, measures latency, and generates test reports with pass/fail status.
• Statistical Analysis with SciPy — Run hypothesis tests, ANOVA, regression analysis, and distribution fitting on your data. Returns p-values, confidence intervals, and publication-ready statistical summaries.
• Machine Learning Model Training — Train classification or regression models on your dataset using scikit-learn. Includes data splitting, feature engineering, model comparison, cross-validation, and performance metrics.
• Image Processing with PIL — Batch resize, crop, watermark, convert formats, adjust brightness/contrast, and generate thumbnails. Processes uploaded images and returns modified versions.
• PDF Text Extraction — Extract text, tables, and metadata from PDF files. Handles multi-column layouts, headers/footers, and outputs clean structured text or JSON.
• Database Query Optimization — Paste your SQL queries and schema. Prompt analyzes execution plans, suggests index improvements, rewrites slow queries, and benchmarks before/after performance.
• Regex Pattern Builder — Describe what you want to match in plain English. Prompt generates the regex, tests it against your sample data, explains each component, and handles edge cases.
• Financial Calculation with NumPy — Compound interest, loan amortization, portfolio returns, Monte Carlo simulation, and risk analysis. Returns calculated results with interactive charts.
• Data Cleaning Pipeline — Upload messy data. Prompt builds and runs a complete cleaning pipeline: deduplication, format standardization, missing value imputation, outlier handling, and validation report.
• Automated Report Generation — Transform raw data into a formatted report with executive summary, key metrics, trend analysis, charts, and recommendations. Outputs as HTML or markdown.

How to Use

1. Open Google AI Studio
2. Enable Code Execution in the model settings
3. Copy the prompt and upload your data file (if applicable)
4. Gemini writes the Python code, runs it, and returns results with visualizations
5. Download generated files (charts, CSVs, reports) from the output

Works With

Google AI Studio with Code Execution enabled, Gemini API with code_execution tool. Python libraries available: pandas, numpy, scipy, matplotlib, scikit-learn, PIL, beautifulsoup4, requests.