Map the fans

[thisss]

Is it true that football is an urban thing while ice hockey is the country bumpkin's game?

I recently received the ZIP-codes for every long term card for the games of Bern's biggest sport clubs "YB" (football) and "SCB" (ice hockey). I will harmonize this data, put it on a map and analyse it further.

Possible headlines:

• Your surrounding tells you who to fan for
• Portrait of a fan that spends his money for football and ice hockey.
• Report from the community with the highest subscription per capita

Tools:

• I will rework, clean and analyze the data in Python.
• The mapping will be done in Carto

[thisss]

Story issue checklist

My pitch was (use the number): #23

• My pitch has been approved (see PITCHING.md)
• My story issue links to my pitch issue
• I have included an update of my visualization/story in a comment
• I have received two comments of peer feedback
• I have received editorial feedback

[thisss]

I just finished importing, cleaning and exploring the data. Would you like to take a look at my Jupyter notebook? You will find the data in my repository. I am now beginning to work on the map.

[barjacks]

Looking great. I would suggest you make 2 separate interactive maps. And one static map, where you compare the differences. Maybe this as the visual entry point to the story.

[palrogg]

Great notebook! I'm wondering if some correlation may help you to find interesting things (with a simple df.corr()).
For example, your plz.csv file contains demographic. Is there, for example, a correlation between the number of girls aged 15-19 and the hockey cards?

[playfairbot]

Hi there, I'm the Playfair Bot! Would you mind posting the appropriate checklist in the main body of your issue? You might have posted it as the first comment, but it turns out it works way better in the actual body of the issue - just go up to the veeery top right and click the pencil icon to edit. You'll probably want to edit the comment to copy the checklist, then edit the original issue to paste it in. Thanks! 🙏

[playfairbot]

Hi there, I'm the Playfair Bot! Thanks for posting your story issue, but would you mind adding editing the original issue to add the first draft of your image? You have my sincere apologies, but it's easier for dumb robots like me when the comments are only used for updates. Thanks! 🙏

[playfairbot]

Hi there, I'm the Playfair Bot! Would you mind linking to your pitch issue by using the '#1' method (but with your actual pitch issue number)? It'll hopefully help us keep things neat and organized. Thanks a zillion! 🙏

[playfairbot]

Closing since pull request #139 has been accepted