Using Social Media Data to Explore Place Activity During the 2018 Gold Coast Commonwealth Games

location_city Sydney schedule May 15th 04:30 - 05:00 PM place Wesley Theatre people 147 Interested

Why do people choose to live in one neighbourhood over another? Every day government makes decisions that can change the way a neighbourhood operates and feels. Understanding the impact that these decisions have is convoluted and hard to measure.

In April, the Gold Coast held the 2018 Commonwealth Games. These events, usually advertised as urban renewal or regeneration projects, have a lasting impact on the neighbourhoods where they take place. Usually, there is a strong push to predic the impact of the games through economic assessments and surveys, however, once the games are happening, is that impact tracked? Sometimes, further economic assessments are produced years after the event which evaluate whether the impact was as expected. Can we do better?

Social data can provide us with more timely evidence of whethere the event is activating the economy as expected, or maybe highlight issues that can be resolved.

Using social media data we will explore Facebook places data during and after the games, ultimately generating a dashboard to help us visualise change by giving us the ability to filter and aggregate the data. We will manage the data using Python’s Pandas, generate quick visualisations using Plotly, and finish off by spinning up a dashboard using Plotly’s Dash.


Outline/Structure of the Case Study

  1. Outline/structure of the Session
  2. Motivation
    • Neighbourhoods can be rocked or improved by investment in large events.
    • Case study: The Gold Coast Commonwealth Games
    • Introduce previous similar events
  3. Introduce (pre-assembled) Facebook data in Pandas -- > structure, interesting metrics, the API.
    • The data has a lot of information --> narrow the scope: let's focus on checkins
  4. Visualisations
    • Build some quick and useful plots with Plotly --> make a map
    • Introduce the time component --> build some scatter plots
    • Add interactivity --> add a slider for categories
  5. Bring things together - introduce Dash
    • Make a dashboard
    • What can we deduce?
  6. Lessons learnt, improvements, future hopes
  7. Questions, etc

Learning Outcome

Participants should be able to

- make a quick visualisation from a Pandas dataframes using Plotly

- create a basic dashboard using Dash

- discuss the use of social media data to understand neighbourhoods with a focus in community development

Target Audience

People interested in data visualisation and using data to enact positive change. People interested in Pandas, Plotly and Dash.

Prerequisites for Attendees


schedule Submitted 2 years ago