Scenario: Public Health Data Analysis

 

You are a data analyst working for a public health organization in the Northland region. The organization is conducting a study to analyze the distribution of measles cases across different districts and demographic groups. The study focuses on three key districts in the Northland region: Far North, Whangarei, and Kaipara.

​

Creating a random dataset with specific conditions will be a good idea for initial analysis. This can later be automated for future tasks.

 

Study Requirements

 

Gender Distribution

The study requires an equal number of males and females.

A total of 12 records are needed, with 6 males and 6 females.

 

Age Groups

The study focuses on two age groups: "< 25 years old" and "> 25 years old".

Each gender should have an equal representation of both age groups.

 

District Distribution

The TA2023_code should be evenly distributed among the records.

Each district code ("001", "002", "003") should be repeated 4 times.

 

Measles Cases

The number of measles cases should be randomly generated within specified ranges:

"001" (Far North): 300 to 600 cases

"002" (Whangarei): 100 to 600 cases

"003" (Kaipara): 200 to 500 cases

 

Additional Data

The study should include district names, area in square kilometers, and geometry data.