df = pd.DataFrame.from_records(csv.reader(map(lambda x: x.rstrip().replace(
    '|', ';'), f), delimiter=';'), columns=['Column 1', 'Column 2', 'ID',
    'Age', 'Height']).astype(int)
Delimit a specific column and add them as columns in CSV (Python3, CSV)