df = pd.read_csv ('PHC_ISS_TOOL_Q2_OCT_11_V2_2022_results_Mon_7_42_clean.csv')

df_ext_env_inf = df [['Facilities_Combined',
 'grp1:facilityDetails:Ownership',
 'grp1:facilityDetails:selected_lga',
 'grp1:facilityDetails:selected_ward','grp1:ExternalEnvironmentPhysicalInfrastructure:Accessible_road_to_the_facility',
 'grp1:ExternalEnvironmentPhysicalInfrastructure:environment_generally_tidy',
 'grp1:ExternalEnvironmentPhysicalInfrastructure:walls_free_of_cracks',
 'grp1:ExternalEnvironmentPhysicalInfrastructure:roof_intact_with_no_leaking',
 'grp1:ExternalEnvironmentPhysicalInfrastructure:facility_well_ventilated',
 'grp1:ExternalEnvironmentPhysicalInfrastructure:potable_water_available',
 'grp1:ExternalEnvironmentPhysicalInfrastructure:sewage_disposal_system_adequate',
 'grp1:ExternalEnvironmentPhysicalInfrastructure:waste_disposal_system_adequate',
 'grp1:ExternalEnvironmentPhysicalInfrastructure:sharp_disposal_system',
 'grp1:ExternalEnvironmentPhysicalInfrastructure:quaterly_rodent_and_pest_control',
 'grp1:ExternalEnvironmentPhysicalInfrastructure:functional_source_of_power_supply_to_this_facility',
 'grp1:ExternalEnvironmentPhysicalInfrastructure:separate_toilet_facilities_for_males_and_females',
 'grp1:ExternalEnvironmentPhysicalInfrastructure:health_facility_fenced',
 'grp1:ExternalEnvironmentPhysicalInfrastructure:facility_space_adequate_for_different_intervention']]



df_admin = df[['Facilities_Combined',
 'grp1:facilityDetails:Ownership',
 'grp1:facilityDetails:selected_lga',
 'grp1:facilityDetails:selected_ward','grp1:admin:facility_have_an_organogram',
 'grp1:admin:facility_have_a_staff_roster',
 'grp1:admin:facility_have_an_annual_workplan',
 'grp1:admin:activities_implemented_within_the_plan',
 'grp1:admin:up-to-date_register_for_staff_movement',
 'grp1:admin:periodic_management_meetings_with_staff',
 'grp1:admin:functional_Facility_Health_Committee',
 'grp1:admin:FHC_hold_periodic_meetings',
 'grp1:admin:free_maternal_and_child_services',
 'grp1:admin:commodities_for_FMNCH_service',
 'grp1:admin:facility_provide_24hour_service',
 'grp1:admin:quarterly_supervisory_visits_from_the_SPHCB',
 'grp1:admin:monthly_supervisory_visits_from_the_LGA',
 'grp1:admin:weekly_supervisory_visit',
 'grp1:admin:two_way_referral_systems',
 'grp1:admin:triage_SOPs_guidelines',
 'grp1:admin:Injection_safety_SOPs_guidelines',
 'grp1:admin:infectionPrevention_control_SOPs_guidelines',
 'grp1:admin:SOP_prevention_of_Covid19_women',
 'grp1:admin:staff_have_standing_order_for_different_cadres',
 'grp1:admin:JobAids_eg_Manual_PictureCard',
 'grp1:admin:guidelineonthe_useof_SPforIPTp_in_Pregnancy']]