Search: "legacy code"

excel Advanced

ChatGPT prompt for creating Excel macros to automate repetitive report formatting

Act as an Excel VBA developer who writes clean, maintainable macros. Create VBA...

#excel #vba #macros

#coding #code-review #pull-request

coding intermediate

Code Review Checklist for Pull Requests

Generate a comprehensive code review checklist for pull requests in a [language/...

#data #visualization #charts

data intermediate

Data Visualization Chart Selection Guide

I have the following dataset: [describe data type, dimensions, and what I want t...

#legal #intellectual-property #contract

legal advanced

Intellectual Property Assignment Agreement

Draft an Intellectual Property Assignment Agreement for [context — e.g., indepen...

#data #machine-learning #model-evaluation

data advanced

Machine Learning Model Evaluation and Selection Framework

You are a machine learning engineer and data scientist. I need to evaluate and s...

#design #design-system #component-library

design advanced

Design System Component Library Setup Guide

You are a design system architect. I need to build a component library and desig...

#NDA #non-disclosure agreement #confidentiality

legal Beginner

Non-Disclosure Agreement (NDA) Template

Create a Non-Disclosure Agreement (NDA) for my situation. Type: [Mutual (both p...

#power query #CSV import #data transformation

excel Advanced

Power Query: Merge and Transform Multiple CSV Files

I have a folder containing monthly CSV files (January.csv, February.csv, etc.) w...

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

coding Intermediate

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 dictionary #analytics schema #documentation

ChatGPT Prompt for Data Dictionary from a Messy Analytics Schema

Help me create a clear data dictionary from a messy analytics database so busine...

#coding #react #typescript

coding Advanced

React Component with TypeScript and Custom Hook

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

#data #data cleaning #pandas

Data Cleaning Checklist for Messy Datasets

Create a comprehensive data cleaning checklist and guide for a messy dataset abo...

#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

coding advanced

AWS Lambda Serverless Function Deployment Complete Guide

You are an AWS serverless architect. I need to build and deploy a serverless app...

#coding #aws #lambda

#coding #typescript #interface

coding advanced

TypeScript Interface & Type Design Patterns Advanced Guide

Act as a TypeScript expert and software architect. Help me master advanced TypeS...

#data #quality #assessment

data intermediate

Data Quality Assessment Framework and Cleaning Checklist

Act as a data quality engineer and analytics architect. Help me build a systemat...

#churn reason taxonomy #open text analysis #customer exit survey prompt

ChatGPT prompt for churn reason taxonomy from open-text survey responses

Act as a customer insights analyst. I need to turn messy open-text churn or exit...

coding Advanced

ChatGPT Prompt for Refactor Legacy API Handler Safely

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

#coding #refactor #api

#sql optimization #query tuning #performance

coding Advanced

ChatGPT Prompt for Refactoring a Slow SQL Query Without Breaking Results

Help me refactor a slow SQL query so it runs faster without changing the busines...

#code review #debugging #quality

Coding Advanced

Code Review Assistant

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

#data cleaning #csv #pandas

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....

#writing #technical-documentation #api

writing intermediate

Technical Documentation for API Endpoints

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