> ## Documentation Index
> Fetch the complete documentation index at: https://docs.exploratory.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Clean Column Names

Clean up all column names on the data frame.

## How to Access This Feature

### From + (plus) Button

![](https://mintcdn.com/exploratory-inc/TqmeqBdjk6dsTTLj/en/wrangling/images/command-clean-colnames.png?fit=max\&auto=format\&n=TqmeqBdjk6dsTTLj\&q=85\&s=13e1c9b3de7afa4cfbf0b297b09076d0)

* Click "+" button and select "Others..." -> "Clean Up All Column Names".

## Clean Column Names

![](https://mintcdn.com/exploratory-inc/TqmeqBdjk6dsTTLj/en/wrangling/images/clean_columns.png?fit=max\&auto=format\&n=TqmeqBdjk6dsTTLj\&q=85\&s=933b67d26483d743d3813f92e31b48eb)

1. Case - Case of the Resulting Column Names. Supported options are:

* parsed
* snake\_case
* lowerCamel
* UpperCamel
* ALL\_CAPS
* lowerUpper
* UPPERlower
* multibyte

### parsed

A column name is created with multiple words that are joined together with an underscore (\_) as the separator and current case is preserved.

For example, "Product Name" becomes "Product\_Name".

### snake\_case

A column name is created with multiple words that are joined together with an underscore (\_) as the separator and each word is lowercased.

For example, "Product Name" becomes "product\_name".

### lowerCamel

A column name is created with multiple words that are joined together as a single word with the first letter of each word (except the first one) uppercased.

For example, "Product Name" becomes "productName".

### UpperCamel

A column name is created with multiple words that are joined together as a single word with the first letter of each word uppercased.

For example, "Product Name" becomes "ProductName".

### ALL\_CAPS

A column name is created with multiple words that are joined together with an underscore (\_) as the separator and each word is uppercased.

For example, "Product Name" becomes "PRODUCT\_NAME".

### lowerUpper

A column name is created with multiple words that are joined together as a single word with each word alternating with lowercased and uppercased.

For example, "Product Detail Description" becomes "productDETAILdescription".

### UPPERlower

A column name is created with multiple words that are joined together as a single word with each word alternating with uppercased and lowercased.

For example, "Product Detail Description" becomes "PRODUCTdetailDESCRIPTION".

### multibyte

Same as parsed. If your column name contains multibyte characters and separated unexpected way with "parsed" option, try this multibyte option.

For example, "製品 名称" becomes "製品\_名称".


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.