Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Medicines.csv contains availability of essential medicines in 3 8 countries for the years 2 0 0 7 - 2 0 1 3 , obtained from

Medicines.csv contains availability of essential medicines in 38 countries for
the years 2007-2013, obtained from the World Health Organization (WHO). Dataset
format: CSV
Field names (in order): Country, Median availability of selected generic medicines (%)-
Private, Median availability of selected generic medicines (%)- Public
Answer the following questions from this data using UNIX commands:
1. Which country had the lowest percentage median availability of selected
generic medicines in private.
2. Top five countries with highest public percentage median availability of
selected generic medicines.
3: List the top three countries where it is best to rely on the private availability of
selected generic medicines than public. Explain your answer with valid reasons.
Medicines.csv
Country 2007-20132007-2013
Afghanistan 9481.1
Bahamas 42.943.2
Bolivia (Plurinational State of)86.731.9
Brazil 76.70
Burkina Faso 72.187.1
Burundi 58.346.7
China 13.315.5
Colombia 90.786.7
Congo 31.321.2
Cook Islands 33.3100
Democratic Republic of the Congo 65.455.6
Dominican Republic 6552
Ecuador 71.141.7
El Salvador 78.658.4
Haiti 54.317.6
India 2.8
Indonesia 57.865.5
Iran (Islamic Republic of)96.796.7
Kazakhstan 86.740
Kyrgyzstan 70
Malawi 55.663.3
Mauritius 7088.8
Mexico 5042.6
Mongolia 9038.7
Nicaragua 87.175
Niger 65.835
Oman 70.396.7
Philippines 21.726.8
Republic of Moldova 5646
Russian Federation 100100
Rwanda 8046.3
Sao Tome and Principe 22.256.3
Sudan 91.777.1
Syrian Arab Republic 98.293
Uganda 7870
Ukraine 91.488.6
United Republic of Tanzania 5037.8
Zambia 81.374

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Application And Administration

Authors: Michael Mannino, Michael V. Mannino

2nd Edition

0072880678, 9780072880670

More Books

Students also viewed these Databases questions

Question

How wide are Salary Structure Ranges?

Answered: 1 week ago