There are three joins possible to the organisation table:
[ ] subject, by id = organisationId
[ ] teacher, by id = organisationId
[ ] genericTopic, by id = organisationId
Write a new script which attempts to do so.
Note the mutations on the resulting dataframe.
Also there appears to be a connection between ParentOrganisationId to id within the organsiation table. I am unsure how that pans out.
Look into the inter-table joins first and if time allows explore what this intra-table join amounts to.
As far as I can tell from the data scheme
There are three joins possible to the organisation table:
Write a new script which attempts to do so.
Note the mutations on the resulting dataframe.
Also there appears to be a connection between ParentOrganisationId to id within the organsiation table. I am unsure how that pans out. Look into the inter-table joins first and if time allows explore what this intra-table join amounts to.