{"id":19930,"date":"2021-02-07T22:48:11","date_gmt":"2021-02-08T03:48:11","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/?p=19930"},"modified":"2021-02-09T21:25:21","modified_gmt":"2021-02-10T02:25:21","slug":"quality-of-care-health-system-performance-canada-and-other-countries","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=19930","title":{"rendered":"Quality of Care, Health System Performance, Canada and Other Countries"},"content":{"rendered":"\n
\"Justetc<\/a><\/figure>\n\n\n\n

Justetc Social Services (non-profit)<\/a>Jan 31<\/a> \u00b7 5 min read<\/p>\n\n\n\n

import pandas as pd
import matplotlib.pyplot as plt
%matplotlib inlinefrom __future__ import print_function
from ipywidgets import interact, interactive, fixed, interact_manual
import ipywidgets as widgetsquality_of_care = pd.read_excel('..\/data\/quality-of-care.xls')
quality_of_care.head()<\/pre>\n\n\n\n
\"png\"\/<\/figure>\n\n\n\n
# find all indicators
quality_of_care.set_index(['Indicator'])
indicators = pd.Index(quality_of_care['Indicator']).unique()

# find all years
years = quality_of_care['Data year'].dropna().unique()
indicators[0], years('30-Day In-Hospital Fatality: AMI',
 array([2015, 2014, 2013, 'Not applicable', '2013', '2014', '2015',
        '2012 to 2014', '2013 to 2015', '2010 to 2014', '2003 to 2008',
        '2006 to 2011', '2008 to 2013', '2007 to 2012', '2004 to 2009',
        2016, '2016'], dtype=object))# sort years
years = [ int(aYear) for aYear in years if (aYear != 'Not applicable') and len( str(aYear).split(' ')) <= 1 ]
years = sorted(years)
years

all_years = [0] + years
all_years[0, 2013, 2013, 2014, 2014, 2015, 2015, 2016, 2016]plt.rcParams['figure.figsize'] = [10, 10]
def plot_quality_of_care(year, indicator, bubble_scale, all_years=all_years):    
    # print('year, indicator', year, indicator)    
    plt.ion()    
    f = plt.figure()
    ax = f.gca()
    f.show()
    
    #indicator_data = health_status.loc[  (health_status['Indicator'] == indicators[0] ) ]    
    if ( year > 1 ):        
        indicator_data = quality_of_care.loc[  (quality_of_care['Indicator'] == indicator)  & (quality_of_care['Data year'] == year) ]        
        ax.scatter(indicator_data['Data year'], indicator_data['Region'], s=indicator_data['Value'] * bubble_scale )
        plt.show()
        
    else:
        for aYear in all_years:
            indicator_data = quality_of_care.loc[  (quality_of_care['Indicator'] == indicator)  & (quality_of_care['Data year'] == aYear) ]
            ax.scatter(indicator_data['Data year'], indicator_data['Region'], s = indicator_data['Value'] * bubble_scale )
            f.canvas.draw()# create the interactive interface
def f(x):
    return x


indicator = interactive(f, x=indicators);
display(indicator)
indicator.result

year = interactive(f, x=all_years);
display(year)
year.result


bubble_scale = interactive(f, x=(0, 100, 1));
display(bubble_scale)
bubble_scale.resultinteractive(children=(Dropdown(description='x', options=('30-Day In-Hospital Fatality: AMI', '30-Day In-Hospit\u2026



interactive(children=(Dropdown(description='x', options=(0, 2013, 2013, 2014, 2014, 2015, 2015, 2016, 2016), v\u2026



interactive(children=(IntSlider(value=50, description='x'), Output()), _dom_classes=('widget-interact',))





50plot_quality_of_care(year.result, indicator.result, bubble_scale.result)C:\\ProgramData\\Anaconda3\\lib\\site-packages\\matplotlib\\figure.py:445: UserWarning: Matplotlib is currently using module:\/\/ipykernel.pylab.backend_inline, which is a non-GUI backend, so cannot show the figure.
  % get_backend())<\/pre>\n\n\n\n
\"png\"\/<\/figure>\n\n\n\n
plt.rcParams['figure.figsize'] = [20, 10]
def plot_quality_of_care_by_regions(year, indicator, bubble_scale, all_years=all_years):    
    #print('year, indicator', year, indicator)    
    plt.ion()    
    f = plt.figure()
    ax = f.gca()
    f.show()
    
    #indicator_data = health_status.loc[  (health_status['Indicator'] == indicators[0] ) ]
    
    if ( year > 1 ):
        #indicator_data = indicator_data [ indicator_data['Data year'] == year]
        indicator_data = quality_of_care.loc[  (quality_of_care['Indicator'] == indicator)  & (quality_of_care['Data year'] == year) ]
        #print(indicator_data)
        ax.scatter(indicator_data['Region'], indicator_data['Value'],  s=indicator_data['Value'] * bubble_scale )
        plt.show()
        
    else:
        for aYear in all_years:
            indicator_data = quality_of_care.loc[  (quality_of_care['Indicator'] == indicator)  & (quality_of_care['Data year'] == aYear) ]
            ax.scatter(indicator_data['Region'], indicator_data['Value'],  s = indicator_data['Value'] * bubble_scale )
            f.canvas.draw()print('Select parameter to visualize across countries over years')
# create the interactive interface
def f(x):
    return x


indicator = interactive(f, x=indicators);
display(indicator)
indicator.result

year = interactive(f, x=all_years);
display(year)
year.result


bubble_scale = interactive(f, x=(0, 100, 1));
display(bubble_scale)
bubble_scale.resultSelect parameter to visualize across countries over years



interactive(children=(Dropdown(description='x', options=('30-Day In-Hospital Fatality: AMI', '30-Day In-Hospit\u2026



interactive(children=(Dropdown(description='x', options=(0, 2013, 2013, 2014, 2014, 2015, 2015, 2016, 2016), v\u2026



interactive(children=(IntSlider(value=50, description='x'), Output()), _dom_classes=('widget-interact',))





50plot_quality_of_care_by_regions(year.result, indicator.result, bubble_scale.result)<\/pre>\n\n\n\n
\"png\"\/<\/figure>\n\n\n\n
plt.rcParams['figure.figsize'] = [20, 10]
def plot_quality_of_care_by_countries(year, indicator, bubble_scale, selected_countries, all_years=all_years):    
    #print('year, indicator', year, indicator)    
    plt.ion()    
    f = plt.figure()
    ax = f.gca()
    f.show()
    
    #indicator_data = health_status.loc[  (health_status['Indicator'] == indicators[0] ) ]
    
    if ( year > 1 ):
        #indicator_data = indicator_data [ indicator_data['Data year'] == year]
        indicator_data = quality_of_care.loc[  (quality_of_care['Indicator'] == indicator)  & (quality_of_care['Data year'] == str(year) ) & (quality_of_care['Type of region'] == 'Country' )     ]
        #print(indicator_data)
        
        if ( len(selected_countries) > 1 ):
            indicator_data = indicator_data[ indicator_data['Region'].isin(selected_countries)]
        
        ax.scatter(indicator_data['Region'], indicator_data['Value'],  s=indicator_data['Value'] * bubble_scale )
        plt.show()
        
    else:
        for aYear in all_years:
            indicator_data = quality_of_care.loc[  (quality_of_care['Indicator'] == indicator)  & (quality_of_care['Data year'] == str(aYear) ) & (quality_of_care['Type of region'] == 'Country' ) ]
            if ( len(selected_countries) > 1 ):
                indicator_data = indicator_data[ indicator_data['Region'].isin(selected_countries)]
                
            #print(indicator_data)
            ax.scatter(indicator_data['Region'], indicator_data['Value'],  s = indicator_data['Value'] * bubble_scale )
            f.canvas.draw()countries = quality_of_care[ quality_of_care['Type of region'] == 'Country' ]['Region']
countries = sorted (countries.unique())
#countries = ['Canada'] + countries
if 'Canada' in countries:
    countries = ['Canada'] + countries
    
#countriesprint('Select parameters to visualize across countries over years\\n')
# create the interactive interface
def f(x):
    return x

print('Select chart type:')
chart_types = ['Bubble', 'Bar', 'Pie', 'Line']
chart = interactive(f, x=chart_types);
display(chart)
chart.result

print('Select Indicator')
indicator_country = interactive(f, x=indicators);
display(indicator_country)
indicator_country.result

print('Select Year: 0 = all years')
year_country = interactive(f, x=all_years);
display(year_country)
year_country.result

print('Select bubble size')
bubble_scale_country = interactive(f, x=(0, 100, 1));
display(bubble_scale_country)
bubble_scale_country.result

print('Max country count to compare with')
country_count = interactive(f, x=range(1, 20));
display(country_count)
country_count.result

print('Select countries')
print('Compare with Canada')
all_countries = interactive(f, x=True);
display(all_countries)
all_countries.result

country_0 = interactive(f, x = countries);
country_1 = interactive(f, x = countries);
#country_str = \"var%d = interactive(f, x = countries)\"
display(country_0)
display(country_1)
country_0.result

print('Compare with Canada')
compare_canada = interactive(f, x=True);
display(compare_canada)
compare_canada.resultSelect parameters to visualize across countries over years

Select chart type:



interactive(children=(Dropdown(description='x', options=('Bubble', 'Bar', 'Pie', 'Line'), value='Bubble'), Out\u2026


Select Indicator



interactive(children=(Dropdown(description='x', options=('30-Day In-Hospital Fatality: AMI', '30-Day In-Hospit\u2026


Select Year: 0 = all years



interactive(children=(Dropdown(description='x', options=(0, 2013, 2013, 2014, 2014, 2015, 2015, 2016, 2016), v\u2026


Select bubble size



interactive(children=(IntSlider(value=50, description='x'), Output()), _dom_classes=('widget-interact',))


Max country count to compare with



interactive(children=(Dropdown(description='x', options=(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16\u2026


Select countries
Compare with Canada



interactive(children=(Checkbox(value=True, description='x'), Output()), _dom_classes=('widget-interact',))



interactive(children=(Dropdown(description='x', options=('Austria', 'Belgium', 'Chile', 'Czech Republic', 'Den\u2026



interactive(children=(Dropdown(description='x', options=('Austria', 'Belgium', 'Chile', 'Czech Republic', 'Den\u2026


Compare with Canada



interactive(children=(Checkbox(value=True, description='x'), Output()), _dom_classes=('widget-interact',))





Truecountry_0.result'Austria'selected_countries = []
if (all_countries.result == False):
    selected_countries = [country_0.result, country_1.result]
    
#print(year_country.result, indicator_country.result, bubble_scale_country.result)
plot_quality_of_care_by_countries(year_country.result, indicator_country.result, bubble_scale_country.result, selected_countries)
#print(country_0, country_1)<\/pre>\n\n\n\n
\"png\"\/<\/figure>\n\n\n\n
quality_of_care.loc[  (quality_of_care['Indicator'] == indicators[0])  & (quality_of_care['Data year'] == '2013') & (quality_of_care['Type of region'] == 'Country')     ]<\/pre>\n\n\n\n
\"png\"\/<\/figure>\n\n\n\n
Appendix<\/h1>\n\n\n\n
\"\"\"
print('Select countries')
for i in range(country_count.result):
    #country_str = interactive(f, x = countries);
    country_str = \"var%d = interactive(f, x = countries)\"
    display(country)
    country.result
\"\"\"

for i in range(country_count.result):
    country_str = \"var%d = interactive(f, x = countries)\" %(i)    

exec(country_str)
country_str

for i in [0, 2]:
    'var' + str(i)<\/pre>\n","protected":false},"excerpt":{"rendered":"
Justetc Social Services (non-profit)Jan 31 \u00b7 5 min read import pandas as pdimport matplotlib.pyplot as plt%matplotlib inlinefrom __future__ import print_functionfrom ipywidgets import interact, interactive, fixed, interact_manualimport ipywidgets as widgetsquality_of_care = pd.read_excel(‘..\/data\/quality-of-care.xls’)quality_of_care.head() # find all indicatorsquality_of_care.set_index([‘Indicator’])indicators = pd.Index(quality_of_care[‘Indicator’]).unique()# find all yearsyears = quality_of_care[‘Data year’].dropna().unique()indicators[0], years(’30-Day In-Hospital Fatality: AMI’, array([2015, 2014, 2013, ‘Not applicable’, ‘2013’, ‘2014’, ‘2015’, ‘2012 to 2014’, … <\/p>\n
Continue reading<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1903,1894,1919,182],"tags":[],"class_list":["post-19930","post","type-post","status-publish","format-standard","hentry","category-data-visualization","category-health-system-performance","category-visualize-health-system-performance","category---blog","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":19914,"url":"http:\/\/bangla.sitestree.com\/?p=19914","url_meta":{"origin":19930,"position":0},"title":"IPywidgets, interactive","author":"Sayed","date":"February 7, 2021","format":false,"excerpt":"Justetc Social Services (non-profit)\u00b7Jan 31 from __future__ import print_functionfrom ipywidgets import interact, interactive, fixed, interact_manualimport ipywidgets as widgetsdef f(x): return xinteract(f, x=10);interactive(children=(IntSlider(value=10, description='x', max=30, min=-10), Output()), _dom_classes=('widget-\u2026interact(f, x=True);interactive(children=(Checkbox(value=True, description='x'), Output()), _dom_classes=('widget-interact',))interact(f, x='Hi there!');interactive(children=(Text(value='Hi there!', description='x'), Output()), _dom_classes=('widget-interact',))@interact(x=True, y=1.0)def g(x, y): return (x, y)interactive(children=(Checkbox(value=True, description='x'), FloatSlider(value=1.0, description='y', max=3.0, \u2026interact(f, x=['apples','oranges']);interactive(children=(Dropdown(description='x', options=('apples',\u2026","rel":"","context":"In "Data Visualization"","block_context":{"text":"Data Visualization","link":"http:\/\/bangla.sitestree.com\/?cat=1903"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":19916,"url":"http:\/\/bangla.sitestree.com\/?p=19916","url_meta":{"origin":19930,"position":1},"title":"How to use ipywidgets, interactive as used in the project","author":"Sayed","date":"February 7, 2021","format":false,"excerpt":"Justetc Social Services (non-profit)Jan 31\u00a0\u00b7\u00a01\u00a0min read from __future__ import print_functionfrom ipywidgets import interact, interactive, fixed, interact_manualimport ipywidgets as widgetsdef f(x): return xinteract(f, x=10);interactive(children=(IntSlider(value=10, description='x', max=30, min=-10), Output()), _dom_classes=('widget-\u2026interact(f, x=True);interactive(children=(Checkbox(value=True, description='x'), Output()), _dom_classes=('widget-interact',))interact(f, x='Hi there!');interactive(children=(Text(value='Hi there!', description='x'), Output()), _dom_classes=('widget-interact',))@interact(x=True, y=1.0)def g(x, y): return (x, y)interactive(children=(Checkbox(value=True, description='x'), FloatSlider(value=1.0, description='y', max=3.0, \u2026interact(f, x=['apples','oranges']);interactive(children=(Dropdown(description='x',\u2026","rel":"","context":"In "Data Visualization"","block_context":{"text":"Data Visualization","link":"http:\/\/bangla.sitestree.com\/?cat=1903"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":19920,"url":"http:\/\/bangla.sitestree.com\/?p=19920","url_meta":{"origin":19930,"position":2},"title":"health_status_visualizations, Health System Performance, Canada and Others","author":"Sayed","date":"February 7, 2021","format":false,"excerpt":"Justetc Social Services (non-profit)Jan 31\u00a0\u00b7\u00a04\u00a0min read import pandas as pdimport matplotlib.pyplot as plt%matplotlib inlinefrom __future__ import print_functionfrom ipywidgets import interact, interactive, fixed, interact_manualimport ipywidgets as widgetshealth_status = pd.read_excel('..\/data\/health-status.xls')health_status.head() health_status.set_index(['Indicator'])#health_status.loc[health_status['Cancer Mortality (F)']]#health_status.index.unique()indicators = pd.Index(health_status['Indicator']).unique()years = health_status['Data year'].unique()indicators[0], years[0]('Cancer Mortality (F)', '2013')cancer_mortality_2013 = health_status.loc[ (health_status['Indicator'] == indicators[0]) & (health_status['Data year'] == years[0])\u2026","rel":"","context":"In "Data Visualization"","block_context":{"text":"Data Visualization","link":"http:\/\/bangla.sitestree.com\/?cat=1903"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":19909,"url":"http:\/\/bangla.sitestree.com\/?p=19909","url_meta":{"origin":19930,"position":3},"title":"About the Project : Benchmarking Canada\u2019s Health Care Systems: International Comparisons, 2017","author":"Sayed","date":"February 7, 2021","format":false,"excerpt":"Justetc Social Services (non-profit)Jan 31\u00a0\u00b7\u00a01\u00a0min read Project : Benchmarking Canada\u2019s Health Care Systems: International Comparisons, 2017 By Sayed Ahmed Objective: Visualize the performance of Canadian Healthcare System Performance against other countries Short Description\u00a0: Analyze, compare, and visualize the performance of Canadian healthcare system against other countries using public dataset. The\u2026","rel":"","context":"In "Data Visualization"","block_context":{"text":"Data Visualization","link":"http:\/\/bangla.sitestree.com\/?cat=1903"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":19922,"url":"http:\/\/bangla.sitestree.com\/?p=19922","url_meta":{"origin":19930,"position":4},"title":"interactive_health_status_visualizations, Health System Performance, Canada and Others","author":"Sayed","date":"February 7, 2021","format":false,"excerpt":"Justetc Social Services (non-profit)Jan 31\u00a0\u00b7\u00a05\u00a0min read import pandas as pdimport matplotlib.pyplot as plt%matplotlib inlinefrom __future__ import print_functionfrom ipywidgets import interact, interactive, fixed, interact_manualimport ipywidgets as widgetshealth_status = pd.read_excel('..\/data\/health-status.xls')health_status.head() # find all indicatorshealth_status.set_index(['Indicator'])indicators = pd.Index(health_status['Indicator']).unique()# find all yearsyears = health_status['Data year'].unique()indicators[0], years[0]('Cancer Mortality (F)', '2013')# sort yearsyears = [ int(aYear) for\u2026","rel":"","context":"In "Data Visualization"","block_context":{"text":"Data Visualization","link":"http:\/\/bangla.sitestree.com\/?cat=1903"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":19924,"url":"http:\/\/bangla.sitestree.com\/?p=19924","url_meta":{"origin":19930,"position":5},"title":"non_med_determinants_visualizations, Health System Performance, Canada and Others","author":"Sayed","date":"February 7, 2021","format":false,"excerpt":"Justetc Social Services (non-profit)Jan 31\u00a0\u00b7\u00a05\u00a0min read import pandas as pdimport matplotlib.pyplot as plt%matplotlib inlinefrom __future__ import print_functionfrom ipywidgets import interact, interactive, fixed, interact_manualimport ipywidgets as widgetsnon_med_determinants = pd.read_excel('..\/data\/non-med-determinants.xls')non_med_determinants.head() # find all indicatorsnon_med_determinants.set_index(['Indicator'])indicators = pd.Index(non_med_determinants['Indicator']).unique()# find all yearsyears = non_med_determinants['Data year'].dropna().unique()indicators[0], years('Alcohol Consumption: Adults', array(['2014', '2015', '2013', 2015, 'Not applicable', '2016'],\u2026","rel":"","context":"In "Data Visualization"","block_context":{"text":"Data Visualization","link":"http:\/\/bangla.sitestree.com\/?cat=1903"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/19930","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19930"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/19930\/revisions"}],"predecessor-version":[{"id":19931,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/19930\/revisions\/19931"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19930"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19930"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}