Mar-30-2019, 07:37 AM
(Mar-30-2019, 05:06 AM)yimchiwai Wrote: any suggestion?Can make new list to get some structure,then can call individual record in list.
new_record = [] for i in range(0,len(record),6): new_record.append(record[i:i+6])Test:
>>> new_record [['1', 'WAN HAI 102', 'S174', 'HIT4', '2019-04-06', '2019-04-07'], ['2', 'WAN HAI 102', 'W174', 'HIT4', '2019-04-06', '2019-04-07'], ['3', 'WAN HAI 102', 'S175', 'HIT4', '2019-04-20', '2019-04-21'], ['4', 'WAN HAI 102', 'W175', 'HIT4', '2019-04-20', '2019-04-21'], ['5', 'WAN HAI 102', 'S176', 'HIT4', '2019-05-04', '2019-05-05'], ['6', 'WAN HAI 102', 'W176', 'HIT4', '2019-05-04', '2019-05-05']] >>> new_record[2] ['3', 'WAN HAI 102', 'S175', 'HIT4', '2019-04-20', '2019-04-21'] >>> new_record[5] ['6', 'WAN HAI 102', 'W176', 'HIT4', '2019-05-04', '2019-05-05']