import pandas as pd import re import sys filename = "FILENAME" columns = "COLUMN_NAME" data = pd.read_excel(filename) print(data.columns) def replaceWithSpace(row): return re.sub(r'.([0-9])', '\u202F\1', row) #return row replaced_data = data.copy() replaced_data[columns] = data[columns].apply(replaceWithSpace) replaced_data.to_csv('.'.join(filename.split('.')[:-1])+'.replaced.csv', index=False) replaced_data[~(replaced_data[columns]==data[columns])].to_csv('.'.join(filename.split('.')[:-1])+'.indices.csv')