Python, Regex, Tableau
Project Overview:
Empowering a local charity’s community engagement, we implemented a Python and regex analytics solution to identify approximate locations of association members through Facebook posts. The goal was to create a static map of members, fostering connections and strengthening the community spirit.
Solution: Harnessing Python and Regex for Location Identification
The local charity initiated an engagement post, prompting users to share their postcodes for neighbour identification. However, users provided varying information—full postcodes, partial postcodes, or just the city name. Our Python-powered solution with regex parsing came into play to accurately identify each postcode or partial postcode and popular cities mentioned in the posts.
Visualizing Community: Proportional Maps for Connection
The outcome was a static map showcasing the distribution of members based on their approximate locations. To ensure privacy, only the district information from postcodes was used, avoiding the display of full postcodes. Proportional indications on the map highlighted areas with a higher concentration of users, fostering a sense of community and encouraging further connections.
Community Strengthening Impact: Thitening the Community Through Individual Connections
By providing a visual representation of community members, the project aimed to strengthen connections among residents. The map served as a tool for individuals to identify potential neighbours, fostering a sense of closeness and community. The project’s success lies in its ability to use technology for community building, encouraging a more interconnected and vibrant local association.