Column Name Cleaner

Request your dataset with this AI prompt to systematically clean messy column names, ensuring consistency and transparency.

What this prompt does

  • Provides a systematic approach to clean messy column names in datasets.
  • Ensures column names follow pandas best practices for consistency and readability.
  • Offers a clear before/after comparison to maintain transparency about changes.

How to use this prompt

  1. Fill in the [PASTE YOUR DATASET OR DATAFRAME HERE], [JUPYTER/COLAB/VSCODE/OTHER], and [INSERT PANDAS VERSION IF KNOWN] placeholders inside #INFORMATION ABOUT ME section with your specific dataset, programming environment, and pandas version.
  2. Example: "My dataset: df with columns ['Customer Name (NEW!)', 'Order#', ' Sales Amount ']. My programming environment: Jupyter. My pandas version: 1.3.3."

Premium prompt — included in the Complete AI Bundle. Part of the Coding prompts collection in the God of Prompt library.

Related Coding prompts