| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455 |
- def course():
- if not os.path.exists('analytics'):
- os.mkdir('analytics')
- if os.path.exists('analytics/course'):
- shutil.rmtree('analytics/course')
- d = {'01':'btech',
- '11':'mtech',
- '21':'phd',
- '12':'msc'}
- with open('studentinfo_cs384.csv', newline='') as csvfile:
- reader = csv.DictReader(csvfile)
- if not os.path.exists('analytics/course'):
- os.mkdir('analytics/course')
- for row in reader:
- if len(row)==0:
- print(1)
- continue
- l = list(row.values())
- head = list(row.keys())
- stream = str(row['id'][-4:-2]).lower()
- yr = str(row['id'][:2])
- if str(row['id'][2:4]) in list(d.keys()):
- degree = d[str(row['id'][2:4])]
- else:
- with open('analytics/course/' + 'misc.csv' , mode = 'a') as f:
- f_write = csv.writer(f, delimiter=',',lineterminator='\r')
- if os.path.getsize('analytics/course/' + 'misc.csv')==0:
- f_write.writerow(head)
- f_write.writerow(l)
- f.close()
- continue
- csv_name = f'{yr}_{stream}_{degree}.csv'
- p = re.compile(r'\d\d\d\d\D\D\d\d')
- k = re.fullmatch(p,row['id'])
- if k:
- if not os.path.exists('analytics/course/'+ stream):
- os.mkdir('analytics/course/'+ stream)
- if not os.path.exists('analytics/course/'+ stream + '/' + degree):
- os.mkdir('analytics/course/'+ stream + '/' + degree )
- with open('analytics/course/'+ stream + '/' + degree + '/' + csv_name , mode = 'a') as f:
- f_write = csv.writer(f, delimiter=',',lineterminator='\r')
- if os.path.getsize('analytics/course/'+ stream + '/' + degree + '/' + csv_name)==0:
- f_write.writerow(head)
- f_write.writerow(l)
- f.close()
- else:
- with open('analytics/course/' + 'misc.csv' , mode = 'a') as f:
- f_write = csv.writer(f, delimiter=',',lineterminator='\r')
- if os.path.getsize('analytics/course/' + 'misc.csv')==0:
- f_write.writerow(head)
- f_write.writerow(l)
- f.close()
- csvfile.close()
|
