index.html
<!DOCTYPE html>
<html>
<head>
<title>Slovak presidential election 2014 - 1st round</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="initial-scale=1.0, user-scalable=no"/>
<script src="//code.jquery.com/jquery-1.8.2.min.js"></script>
<script>
L_PREFER_CANVAS = true;
</script>
<link rel="stylesheet" href="//netdna.bootstrapcdn.com/bootstrap/3.0.2/css/bootstrap.min.css">
<link rel="stylesheet" href="//cdn.leafletjs.com/leaflet-0.6.4/leaflet.css" />
<script src="//cdn.leafletjs.com/leaflet-0.6.4/leaflet.js"></script>
<style type="text/css">
html, body, #map {
width: 100%;
height: 100%;
margin: 0;
padding: 0;
}
.leaflet-tile-pane {
opacity: .3
}
.leaflet-container {
background-color: #fff;
}
</style>
</head>
<body>
<div class="navbar navbar-inverse navbar-fixed-top" role="navigation">
<div class="container">
<div class="navbar-header">
<a class="navbar-brand" href="#">Slovak presidential election 2014 - 1st round</a>
</div>
</div>
</div>
<div style="position:fixed;top:50px;z-index:1000;">
<div class="alert alert-info" >The <strong>size</strong> of bubbles represents number of voters, the <strong>color</strong> represents the winner.</div>
</div>
<div style="position:fixed;top:125px;z-index:1000;">
<div class="alert alert-info" style="float:left;">
<svg height="20" width="20"><circle cx="10" cy="10" r="10" fill="#ff0000"></svg> Fico<br/>
<svg height="20" width="20"><circle cx="10" cy="10" r="10" fill="#F39C2D">></svg> Kiska<br/>
<svg height="20" width="20"><circle cx="10" cy="10" r="10" fill="#162485"></svg> Procházka<br/>
<svg height="20" width="20"><circle cx="10" cy="10" r="10" fill="#6A6A6A"></svg> Kňažko<br/>
<svg height="20" width="20"><circle cx="10" cy="10" r="10" fill="#0c0"></svg> Bárdos<br/>
<svg height="20" width="20"><circle cx="10" cy="10" r="10" fill="#008"></svg> Hrušovský<br/>
<svg height="20" width="20"><circle cx="10" cy="10" r="10" fill="#bed62f"></svg> Mezenská
</div>
</div>
<div id="map" style="margin-top:40px;"></div>
<script type="text/javascript">
var map = L.map('map',{zoomControl: false}).setView([48.695493,19.467773], 8);
map.addControl( L.control.zoom({position: 'topright'}) );
L.tileLayer('//{s}.www.toolserver.org/tiles/bw-mapnik/{z}/{x}/{y}.png', {
attribution: '© <a href="//osm.org/copyright">OpenStreetMap</a> contributors'
}).addTo(map);
$.getJSON( "sk_president_2014_1.json", function (data) {
$.each(data.votes, function (index, value) {
description = "<strong>" + value.town + "</strong> (" + value.population + ")<br>";
tuples = [];
for (var key in value.votes) {
tuples.push([key,parseInt(value.votes[key])]);
}
tuples.sort(function(a, b) {
a = a[1];
b = b[1];
return a < b ? 1 : (a > b ? -1 : 0);
});
for (i = 0; i < 5; i++) {
tmp = Math.round(parseInt(tuples[i][1]) / parseInt(value.population) * 100);
description += data.people[tuples[i][0]] + ": " + tmp +"%<br>";
}
circle = L.circle([value.lat, value.lng], Math.sqrt(parseInt(value.population)*1000), {
color: data.colors[value.winner_class],
fillColor: data.colors[value.winner_class],
fillOpacity: 0.85,
weight: 0.1,
}).addTo(map);
circle.bindPopup(description);
});
});
</script>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-8592359-13', 'ocks.org');
ga('send', 'pageview');
</script>
</body>
</html>
data2json.py
import csv
import json
import unicodedata
i = 0
people = []
votes = []
winners = {}
with open('obce3.1.csv','r') as f:
csvreader = csv.reader(f,delimiter=",")
for row in csvreader:
if i == 0:
for j in range(6,20):
people.append(row[j])
winners[row[j]] = 0
else:
r = {}
r['id'] = row[0]
r['town'] = row[3]
r['lat'] = row[4]
r['lng'] = row[5]
r['votes'] = []
maxi = 0
sumi = 0
for j in range(0,14):
r['votes'].append(row[j+6])
sumi = sumi + int(row[j+6])
if (int(row[j+6])) > maxi:
winner = people[j]
maxi = int(row[j+6])
r['winner'] = winner
r['winner_class'] = unicodedata.normalize('NFKD', winner.decode('utf8')).encode('ASCII', 'ignore').lower()
r['population'] = sumi
winners[winner] = winners[winner] + 1
votes.append(r)
i = i + 1
colors = {'bardos':'#0c0','behyl':'#888','carnogursky':'#000','fico':'#f00','fischer':'#888', 'hrusovsky':'#00f', 'jurista':'#888','kiska':'#F39C2D','knazko':'#6A6A6A','martincko':'#888','melnik':'#888', 'mezenska':'#bed62f', 'prochazka':'#162485','simko':'#bed62f'}
print winners
data = {'people':people,'votes':votes,'colors':colors}
with open('sk_president_2014_1.json', 'w') as outfile:
json.dump(data, outfile)
outfile.close()
obce2obce.py
import csv
outfile = open('obce2.csv', 'w')
outwriter = csv.writer(outfile, quoting=csv.QUOTE_NONNUMERIC)
obvody = {}
with open('obvody.csv','r') as f:
csvreader = csv.reader(f,delimiter=",")
for row in csvreader:
obvody[row[0]] = row
obce = []
with open('obce.csv','r') as f:
csvreader = csv.reader(f,delimiter=",")
for row in csvreader:
if row[2] != '':
obce.append(row)
last_region = row[1]
last_obvod = row[2]
else:
town = [row[0],last_region,last_obvod,row[3]]
obce.append(town)
for town in obce:
outwriter.writerow(town)