delete part of a string in pandas #pandas #python

delete_part_string.py

#deleting a char directly in csv
infile = "test.csv"
outfile = "test_edit.csv"

delete_list = ["b'", "'"]
fin = open(infile)
fout = open(outfile, "w+")
for line in fin:
    for word in delete_list:
        line = line.replace(word, "")
    fout.write(line)
fin.close()
fout.close()

#strip a part of a string in pandas
df = pd.read_csv('data/test.csv')
df['f769'] = df['f769'].str.rstrip("'")
df.to_csv('data/test.csv')