import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns
from IPython.display import Markdown


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

cols = ['country','population','population_2015','totalproviders','totalproviders2015','totalproviders_cap','totalproviders2015_cap','totalproviders_cap_diff','totalprovidersdiff','certified_specialist','provider_number','totalpap','physicians2015','totalpap_cap','physicians2015_cap', 'totalnpap','nurses2015','totalnpap_cap','nurses2015_cap','popdiff']
printinfocols = ['country','name','email','role','certified_specialist','provider_number','nurse_num','nurse_num2','nurse_num3','nurse_num4','other_1']

def countryinvestigation(country):
    df = dfg[dfg['country']==country][cols]
    sns.set_theme(style="whitegrid")
    fig, ax = plt.subplots(3,3,figsize=(10,10))
    
    # Paps
    pap = df[['physicians2015', 'certified_specialist','provider_number','totalpap']].melt()
    sns.barplot(x='variable',y='value',data=pap,ax=ax[0,0])
    ax[0,0].bar_label(ax[0,0].containers[0])
    #set xtick rotation
    ax[0,0].tick_params(axis='x', rotation=30)
    
    # Npaps
    npap = df[['nurses2015', 'totalnpap']].melt()
    sns.barplot(x='variable',y='value',data=npap,ax=ax[0,1])
    ax[0,1].bar_label(ax[0,1].containers[0])
    
    # Total Providers
    providers = df[['totalproviders2015', 'totalproviders']].melt()
    sns.barplot(x='variable',y='value',data=providers,ax=ax[0,2])
    ax[0,2].bar_label(ax[0,2].containers[0])
    
    # Pap Cap
    papcap = df[['physicians2015_cap', 'totalpap_cap']].melt()
    sns.barplot(x='variable',y='value',data=papcap,ax=ax[1,0])
    ax[1,0].bar_label(ax[1,0].containers[0])
    
    # Npap Cap
    npapcap = df[['nurses2015_cap', 'totalnpap_cap']].melt()
    sns.barplot(x='variable',y='value',data=npapcap,ax=ax[1,1])
    ax[1,1].bar_label(ax[1,1].containers[0])
    
    # Total Providers Cap
    providerscap = df[['totalproviders2015_cap', 'totalproviders_cap']].melt()
    sns.barplot(x='variable',y='value',data=providerscap,ax=ax[1,2])
    ax[1,2].bar_label(ax[1,2].containers[0])
    
    # Population
    population = df[['population_2015', 'population']].melt()
    sns.barplot(x='variable',y='value',data=population,ax=ax[2,0])
    ax[2,0].bar_label(ax[2,0].containers[0])
    
    #set xlabel and ylabel to ""
    for ax in fig.axes:
        ax.set_xlabel('')
        ax.set_ylabel('')

    # Adjust subplot layout
    plt.tight_layout()
    plt.show()
    plt.close()

def print_country_info(country):
    t1 = df[df['country']==country][printinfocols].set_index('name').T
    return t1

df=df.sort_values(by=['country','Region'])
dff = df[df['Region']=='Eastern Mediterranean Region']
display(Markdown('# Eastern Mediterranean Region'))
for i in dff['country'].unique():
    display(Markdown(f'## {i}'))
    display(print_country_info(i))
    countryinvestigation(i)

Eastern Mediterranean Region

Cyprus

name	Marilia Loizou
country	Cyprus
email	marilia19fan@gmail.com
role	Member and part of leadership
certified_specialist	207.0
provider_number	NaN
nurse_num	NaN
nurse_num2	NaN
nurse_num3	NaN
nurse_num4	NaN
other_1	NaN

Egypt

name	Nesrine Refai
country	Egypt
email	nesrinerefai@hotmail.com
role	Member and part of leadership
certified_specialist	8436.0
provider_number	NaN
nurse_num	NaN
nurse_num2	NaN
nurse_num3	NaN
nurse_num4	NaN
other_1	NaN

Iran

name	Alireza Salimi	mmehdi salehi
country	Iran	Iran
email	Arsalimi@sbmu.ac.ir	mmehdisalehi92@gmail.com
role	Member and part of leadership	Member and part of leadership
certified_specialist	6000.0	NaN
provider_number	NaN	NaN
nurse_num	NaN	7800.0
nurse_num2	NaN	NaN
nurse_num3	NaN	NaN
nurse_num4	NaN	NaN
other_1	NaN	NaN

Iraq

name	dr alaa hussein ali
country	Iraq
email	alaa.h.altaei@gmail.com
role	Member and part of leadership
certified_specialist	700.0
provider_number	100.0
nurse_num	NaN
nurse_num2	NaN
nurse_num3	NaN
nurse_num4	NaN
other_1	NaN

Jordan

name	Dr. Abdelkarim AlOweidi
country	Jordan
email	akaloweidi@hotmail.com
role	Member and part of leadership
certified_specialist	474.0
provider_number	NaN
nurse_num	NaN
nurse_num2	NaN
nurse_num3	NaN
nurse_num4	NaN
other_1	NaN

Kuwait

name	Alisher Agzamov
country	Kuwait
email	draalisheer2011@hotmail.com
role	Member and part of leadership
certified_specialist	500.0
provider_number	1000.0
nurse_num	NaN
nurse_num2	NaN
nurse_num3	NaN
nurse_num4	NaN
other_1	Anaesthesia Technician supervisor by Doctors

Lebanon

