replace_characters.py

import mysql.connector
import pandas as pd


mydb = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd="user12",
    database="zahnklinik"
)


patientQuery = "SELECT * FROM hostname"
df = pd.read_sql(patientQuery, con=mydb)
emailColumn = df["email"]
print(emailColumn)

letterToBeRemoved = 5 #counting starts at 0 ;)
newMailColumn = []
for row in range(emailColumn.__len__()):
    oldstring = emailColumn[row]
    # df.at[row, "email"] = oldstring[:letterToBeRemoved] + oldstring[letterToBeRemoved +2:]
    length = len(oldstring)
    savedString = oldstring[:length-2]
    #df.at[row, "email"] = oldstring[5:6]
    df.at[row, "email"] = oldstring[:length-2] + "de"
print("email new: ", df["email"])


#name = "char" + str(letterToBeRemoved) + "weg"
#name = "limitcharfrontback"+str(letterToBeRemoved) + "weg"
name = "patientCleaned"
path = '/home/user/Desktop/'+name+".csv"
df.to_csv(path_or_buf=path)