replace spaces

replace_stuff.py

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')