-
Notifications
You must be signed in to change notification settings - Fork 0
/
normalizer.py
25 lines (21 loc) · 998 Bytes
/
normalizer.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
import database as db
import pandas as pd
# retorna lista com nome dos docentes e discentes que participaram normalizada. (SILVA, M. P. -> MARIA PEREIRA DA SILVA)
def normalizer(l):
doc, dis = [], []
for ref in l:
surnameref = ref[0].strip() + ', '
nameref = (surnameref+ ' '.join(ref[1:])).upper()
docentes=pd.DataFrame(db.consult_db("SELECT referencia FROM researchers"))
for ref in docentes[0]:
if nameref == ref:
sql = f"SELECT nome FROM researchers WHERE referencia = '{ref}'"
fullname = db.consult_db(sql)[0][0]
doc.append(fullname)
discentes=pd.DataFrame(db.consult_db("SELECT referencia FROM students"))
for ref in discentes[0]:
if nameref == ref:
sql = f"SELECT nome FROM students WHERE referencia = '{ref}'"
fullname = db.consult_db(sql)[0][0]
dis.append(fullname)
return doc, ''.join(dis)