Find Your Paradise

• Event Name: RVCE-HPCC Hackathon
• Team Name: Team Believers
• Team Members: M Nithyashree, Goutami Sooda, Chandana S

Challenge Overview

Find Your Paradise by weighing selected "quality of life" factors

Have you ever thought about building an application that can help people find places to live that maximize their quality of life and happiness?

The goal of this challenge is to analyze numerous datasets across different categories and make correlations with the data, using the HPCC Systems platform. After analyzing, the participants will be asked to design an interface to query this data and assign it a scoring system, then deliver it to the user via ROXIE and show the user where they should most likely want to live. Users should be given choices in an easy-to-use form that when submitted will generate a unique set of scores based on locations (Example: By State).

Every person’s definition of what make them happy can vary depending on several factors. To this challenge, we have narrowed these factors to four (4) categories: • Crime • Environment (Weather) • Health • Education

Crime – A dataset by US State with crimes between 2018-2021 is provided. Data points can include the number of crimes by State and Violent Crimes by State.

Climate – A dataset of Storm Data in the US over the last 10 years will be provided. Data Points can include number of storms by State, also injuries and fatalities due to a weather incident.

Health – A mortality rate by State from 1980 to 2020 dataset will be provided. Data points can include total mortality and/or average mortality by year and State.

Education – A dataset of the number of public and private schools by State will be provided. Data points include total school by State and percentage of Private Schools available to the Total Schools by State. Also, enrollment and student-to-teacher ratio can be a factor.

Solution Approach

Our solution revolves around an extensive analysis of parameter fields within five datasets linked to Education, Health, Crime, Weather, and Population. The process unfolds as follows:

1. Dataset Analysis: Thoroughly scrutinizing datasets related to Education, Health, Crime, Weather, and Population.

2. Data Filtering: Carefully curating datasets to include only the parameters essential for a comprehensive analysis.

3. Weighted Scores: Calculating weighted scores for crucial parameters, emphasizing factors contributing to a superior quality of life.

4. Cumulative Score: Deriving a cumulative score for each state based on user-selected parameters.

5. ROXIE Query: Designing a dynamic ROXIE query that takes user input to determine parameters for the final score calculation.

6. Population Density: Introducing a new dataset considering the population of states, calculating population density, and incorporating it as an additional weighted score.

7. Conclusion: Following the analysis, the results indicate that New York emerges with the highest score, making it the most favorable state to reside in within the US.