Missing column entries¶


Name	457894	Missing 2
Department	457677	Missing 219
OrganizationID	457896	Missing 0
Institution	457896	Missing 0
ProvinceEN	454115	Missing 3781
CountryEN	457896	Missing 0
FiscalYear	457896	Missing 0
AwardAmount	457896	Missing 0
ProgramID	457896	Missing 0
ProgramNameEN	457896	Missing 0
Committee	457896	Missing 0
ResearchSubjectEN	457896	Missing 0

As you can see some of the data columns are missing values.

The missing Name data is for two 'Head Office' departments, so it does not get assigned to a specific name/person. One of these is for PIMS.

The missing Department data seems unimportant but keep it in mind if you use any department selection or functions.

The missing ProvinceEN data is mostly for non-canadian awards, and the canadian ones are for programs that are in more than one province.

Messy Data¶

The 'ProgramID' column has leading whitespace that causes an issue if we do not remove it.

Search by Subject Issue¶

Currently we are selecting funding based on subjects using the committee number. For example 1508 for mathematics, however this is problematic. You can see an example by selecting for 'Adem, Alejandro' in the SelectionsTemplate. They are clearly a mathematician in the math department however none of their committees are 1508. We will need to implement some regex to search for ex. 'Math*' in a few of the columns, then implement this as subject selection.
Columns that need to be searched for the subject word are: Department, Institution. We would also include all of committee 1508.