Create data set on pneumococcal vaccination rates among children ages 12-23 months

[cliftonmcintosh]

For the upcoming federal version of NepalMap, we would like to present data on pneumococcal vaccination rates. These data are available in Table 10.3 on page 212 of the Nepal Demographic and Health Survey of 2016 (PDF here). Extract the data from Table 10.3 so that it is in a csv that conforms to the following specifications:

• It should have three columns: province, number of doses, total
• The columns should be separated by commas
• The headers should be the first row in the CSV
• The "number of doses" options should be "NONE", "ONE", "TWO", "THREE"
• The "total" should be the number of children age 12-23 months in a province whose parents were surveyed and whose dosage fits each "number of doses" category under the heading "Pneumococcal." In other words, the percent statistics in the table should be converted to raw numbers. Percents should be rounded with a sensible strategy. Totals after rounding should match the total in the first "Number of children" column in Table 10.3.
• Note that the values are cumulative. For example, if 1 dose is at 75%, 2 doses is at 65%, and 3 doses is at 40%, that means that 10% of the children have received only one dose, 25% of the children have received only 2 doses, 40% have received 3 doses and 25% have received no doses.
• Calculate raw numbers from the percentages. For example, if there are 100 total children age 12-23 months in Province 1 and 50.1% of the children have received one dose of pneumococcal vaccine, then there should be a row that looks like this: "Province 1,ONE,50". Please note that the number of children who have received no pneumococcal vaccine doses will need to be inferred from the percentage of children who have received one or more. Please note that there are TWO "number of children" columns. You should use the first "number of children" column (16th column overall) because it is the one that is for children ages 12-23 months. The last column in the table is NOT the one to use because it is for older children.
• The file should be named "pneumococcal_vaccination_twelve_to_twenty_three_months.csv"
• The file should be placed in the directory "Federal Data/Nepal Demographic and Health Survey 2016"

[Gage77]

created pull request for this issue

[cliftonmcintosh]

@Gage77

Responded with a request for a correction to the PR.

[cliftonmcintosh]

This isssue is still open. PR #38 has been closed.