In [1]:

    

from tx_highered.models.base import Institution, System
from tx_highered.models.reports import Admissions, Enrollment, GraduationRates, PriceTrends, TestScores
from tx_highered.models.thecb import PublicAdmissions, PublicEnrollment, PublicGraduationRates


    

In [ ]:

    

# Double check existing `percent_of_applicants_admitted`
for x in Admissions.objects.filter(percent_of_applicants_admitted__isnull=False, number_of_applicants__gt=0, number_admitted__gt=0):
    print x.percent_of_applicants_admitted, x.number_admitted * 1000 / x.number_of_applicants / 10.0


    

In [ ]:

    

# Backfill missing `percent_of_applicants_admitted`
for x in Admissions.objects.filter(percent_of_applicants_admitted=None, number_of_applicants__gt=0, number_admitted__gt=0):
    x.percent_of_applicants_admitted = x.number_admitted * 1000 / x.number_of_applicants / 10.0
    x.save()


    

In [ ]:

    

# Double check existing `percent_of_admitted_who_enrolled`
for x in Admissions.objects.filter(percent_of_admitted_who_enrolled__isnull=False, number_admitted_who_enrolled__gt=0, number_admitted__gt=0):
    print x.percent_of_admitted_who_enrolled, x.number_admitted_who_enrolled * 1000 / x.number_admitted / 10.0


    

In [4]:

    

# Backfill missing `percent_of_admitted_who_enrolled`
for x in Admissions.objects.filter(percent_of_admitted_who_enrolled__isnull=True, number_admitted_who_enrolled__gt=0, number_admitted__gt=0):
    x.percent_of_admitted_who_enrolled = x.number_admitted_who_enrolled * 1000 / x.number_admitted / 10.0
    x.save()


    

In [ ]: