Merge pull request 'feat: ingest independent schools in Ofsted tap and dbt staging' (#47) from feature/ingest-independent-schools into main

Reviewed-on: #47

pipeline/plugins/extractors/tap-uk-ofsted/tap_uk_ofsted/tap.py

@@ -237,15 +237,18 @@ class OfstedInspectionsStream(Stream):
 
         for _, row in df.iterrows():
             record = {}
+            for key in self.schema["properties"].keys():
+                record[key] = None
+
             for field, col in col_map.items():
                 val = row.get(col, None)
-                if pd.isna(val):
+                if val == 'NULL':
                     val = None
                 record[field] = val
 
             # Cast URN
             try:
-                record["urn"] = int(record.get("urn"))
+                record["urn"] = int(record["urn"])
             except (ValueError, KeyError, TypeError):
                 continue