name	Patricia Yazbeck
country	Lebanon
email	patricia.yazbeck@hdf.usj.edu.lb
role	Member but not part of leadership
certified_specialist	420.0
provider_number	NaN
nurse_num	NaN
nurse_num2	NaN
nurse_num3	NaN
nurse_num4	NaN
other_1	Nurse anesthetists or Anesthesia technicians

Libya

name	El Hassan Eghwila
country	Libya
email	elhassan@asmarya.edu.ly
role	Member and part of leadership
certified_specialist	100.0
provider_number	250.0
nurse_num	700.0
nurse_num2	NaN
nurse_num3	NaN
nurse_num4	NaN
other_1	NaN

Morocco

name	Dr KOHEN JAMALEDDINE	Dr KOHEN JAMALEDDINE	Dr KOHEN JAMALEDDINE	mouhajir mohamed
country	Morocco	Morocco	Morocco	Morocco
email	kohenjamaleddine@gmail.com	kohenjamaleddine@gmail.com	kohenjamaleddine@gmail.com	mouhajir10@gmail.com
role	Member and part of leadership	Membre et faisant partie des dirigeants	Membre et faisant partie des dirigeants	Membre et faisant partie des dirigeants
certified_specialist	830.0	830.0	830.0	830.0
provider_number	NaN	NaN	NaN	NaN
nurse_num	NaN	NaN	NaN	2000.0
nurse_num2	NaN	NaN	NaN	NaN
nurse_num3	NaN	NaN	NaN	NaN
nurse_num4	NaN	NaN	NaN	NaN
other_1	NaN	NaN	NaN	NaN

Oman

name	Ramlaa Alqassab
country	Oman
email	alqassabramlaa@gmail.com
role	Member and part of leadership
certified_specialist	304.0
provider_number	NaN
nurse_num	NaN
nurse_num2	NaN
nurse_num3	NaN
nurse_num4	NaN
other_1	NaN

Pakistan

name	FAUZIA ANIS KHAN
country	Pakistan
email	fauzia.khan@aku.edu
role	Member and part of leadership
certified_specialist	3393.0
provider_number	NaN
nurse_num	NaN
nurse_num2	NaN
nurse_num3	NaN
nurse_num4	NaN
other_1	NaN

Palestine

name	Waleed Rimawi	Waleed Rimawi	Waleed Rimawi
country	Palestine	Palestine	Palestine
email	rimawiwaleed@yahoo.com	rimawiwaleed@yahoo.com	rimawiwaleed@yahoo.com
role	Member and part of leadership	Member and part of leadership	Member and part of leadership
certified_specialist	133.0	133.0	133.0
provider_number	NaN	NaN	NaN
nurse_num	NaN	NaN	NaN
nurse_num2	NaN	NaN	NaN
nurse_num3	NaN	NaN	NaN
nurse_num4	NaN	NaN	NaN
other_1	NaN	NaN	NaN

Saudi Arabia

name	ahmed abdulmomen
country	Saudi Arabia
email	aturk@ksu.edu.sa
role	Member and part of leadership
certified_specialist	2372.0
provider_number	NaN
nurse_num	5.0
nurse_num2	NaN
nurse_num3	NaN
nurse_num4	NaN
other_1	NaN

Somalia

name	Mubarak Mohamed Jama
country	Somalia
email	eaglemj1987@gmail.com
role	Member and part of leadership
certified_specialist	NaN
provider_number	36.0
nurse_num	NaN
nurse_num2	NaN
nurse_num3	NaN
nurse_num4	NaN
other_1	NaN

Somaliland

name	Mohamed Abdi Abdallah
country	Somaliland
email	Maxamedbilaal2015@gmail.com
role	Member but not part of leadership
certified_specialist	NaN
provider_number	NaN
nurse_num	60.0
nurse_num2	NaN
nurse_num3	NaN
nurse_num4	NaN
other_1	NaN

Sudan

name	Ahmed El Safi
country	Sudan
email	ahmadalsafi@gmail.com
role	Member and part of leadership
certified_specialist	350.0
provider_number	NaN
nurse_num	500.0
nurse_num2	500.0
nurse_num3	700.0
nurse_num4	NaN
other_1	NaN

Syrian Arab Republic

name	Sabah alkayali
country	Syrian Arab Republic
email	Sabah.alkayali@outlook.com
role	Member and part of leadership
certified_specialist	450.0
provider_number	NaN
nurse_num	NaN
nurse_num2	NaN
nurse_num3	NaN
nurse_num4	NaN
other_1	NaN

Tunisia

name	MONCEF JENDOUBI	MONCEF JENDOUBI	Iheb LABBENE
country	Tunisia	Tunisia	Tunisia
email	moncef.jen@planet.tn	moncef.jen@planet.tn	iheb.labbene@fmt.utm.tn
role	Member and part of leadership	Membre et faisant partie des dirigeants	Membre et faisant partie des dirigeants
certified_specialist	NaN	NaN	156.0
provider_number	NaN	NaN	NaN
nurse_num	2600.0	2600.0	NaN
nurse_num2	NaN	NaN	NaN
nurse_num3	NaN	NaN	NaN
nurse_num4	NaN	NaN	NaN
other_1	NaN	NaN	NaN

Yemen

name	Abdullah Mohammed Al-Naggar
country	Yemen
email	alnajjara3@arab-board.education
role	Member and part of leadership
certified_specialist	74.0
provider_number	21.0
nurse_num	NaN
nurse_num2	NaN
nurse_num3	NaN
nurse_num4	NaN
other_1	NaN