Clean Column Names
Last updated
Last updated
Clean up all column names on the data frame.
Click "+" button and select "Others..." -> "Clean Up All Column Names".
Case - Case of the Resulting Column Names. Supported options are:
parsed
snake_case
lowerCamel
UpperCamel
ALL_CAPS
lowerUpper
UPPERlower
multibyte
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".
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".
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".
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".
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".
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".
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".
Same as parsed. If your column name contains multibyte characters and separated unexpected way with "parsed" option, try this multibyte option.
For example, "製品 名称" becomes "製品_名称".
