Not sure where you are pulling the data from and how it is ordered, but an outline:
data_input (Assuming sorted by village and then age)
for village in data_input: for age in village: curr_pgsql.execute(''' INSERT INTO student (created, modified, name, address, age, level) VALUES(current_timezone, current_timezone, %s, %s, %s, 2)''', (name, village, age))