Countries with the highest rates of diabetes
Question
You're given the following dataset showing population and diabetic information for hypothetical countries. A preview of the data is below:
| country_id | population_total | num_diabetic | sugar_intake_daily_grams | |
|---|---|---|---|---|
| 0 | 10860 | 3,567,433 | 254817 | 86 |
| 1 | 494 | 1,914,891 | 127659 | 74 |
| 2 | 3821 | 7,521,401 | 683764 | 96 |
| 3 | 2352 | 3,227,059 | 293369 | 111 |
| 4 | 4577 | 1,338,156 | 121651 | 126 |
Using this data, return a ranked list of the top 10 countries with the highest percent of citizens with diabetes. Additionally, visualize this information as you would for a non-technical stakeholder.
To help get you started, below is code (Python) to import the referenced dataset:
# Import libraries
%matplotlib inline
import pandas as pd
import matplotlib.pyplot as plt
import numpy as np
# Import data
df = pd.read_csv('https://raw.githubusercontent.com/erood/interviewqs.com_code_snippets/master/Datasets/population_diabetic_dataset.csv')