Supporting
177

106: Quality of Life in Lucerne

What can the city administration of Lucerne do to enhance the quality of life for its residents?

Challenge Definition

During a student project, the city administration of Lucerne invited city residents to answer an online questionnaire about their perceived quality of life. The result of this online questionnaire is a rich set of data from 630 participants.

Already during the student-project, many interesting insights could be read from the data. Nevertheless, we would like to dig a little deeper in this set of data.

  • What coherences can be found?
  • How do the demographics influence the different aspects of life that are connected to quality of life?
  • What is your advice to the city administration?

The city administration is happy to use the results of this challenge to further improve quality of life in the city of Lucerne.

Data:

  • Answers of the online questionnaire (raw data, unpublished)
  • Results of the student project
  • Results of the (official) population survey 2019: www.lustat.ch/daten?id=26999

Contact: nadja.vonballmoos AT stadtluzern.ch
Title

Project

Our Approach

Title

To get to our overall goals we have different approaches.

  • We build clusters to group the data.
  • We look at correlations and use machine learning models (LM, Decision Tree …) to see which factors impact the overall quality of life the most.
  • We use text analysis to interpret the comment sections of the online questionnaire.
  • We search for specific demographic characteristics with a high or low quality of life to get further insights.

Main Results and Insights

Disclaimer: The data in this survey is not representative of the whole population of Lucerne

Clustering
By appling clustering on the whole data set, we could find 5 groups that differ in various aspects of their quality perception. Title Correlation Matrix
The Correlation Matrix helps us to understand, which variables correlate to a certain degree with the response variable "Lebensqualität Allg."
Title
Decisicion Trees
The Decision Tree gives us a idea, which variables could be relevant for the splits.

Title

Closer Look to City Participation
With help of logistic regression and classification trees we found that especially the variables "Zuzug" (time since moving in to Lucerne) and "Bildung" (eduction) have an influence on the city participation and engagement.

Title

Text analysis
A text analysis of the answers to the question "Wovon wünschen Sie sich mehr?" led to the following word cloud.
Title
Next steps

  • Further focus to more specific questions (based of the new insights)
  • Further analysis with more survey data
  • Build a framework including the most common used methods

These contents were scraped from an external site. Visit the original location to see all the formatting.

106: HackdaysLucerne - Quality of Life in Lucerne

What can the city administration of Lucerne do to enhance the quality of life for its residents?

Challenge Definition

During a student project, the city administration of Lucerne invited city residents to answer an online questionnaire about their perceived quality of life. The result of this online questionnaire is a rich set of data from 630 participants.

Already during the student-project, many interesting insights could be read from the data. Nevertheless, we would like to dig a little deeper in this set of data.

Ideas:

What coherences can be found? How do the demographics influence the different aspects of life that are connected to quality of life? What is your advice to the city administration? The city administration is happy to use the results of this challenge to further improve quality of life in the city of Lucerne.

Data:

Answers of the online questionnaire (raw data, unpublished) Results of the student project Results of the (official) population survey 2019: www.lustat.ch/daten?id=26999

Contact administration of Lucerne: nadja.vonballmoos@stadtluzern.ch

Git-Hub Documentation:

  • README.md
  • cleaned_data.csv (anonymised)
  • HackdaysLucerne-LifeQualityAnalysisArbenzKoelliker_Wenger (Correlation Matrix & Decision Tree)
  • CityEngagementvsDemographics
  • Comments-Analysis-StadtLuzern.ows (Word-Cloud)
  • clustering_personas.html
  • Analyse_Personas.xlsx
28.11.2020 18:00

Hackathon finished

28.11.2020 15:30

Documentation

Worked on by eldhose_poulose

28.11.2020 15:20

Documentation

Worked on by Carole

28.11.2020 15:17

Synchronized

Readme fetched from source by Marlen

28.11.2020 14:14

Progress made

Thank You all for the contributions. We are all set to present our interesting results.

-- eldhose_poulose

28.11.2020 14:02

Documentation

Worked on by irma

28.11.2020 13:43

Documentation

Worked on by Marlen

28.11.2020 13:42

Documentation

Worked on by waarbenz

28.11.2020 13:36

Documentation

Worked on by irma

28.11.2020 13:31

Synchronized

Readme fetched from source by waarbenz

28.11.2020 13:31

Synchronized

Readme fetched from source by Marlen

28.11.2020 13:30

Documentation

Worked on by irma

28.11.2020 13:29

Synchronized

Readme fetched from source by waarbenz

28.11.2020 13:29

Documentation

Worked on by irma

28.11.2020 13:20

Documentation

Worked on by Carole

28.11.2020 13:12

Documentation

Worked on by irma

28.11.2020 13:08

Documentation

Worked on by eldhose_poulose

28.11.2020 13:07

Documentation

Worked on by irma

28.11.2020 13:00

Documentation

Worked on by eldhose_poulose

28.11.2020 13:00

Synchronized

Readme fetched from source by waarbenz

28.11.2020 12:59

Documentation

Worked on by wdkoelli

28.11.2020 12:53

Documentation

Worked on by waarbenz

28.11.2020 12:50

Documentation

Worked on by irma

28.11.2020 12:49

Documentation

Worked on by wdkoelli

28.11.2020 12:47

Team forming

wdkoelli has joined

28.11.2020 12:47

Documentation

Worked on by eldhose_poulose

28.11.2020 12:28

Documentation

Worked on by waarbenz

28.11.2020 11:51

Documentation

Worked on by irma

28.11.2020 11:32

Documentation

Worked on by eldhose_poulose

28.11.2020 10:57

Documentation

Worked on by Marlen

28.11.2020 09:59

Documentation

Worked on by eldhose_poulose

28.11.2020 09:54

Progress made

An Overall idea and results is presented to the Team Owner. ⚡️🪐🚀

-- eldhose_poulose

28.11.2020 09:53

Documentation

Worked on by eldhose_poulose

28.11.2020 09:46

Documentation

Worked on by Carole

27.11.2020 21:03

Team forming

MatthiasW has joined

27.11.2020 20:09

Team forming

waarbenz has joined

27.11.2020 19:57

Team forming

Carole has joined

27.11.2020 19:42

Progress made

All set to go 😊😁🚀👏

-- eldhose_poulose

27.11.2020 19:40

Synchronized

Readme fetched from source by eldhose_poulose

27.11.2020 19:40

Documentation

Worked on by eldhose_poulose

27.11.2020 12:57

Team forming

irma has joined

27.11.2020 12:55

Team forming

laszlo_klliker has joined

27.11.2020 12:54

Team forming

Marlen has joined

27.11.2020 12:52

Team forming

eldhose_poulose has joined

27.11.2020 09:00

Hackathon started

11.11.2020 07:42

Documentation

Worked on by nad_ja

11.11.2020 07:40

Progress made

11.11.2020 07:39

Documentation

Worked on by nad_ja

11.11.2020 07:19

Team forming

nad_ja has joined

11.11.2020 07:19

Project started

Initialized by nad_ja

All attendees, sponsors, partners, volunteers and staff at our hackathon are required to agree with the Hack Code of Conduct. Organisers will enforce this code throughout the event. We expect cooperation from all participants to ensure a safe environment for everybody. For more details on how the event is run, see the Guidelines on our wiki.

Creative Commons LicenceThe contents of this website, unless otherwise stated, are licensed under a Creative Commons Attribution 4.0 International License.