Parliament update: Who's the biggest talker in Berns local parliament

[benbitoun]

Pitch

I want to do a round up on the current years local parliament of the city of Berne. This includes counting and graphing the different types and numbers of parliamentary initiatives that were proposed, which politician was the most active during the current legislature and who talked the most/least.

Summary

Delete this line and summarize your project here (drag and drop images to add them - PDFs won't work, screenshots or png exports are good) So far I have just read in the files with the initiatives into one dataframe and cleaned it.

Now I try (again) to convert the pdf of the protocols and analyze and regex the text - before I totally forget how to do that. At the end an analysis of the talking time for member and party would be nice. Something like this: Tagi_parlament 2.pdf

Details

Possible headline(s): These are the biggest talkers in Berns Parliament Data set(s):

Code repository: https://github.com/benbitoun/data-studio/tree/master/Code/Parlament_project Possible problems/fears/questions:

• pdf to text problems
• regex limitations
• making a nice story with decent visualization out of a rather dry story

  Work so far

  mentioned above

Checklist

This checklist must be completed before you submit your draft.

• [ x] I have already spent time with my data set, opening it, exploring it, etc
• [ ] I have created a "DIARY.md" file to save links and list all of the terrible, no good problems I come across
• [ ] My issue links to my data set(s)
• [ ] My issue links to my code repository
• [ ] My issue explains what I'd like to explore in the data set
• [ ] My issue includes images - either inspiration or what I've done so far

[sarahslo]

Hi! One thing about that pdf you shared as an example: it has a broken bar for the biggest value. avoid this at all costs!

[malbasi]

Sounds like an interesting project. This sounds like a pretty broad topic. If you're going to narrow it down just to who is speaking most, it might be interesting to know what they're talking about as well.