import re as re data = [] file = open ("C:\\users\\alex\\downloads\\ScoreData.csv",'r') c = file.readline() modified = open ("C:\\users\\alex\\downloads\\ScoreDataModed.csv",'w') modified.writelines(c) for i in range (1,99): temp = "" c = file.readline() c = c.split(",") for vector in c: if (vector!="CSIE"): vector = re.match('\d+|.\d+|n',vector) vector = vector.group() data.append(vector) else: data.append("CSIE") for k in range (19): temp += data[k] if (k!=18): temp += "," else: temp += "\n" modified.writelines(temp) modified.close() file.close()