with open(r'data.csv','r', errors='replace') as infile, open(r'output.csv', 'w') as outfile:
    data = infile.read()
    data = data.replace("�", "")
    outfile.write(data)