Распарсить строки в CSV файле

data = pd.read_csv('1.csv', sep=',')

import pandas as pd
import numpy as np
df = pd.DataFrame(np.array(['1,0,3,"Braund, Mr. Owen Harris",male,22,1,0,A/5 21171,7.25,,S'] + 11*[np.nan]).reshape(-1,1).T, columns='PassengerId,Survived,Pclass,Name,Sex,Age,SibSp,Parch,Ticket, Fare,Cabin,Embarked'.split(','))
 
###############
# "Braund, Mr. Owen Harris" -> тут нужно ", " заменить на другой разделитель,
# если в других строках есть "имя" без запятых
df.iloc[:,0] = df.iloc[:,0].map(lambda x: str(x).replace(', ', ';'))
print(df)
 
df = pd.DataFrame(df['PassengerId'].map(lambda x: str(x).split(',')).values.tolist(), columns=df.columns.tolist())
###############
 
print(df)

with open('train.csv') as f:
    reader = csv.reader(f)
    for row in reader:
        print(row)

with open('train.csv') as f:
    reader = csv.DictReader(f)
    for row in reader:
        print(row)

import csv
 
res = []
with open('train.csv') as f:
    reader = csv.reader(f)
    for row in reader:
        res.append(row)
 
# так как исходного файла нет,
# то скопировал у тебя спарсенные данные
# и "подогнал" под список res 
# эту строчку нужно убрать
res = [['PassengerId', 'Survived', 'Pclass', 'Name', 'Sex', 'Age', 'SibSp', 'Parch', 'Ticket', 'Fare', 'Cabin', 'Embarked'],
 ['1,0,3,"Braund, Mr. Owen Harris",male,22,1,0,A/5 21171,7.25,,S'],
 ['2,1,1,"Cumings, Mrs. John Bradley (Florence Briggs Thayer)",female,38,1,0,PC 17599,71.2833,C85,C']]
#######
 
for i in range(1, len(res)):
    res[i] = res[i][0].strip("'").strip('"').replace(', ', '; ').split(',')
 
myFile = open('train.csv', 'w')
with myFile:
    writer = csv.writer(myFile)
    writer.writerows(res)

import csv
 
res = []
with open('train.csv') as f:
    reader = csv.reader(f)
    k = True
    for row in reader:
        if k:
            row = row[0].strip("'").strip('"').replace(', ', '; ').split(',')
        res.append(row)
 
 
myFile = open('train.csv', 'w')
with myFile:
    writer = csv.writer(myFile)
    writer.writerows(res)

res = []
with open('train.csv') as f:
    reader = csv.reader(f)
    for row in reader:
        res.append(row)
res = [['PassengerId', 'Survived', 'Pclass', 'Name', 'Sex', 'Age', 'SibSp', 'Parch', 'Ticket', 'Fare', 'Cabin', 'Embarked'],
 ['1,0,3,"Braund, Mr. Owen Harris",male,22,1,0,A/5 21171,7.25,,S'],
 ['2,1,1,"Cumings, Mrs. John Bradley (Florence Briggs Thayer)",female,38,1,0,PC 17599,71.2833,C85,C']]
 
for i in range(1, len(res)):
    res[i] = res[i][0].strip("'").strip('"').replace(', ', '; ').split(',')
 
myFile = open('train.csv', 'w')
with myFile:
    writer = csv.writer(myFile)
    writer.writerows(res)
 
data = pd.read_csv('train.csv')
data.head()

import csv
 
res = []
with open('train.csv') as f:
    reader = csv.reader(f)
    k = False
    for row in reader:
        if k:
            row = row[0].strip("'").strip('"').replace(', ', '; ').split(',')
        res.append(row)
        k = True
 
myFile = open('train.csv', 'w')
with myFile:
    writer = csv.writer(myFile)
    writer.writerows(res)
 
data = pd.read_csv('train.csv')
data.head()

import csv
 
res = []
with open('train1.txt') as f:
    lines = f.read().splitlines()
    for row in lines:
        row = row.replace(', ', '; ').split(',')
        res.append(row)
        
 
myFile = open('train1.csv', 'w')
with myFile:
    writer = csv.writer(myFile)
    writer.writerows(res)
data = pd.read_csv('train1.csv')