❔ About

Every year, data.gouv.nc and the The Pacific Community organize a challenge:

"... an international competition aimed at encouraging innovation and creativity in data visualization in the Pacific region."

🤗 Motivation

What I like the most in this event is both the community around this event and the opportunity to learn more about Storytelling:

👭 My choice : violence

During the kickoff event, I was looking for inspiration... but managed to get it very soon thanks to the following insights:

🎯 Why this post ?

I wrote this post to put things altogether :

• 💡 How I got inspiration (and put the DEV.to Women's empowerment Series' Articles in perspective)
• 📜 The whole dataprep workflow and the stack (duckdb, Neo4J on Kaggle)
• 🐍 The Kaggle Notebook : 🐚 PDC2024 - Domestic Violence & youth impact
• 🎞️ The final output video
• 🖼️ The static dataviz (Gephi & Gephisto)
• 🤓 The GitHub repo : adriens/pdc2024-violences

🤩 What I learnt

While preparing the data, I learnt a lot about :

• Socio-professional categories : PCS 2020 from INSEE.fr
• Violence categorization thanks to The Council of Europe Convention

👉 I could enhance the dataset with these to perform meaningful and standardized aggregations.

So I decided to explain this in a dedicated "behind the scene dataprep" where I explain what I learnt, did and the benefits I got out of these news data.

⚙️ "Behind the scene" Dataprep

🍿 First ever dynamic movie'like creation

🖼️ Static dataviz