# Clean Column Names

Clean up all column names on the data frame.

## How to Access This Feature

### From + (plus) Button

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oN7qxadXr1X3x0lgk%2Fcommand-clean-colnames.png?generation=1586795463017763\&alt=media)

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

## Clean Column Names

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oN7qzRPIg_cnAn7jT%2Fclean_columns.png?generation=1586795462386972\&alt=media)

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 "製品\_名称".