Search: "M code"

#design #design system #tokens

design Advanced

Design System Tokens Audit with Component Inventory

Act as a design systems lead. Audit a design system based on a description I wil...

excel Advanced

Excel VBA Macro to Email Each Manager Their Filtered Sheet

Write a VBA macro that splits the Master sheet by [Manager Name], saves each man...

#excel #vba #outlook

#coding #refactoring #clean-code

Refactor a God Function with Multiple Responsibilities

Below is a function that's grown to ~200 lines and does too much. Refactor it. R...

#excel #power-query #data-cleaning

excel Intermediate

Convert a Messy Paste from PDF into a Clean Table

I pasted a table from a PDF into Excel and the data is jumbled — some rows are s...

#javascript #refactoring #es2024

Refactor Legacy JavaScript to Modern ES2024 Standards

Refactor the following legacy JavaScript code to modern ES2024 standards: [PAST...

#coding #review #feedback

Write Idiomatic Code Review Feedback

Review my pull request and write feedback that's specific, actionable, and kind....

#A/B testing #sample size #statistical significance

data Intermediate

A/B Test Sample Size Calculator and Analysis

Help me plan and analyze an A/B test: **Planning Phase:** - Current conversion ...

#chatgpt prompt for retry strategy #background jobs #idempotency

ChatGPT Prompt for Designing a Safe Background Job Retry Strategy

You are a senior backend engineer. Help me design a safe retry strategy for a ba...

ChatGPT Prompt for Refactor Legacy API Handler Safely

I need help refactoring a legacy API handler without breaking behavior. Here is ...

#coding #refactor #api

#data #survey analysis #qualitative research

data Intermediate

ChatGPT Prompt for Survey Open-Text Response Coding Framework

Analyze these open-text survey responses and build a coding framework I can reus...

#code review #debugging #quality

Coding Advanced

Code Review Assistant

Review this code for: bugs, security issues, performance optimizations, code sty...

#python #web scraping #beautifulsoup

ChatGPT prompt for building a Python web scraper with error handling and rate limiting

Act as a senior Python developer specializing in web scraping and data collectio...

#writing #technical-documentation #api

writing intermediate

Technical Documentation for API Endpoints

Write clear technical documentation for the following API endpoint: [paste endpo...

#pandas #EDA #data analysis

data intermediate

Python Pandas Data Analysis Pipeline Exploratory Analysis

Write a Python data analysis script using Pandas for exploratory data analysis (...

#ab-testing #statistics #analytics

data advanced

A/B Test Analysis Statistical Significance Calculator Guide

Walk through a complete A/B test analysis for [experiment, e.g., testing two ema...

excel advanced

Excel Power Query Data Transformation Masterclass

You are a Power Query specialist. I have raw data that needs cleaning and transf...

#excel #power-query #etl

#power query #data cleaning #ETL

excel intermediate

Excel Power Query: Clean & Transform Raw Data Automatically

I have raw data in Excel that needs cleaning and transformation. Help me build a...

#machine learning #model evaluation #classification metrics

data Advanced

Machine Learning Model Evaluation: Metrics and Performance Guide

Help me understand and implement proper machine learning model evaluation for my...

#data #visualization #charts

data intermediate

Data Visualization Recommendation and Code Generator

Help me choose and create the best data visualizations for my dataset. Details: ...

#coding #testing #flaky-tests

Debug a Flaky Test That Passes Locally but Fails in CI

I have a test that passes locally but fails ~30% of the time in CI. Walk me thro...

#coding #debugging #flaky-tests

Diagnose a Flaky Test From Logs Alone

Act as a senior test engineer. The test {{test name}} fails in CI roughly {{freq...

Generate a SQL Migration With Safe Rollback

Act as a database engineer. Write a {{database: e.g., PostgreSQL 15}} migration ...

#coding #sql #migration

#memory leak #nodejs #debugging

Debug Memory Leak in Long-Running Node.js Process

I have a Node.js process leaking memory. RSS grows from 200MB to 2GB over 6 hour...