Tabula<\/a>.<\/p>\n<\/p>\n
I converted all PDF to CSV format manually one by one :<\/p>\n
<\/p>\n
Then combined them in one file using “miller” :<\/p>\n
mlr --rs lf --csv sort -f date,code *.csv > combined.csv<\/pre>\nOf course I make sure that I reversed columns order in Tunis2 file before combining files to be able to directly work with data. I was looking for independent lists, but that’s how I discovered that the whole list of names is messing !<\/p>\n
<\/p>\n
Cluster analysis of data in Arabic is really hard, but it can help :<\/p>\n
<\/p>\n
So I started combining names to make sure that a same list have the same name in the whole dataset. The final result is quiet interesting : about 9% of independent lists have more than one list, six of them have more than ten lists ! Especially if you know that 21 parties are participating in this elections with one list only ! Independent lists seems to be more powerful than many well known political parties.<\/p>\n
<\/p>\n
<\/p>\n
I will stop here, below the list of\u00a0 independent parties participating in this municipal elections and having more than\u00a0 10 lists :<\/p>\n
<\/p>\n
It’s great to have independent lists participating in these elections, however lots of questions come to my mind when I saw these numbers. Are they really independent ? Who is behind these lists ? I think it’s for the ISIE to answer these questions in case municipal elections are going to happen this 6th May 2018.<\/p>\n\n","protected":false},"excerpt":{"rendered":"
Level : Intermediate Requirements : Some knowledge of Linux Shell, Tabula, and any spreadsheets software. Publishing elections data in closed format become very common, in case any data have been published. Few days from the municipal elections we are still worried if it is going really to happen or not. Efforts come as usual from […]<\/p>\n","protected":false},"author":1,"featured_media":5488,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,8],"tags":[82,178],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/hbyconsultancy.com\/wp-content\/uploads\/2018\/04\/LOGO-BALADIYA2018-FB-Cover-1.jpg?fit=3405%2C1281&ssl=1","_links":{"self":[{"href":"https:\/\/hbyconsultancy.com\/wp-json\/wp\/v2\/posts\/5474"}],"collection":[{"href":"https:\/\/hbyconsultancy.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hbyconsultancy.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hbyconsultancy.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hbyconsultancy.com\/wp-json\/wp\/v2\/comments?post=5474"}],"version-history":[{"count":0,"href":"https:\/\/hbyconsultancy.com\/wp-json\/wp\/v2\/posts\/5474\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hbyconsultancy.com\/wp-json\/wp\/v2\/media\/5488"}],"wp:attachment":[{"href":"https:\/\/hbyconsultancy.com\/wp-json\/wp\/v2\/media?parent=5474"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hbyconsultancy.com\/wp-json\/wp\/v2\/categories?post=5474"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hbyconsultancy.com\/wp-json\/wp\/v2\/tags?post=5474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}