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

This content is a preview from an external site.

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

Event finished

28.11.2020 18:00

Edited content

28.11.2020 15:30 ~ eldhose_poulose

Repository updated

28.11.2020 15:17 ~ Marlen

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

28.11.2020 14:14 ~ eldhose_poulose

Edited content

28.11.2020 14:02 ~ irma

Repository updated

28.11.2020 13:31 ~ waarbenz

Edited content

28.11.2020 13:30 ~ irma

Repository updated

28.11.2020 13:29 ~ waarbenz

Edited content

28.11.2020 13:29 ~ irma

Repository updated

28.11.2020 13:00 ~ waarbenz

Edited content

28.11.2020 12:59 ~ wdkoelli

Joined the team

28.11.2020 12:47 ~ wdkoelli

Edited content

28.11.2020 12:47 ~ eldhose_poulose

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

28.11.2020 09:54 ~ eldhose_poulose

Edited content

28.11.2020 09:53 ~ eldhose_poulose

Joined the team

27.11.2020 21:03 ~ MatthiasW

All set to go 😊😁🚀👏

27.11.2020 19:42 ~ eldhose_poulose

Repository updated

27.11.2020 19:40 ~ eldhose_poulose

Edited content

27.11.2020 19:40 ~ eldhose_poulose

Joined the team

27.11.2020 12:57 ~ irma

Event started

27.11.2020 09:00

Edited content

11.11.2020 07:42 ~ nad_ja

Joined the team

11.11.2020 07:19 ~ nad_ja

Challenge posted

11.11.2020 07:19 ~ 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.

Shape My City