Search: "code-review"

#conditional formatting #KPI #dashboard

excel Intermediate

Conditional Formatting Rules for KPI Dashboards

I need to set up conditional formatting in Excel for a KPI dashboard. My spreads...

#debug api integration #production bug #troubleshooting prompt

ChatGPT prompt for debugging a flaky API integration in production

You are a senior backend engineer helping diagnose a flaky API integration in pr...

#legacy api documentation #refactor preparation prompt #endpoint behavior mapping

ChatGPT prompt for documenting a legacy API endpoint before refactoring

Act as a senior software engineer doing archaeology on legacy code. I need to do...

#data cleaning #csv #pandas

data Intermediate

ChatGPT prompt for creating a data cleaning pipeline for messy CSV files

Act as a senior data engineer who specializes in data quality and ETL pipelines....

#coding #regex #validation

coding intermediate

Regex Patterns for Form Data Validation

Provide production-ready regex patterns for validating the following form fields...

#coding #react #architecture

coding advanced

React Component Architecture Patterns for Large Scale Apps

You are a senior React architect. I am building a large-scale React application ...

#rust #error handling #result

Rust Error Handling Result Option Patterns Idiomatic Code

You are a Rust mentor. Teach me idiomatic error handling for [PROJECT TYPE — CLI...

#coding #refactoring #testing

Code Refactoring Plan with Test Coverage Gates and Risk Tiers

You are a senior engineer leading a refactor. I will describe a module that need...

#unit testing #test suite #code quality

Unit Test Suite Generator

Write a comprehensive unit test suite for the following code. Use [testing frame...

#JWT #authentication #refresh tokens

Authentication System with JWT and Refresh Tokens

Build a complete authentication system with JWT access tokens and refresh tokens...

#python #unit tests #pytest

ChatGPT prompt for generating Python unit tests for an existing function

Act as a senior Python test engineer who follows best practices for pytest. I h...

#power query #M code #data transformation

excel advanced

Excel Power Query Data Transformation Pipeline

Help me build an Excel Power Query transformation pipeline. My raw data source i...

#Jest #React Testing Library #unit testing

Unit Testing Best Practices: Jest and React Testing Library Guide

Help me write effective unit tests for my React application using Jest and React...

#power query #excel #web scraping

excel Advanced

ChatGPT Prompt: Excel Power Query M Code for Web Data Scraping

Write Power Query M code to scrape and transform data from [URL OR DESCRIBE WEBP...

#coding #react #typescript

React Component with TypeScript and Custom Hook

Build a React component in TypeScript for a [component type, e.g., paginated dat...

#FastAPI #JWT #authentication

coding intermediate

Python FastAPI REST API Authentication JWT

Build a production-ready FastAPI REST API with JWT authentication. Requirements:...

excel advanced

Excel VBA Macro Automation for Repetitive Reports

Write a VBA macro for Excel that automates the following repetitive reporting ta...

#vba #macro #automation

excel advanced

Excel VBA Macro: Automate Repetitive Report Generation

Act as an Excel VBA expert. I need to automate a repetitive report generation ta...

#excel #vba #macro

#data visualization #chart design #business intelligence

data beginner

Data Visualization Best Practices: Chart Selection and Design Guide

I have the following data and need to visualize it effectively: Data type: [desc...

#A/B testing #statistical analysis #hypothesis testing

data advanced

A/B Test Results Analysis: Statistical Significance and Reporting

Help me analyze the results of an A/B test I ran: Experiment name: [name], Test ...