Построчное чтение данных из файла

lst = line.split(',')

for _ in range(cnt):
    # тело цикла

data_file = open("patientdata.txt", "r")
f = data_file
for line in data_file:
   
     line = line.strip()
     if not line: continue
     f.readlines ()
     h1,h2,h3,h4,h5,h6,h7,h8,h9,h10,h11,h12,h13,h14,h15,cnt=line.split(",")
     cnt = int(cnt)
     print cnt
         for i in range(cnt)
                  lineobs = line.strip()
                  if not lineobs : continue
                     f.readline ()
                     print lineobs
      f.close()
      end()

h1,h2,h3,h4,h5,h6,h7,h8,h9,h10,h11,h12,h13,h14,h15,cnt=line.split(",")

for i in range(cnt)
 lineobs = line.strip()
 if not lineobs : continue
 f.readline ()
 print lineobs
 f.close()
 end()

values = line.split(",")

values[0]
values[1]
...
values[15]

import MySQLdb
 
 
 
 
 
data_file = open("/home/dilara/Desktop/patientdata.txt", "r")
 
f = data_file
 
 
 
#for line in f.readlines():
 
 
 
for l in range(20):
 
     line=f.next()
 
     print l,"=====",line
 
 
 
     line = line.strip()
 
     if not line: continue
 
#     f.readlines ()
 
 
 
     h1,h2,h3,h4,h5,h6,h7,h8,h9,h10,h11,h12,h13,h14,h15,cnt = line.split(",")
 
 
 
     cnt = int(cnt)
 
 
 
     print 'name         ',h1
 
     print 'surname      ',h2
 
     print 'Gender       ',h3
 
     print 'DOB          ',h4
 
     print 'DIagnosis    ',h5
 
     print 'diagnosis code',h6
 
     print 'T_Stage      ',h7
 
     print 'mStage       ',h8
 
     print 'nStage       ',h9
 
     print 'Grade        ',h10
 
     print 'PS           ',h11
 
     print 'Dose         ',h12
 
     print 'Franction    ',h13
 
     print 'Begining Date',h14
 
     print 'End Date     ',h15
 
 
 
 
 
 
 
     j=80
 
     a = line.split(",")
 
     a.insert(0, str(j))
 
     b=[]
 
     b.insert(0, str(j))
 
     b.insert(1, h1)
 
     b.insert(2, h2)
 
     b.insert(3, h3)
 
     b.insert(4, h4)
 
     b.insert(5, h11)
 
     b.insert(6, h5)
 
     b.insert(7, h6)
 
     b.insert(8, h7)
 
     b.insert(9, h8)
 
     b.insert(10, h9)
 
     b.insert(11, h10)
 
     values = '\', \''.join(b)
 
  #   print a
 
   #  print values
 
     print values
 
     connect=("localhost","root","grid12345","testdb",3306)
 
     db = MySQLdb.connect(connect[0],connect[1],connect[2],connect[3],connect[4])
 
     cursor = db.cursor()
 
   #  SQL = """INSERT INTO patient_anonymous (ID_Patient,First_Name, Surname, Gender, 
 
    #   Date_of_Birth, Performance_Status, Diagnosis, Diagnosis_Code,
 
     #  T_Stage, N_Stage, M_Stage,Grade)
 
#   VALUES ('j', 'h1', 'h2', 'h3', 'h4', 'h6', 'h5', 'h7', 'h8', 'h9', 'h10', 'h11')"""
 
 
 
 
 
     SQL2 = """INSERT INTO patient (ID_Patient,First_Name, Surname, Gender, Date_of_Birth, Performance_Status, Diagnosis, Diagnosis_Code,
 
               T_Stage, N_Stage, M_Stage, Grade)
 
               VALUES (\'%s\')""" % values 
 
     print SQL2
 
     j=j+1
 
  #    aa = b[0]
 
  #    av = b[1]
 
   #   ac = b[2]
 
   #   ad = b[3]
 
