Replacing multiple special characters on dataframe

Ask Time：2022-07-01T21:25:35 Author：Deepak

I have dataframe with 80+ columns and column names has special characters like colon, Ampersand, Slash, Minus, space and Parenthesis.

Currently, I'm doing multiple replace on df.columns, my code as follows:

df.columns = df.columns.str.replace(' ','').str.replace('-','').str.replace('&','').str.replace('/','').str.replace(':','').str.replace('(','').str.replace(')','')

Is there any betters ways to replace all special characters at once on dataframe column names.

Author:Deepak，eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/72829995/replacing-multiple-special-characters-on-dataframe

More about “Replacing multiple special characters on dataframe” related questions

Replacing multiple special characters on dataframe

I have dataframe with 80+ columns and column names has special characters like colon, Ampersand, Slash, Minus, space and Parenthesis. Currently, I'm doing multiple replace on df.columns, my code as
Replacing multiple special characters

I want to get rid of multiple special characters that might show up in a specific column and replace it with a space but I keep getting this error when I try to write my file to an excel document.
sed replacing string with special characters

Surprisingly similar questions had been asked multiple times but none of the solutions worked for my use case - which is to replace a string which can contains all possible special characters. In a...
Replacing special characters in pandas dataframe

So, I have this huge DF which encoded in iso8859_15. I have a few columns which contain names and places in Brazil, so some of them contain special characters such as "í" or "Ô". I have the key to
Replacing all special characters, numbers and alphabets

This is the code for example String a="abcd ABCD 0123 !@#$%^&*()"; This is syntax for replacing numbers & alphabets with blank a = a.replaceAll("[a-zA-Z0-9]",""); This is sy
Removing/Replacing multiple special character in filename using RegEx in flex

I want to remove or replace special character in file name. Heres my code, it works in replacing single special character. // Remove special characters from the name. var excludeChars:RegExp = /...
Replacing strings with special characters in pandas dataframe

I'm looking to replace strings inside DataFrame columns, these strings contain special characters. I tried the following, but nothing changed in the DataFrame: data = {'col1': ["series ${z_mas...
Replacing special characters in scala

I am working on a scala and want to replace special characters from my dataframe replaceAll doesn't seem to work, is there any other way ? My code is this: val specialchar = dataframe.select(colu...
Replace special characters in pandas dataframe from a string of special characters

I have created a pandas dataframe called df using this code: import numpy as np import pandas as pd ds = {'col1' : ['1','3/','4'], 'col2':['A','!B','@C']}
SQLite string for replacing word with special characters

I am trying to replace a word that exists in a column in SQLite, but I am having some problems because it uses a special character. following is the special character ', like "women's", "men's", s...

Replacing multiple special characters on dataframe

Replacing multiple special characters on dataframe

Replacing multiple special characters

sed replacing string with special characters

Replacing special characters in pandas dataframe

Replacing all special characters, numbers and alphabets

Removing/Replacing multiple special character in filename using RegEx in flex

Replacing strings with special characters in pandas dataframe

Replacing special characters in scala

Replace special characters in pandas dataframe from a string of special characters

SQLite string for replacing word with special characters

热门文章

jpg图片怎么转换成pdf，详细教程分享！

iphone怎么把图片转成电子版？试试这2个方法！

图片如何转换pdf文件？看看这三个方法！

怎么把图片转换成pdf格式，干货教程不要错过

png图片怎么转换成pdf，实用方法不要错过

图片怎么转pdf格式？三种转换方法分享给你，一分钟轻松解决

图片转pdf格式怎么弄免费？get这五个简单的方法，轻松搞定！

如何将图片转pdf格式？4种转换方法分享给你，一分钟轻松解决

如何图片转pdf免费？快学习这三种免费转换方法

怎么将图片转pdf？分享个图片转pdf在线免费

相关搜索

jpg图片怎么转换成pdf，详细教程分享

电脑图片转pdf工具怎么用

单张pdf图片转照片格式

如何将图片转成pdf文档，经验分享

这么好用的图片转pdf软件，我一定要分享

干货分享，不懂图片转pdf的朋友快快收藏起来

分享一个让你惊叹不已的图片转pdf方法

图片转pdf工具

分享一个大家都不知道的图片转pdf格式方法

好用的图片转pdf软件要和好朋友分享