#      af = b[4]
 
 #     ag = b[5]
 
  #    ah = b[6]
 
  #    aj = b[7]
 
  #    ak = b[8]
 
  #    al = b[9]
 
   #   aq = b[10]
 
   #   aw = b[11]
 
  #    SQL = """INSERT INTO patient_anonymous (ID_Patient,First_Name, Surname, Gender,
 
   #    Date_of_Birth, Performance_Status, Diagnosis, Diagnosis_Code,
 
    #   T_Stage, N_Stage, M_Stage,Grade) VALUES ('aa','av','ac','ad','af','ag','ah','aj','ak','al','aq','aw')"""
 
 
 
     cursor.execute(SQL2)
 
     results = cursor.fetchall()
 
  #    j=j+1
 
     #     line = line + '\n'
 
     listofobs = []
 
     l=0
 
     k=0
 
     dataobs = []
 
 
 
     for i in range(cnt):
 
#     while i <= cnt:
 
        obsline = f.next()
 
        obsline=obsline.strip()
 
        if not obsline: continue
 
        listofobs.append(obsline)
 
        print "   OBS",i,"==",listofobs[l]
 
#        print "this is the list of observations", listofobs
 
#       print "this is observations one by one",l, listofobs[l]
 
 #       temp = listofobs[l]
 
#       dataobs = temp.split(",")
 
        dataobs=listofobs[l].split(",")
 
        print dataobs[0]
 
        danniedlaobs=[] #this is array of what we need for observation table
 
        forsideeffecttable=[] # this is array of what we need in sideeffects table
 
        doctab=[] # this is array for doctor table
 
        id_side=0
 
        id_doc=0
 
        for elem in dataobs:
 
                print elem
 
        danniedlaobs.insert(0,str(i))
 
        danniedlaobs.insert(1,str(1))
 
        danniedlaobs.insert(2,dataobs[0])
 
        danniedlaobs.insert(3,str(j))
 
        danniedlaobs.insert(4,str(k))
 
        print danniedlaobs
 
 
 
        forsideeffecttable.insert(0, str(id_side))
 
        forsideeffecttable.insert(1,dataobs[5])
 
        forsideeffecttable.insert(2,' ')
 
        forsideeffecttable.insert(3,dataobs[6])
 
        forsideeffecttable.insert(4,'CTCAE')
 
        forsideeffecttable.insert(5,' ')
 
        forsideeffecttable.insert(6,str(i))
 
 
 
        print forsideeffecttable
 
        doctab.insert(0,str(id_doc))
 
        doctab.insert(1,dataobs[2])
 
        doctab.insert(2,'name')
 
        doctab.insert(3,'  ')
        doctab.insert(4, '  ')
 
        
 
        values2 = '\', \''.join(danniedlaobs)
 
        values3 = '\', \''.join(forsideeffecttable)
 
        values4 = '\', \''.join(doctab)
 
        
 
        db = MySQLdb.connect(connect[0],connect[1],connect[2],connect[3],connect[4])
 
        cursor = db.cursor()
     SQL4 = """INSERT INTO patient (ID_Doctor, Surname, First_Name,  Institution, Specialization)
 
               VALUES (\'%s\')""" % values4 
 
 
 
        SQL = """INSERT INTO observation (ID_Observation, Observer,       
                 Date_Recorded, ID_Patient, DOCTOR_ID_Doctor) 
 
                   VALUES (\'%s\')""" % values2
 
        SQL3= """INSERT INTO sideeffect (ID_Sideeffect, Sideeffect, Code, Score, Scoring_System, Date_occurred, ID_Observation)
 
                 VALUES (\'%s\')""" % values3
 
       
 
        print SQL
 
        print SQL3
 
        print SQL4
 
 
 
    cursor.execute(SQL4)
 
        cursor.execute(SQL)
 
        cursor.execute(SQL3)
 
       
 
        results = cursor.fetchall()
 
        print dataobs, "===", "this is splited observations"
 
        k=k+1
 
        id_side = id_side+1
 
        l=l+1
 
        id_doc= id_doc+1
 
        db.commit()
 
 
 
f.close()
 
db.commit()
 
db.close()

my_file = open("r.txt","r")
my_string = my_file.read()
print(my_string)
my_file.close()