michalskop · August 29, 2015 13:57
diff --git a/data2json.py b/data2json.py
 # -*- coding: utf-8 -*-

 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)
 #      print winners

 #      print people
 #      print r
 #      raise(Exception,'dipy')  

    i = i + 1
 #Bárdos	Behýl	Čarnogurský	Fico	Fischer	Hrušovský	Jurišta	Kiska	Kňažko	Martinčko	Melník	Mezenská	Procházka	Šimko
 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 #F39C2D
 data = {'people':people,'votes':votes,'colors':colors}
 with open('sk_president_2014_1.json', 'w') as outfile:
  json.dump(data, outfile)
 outfile.close()
diff --git a/index.html b/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="http://code.jquery.com/jquery-1.8.2.min.js"></script>
 	
 	
 	<script>
 	  // see http://leafletjs.com/reference.html
 	  L_PREFER_CANVAS = true;
 	</script>

 	<link rel="stylesheet" href="//netdna.bootstrapcdn.com/bootstrap/3.0.2/css/bootstrap.min.css">
    <link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.6.4/leaflet.css" />
 	 <!--[if lte IE 8]>
 		 <link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.6.4/leaflet.ie.css" />
 	 <![endif]-->
    <script src="http://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">


 		// Create the map
 		var map = L.map('map',{zoomControl: false}).setView([48.695493,19.467773], 8);
 		map.addControl( L.control.zoom({position: 'topright'}) );
 		
 		// add an OpenStreetMap tile layer
 		// also see http://wiki.openstreetmap.org/wiki/Tiles
 		//L.tileLayer('http://{s}.tile.osm.org/{z}/{x}/{y}.png', {
 		L.tileLayer('http://{s}.www.toolserver.org/tiles/bw-mapnik/{z}/{x}/{y}.png', {
 			attribution: '&copy; <a href="http://osm.org/copyright">OpenStreetMap</a> contributors'
 		}).addTo(map);
 		
 		//add circles
 		$.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>";
                }
 				/*sum = 0;
 				$.each(value.description, function (i, v) {
 				  tmp = Math.round(parseInt(v.value) / parseInt(value.population) * 1000) / 10;
 				  description += v.name + ': ' +  tmp + '% (' + v.value + ' hlasů)<br>';
 				  sum += parseInt(v.value)
 				});
 				tmp = Math.round((parseInt(value.population) - sum) / parseInt(value.population) * 1000) / 10;
 				tmp2 = value.population - sum;
 				description += "Ostatní: " + tmp + '% (' + tmp2 + ' hlasů)';*/
 		    
 		    
 				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>
diff --git a/obce2obce.py b/obce2obce.py
 # -*- coding: utf-8 -*-

 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)
diff --git a/obce3.1.csv b/obce3.1.csv
diff --git a/obce3.csv b/obce3.csv
diff --git a/sk_president_2014_1.json b/sk_president_2014_1.json
diff --git a/thumbnail.png b/thumbnail.png
	# -- coding: utf-8 --

	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)
	# print winners

	# print people
	# print r
	# raise(Exception,'dipy')

	i = i + 1
	#Bárdos Behýl Čarnogurský Fico Fischer Hrušovský Jurišta Kiska Kňažko Martinčko Melník Mezenská Procházka Šimko
	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 #F39C2D
	data = {'people':people,'votes':votes,'colors':colors}
	with open('sk_president_2014_1.json', 'w') as outfile:
	json.dump(data, outfile)
	outfile.close()
	<!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="http://code.jquery.com/jquery-1.8.2.min.js"></script>


	<script>
	// see http://leafletjs.com/reference.html
	L_PREFER_CANVAS = true;
	</script>

	<link rel="stylesheet" href="//netdna.bootstrapcdn.com/bootstrap/3.0.2/css/bootstrap.min.css">
	<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.6.4/leaflet.css" />
	<!--[if lte IE 8]>
	<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.6.4/leaflet.ie.css" />
	<![endif]-->
	<script src="http://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">


	// Create the map
	var map = L.map('map',{zoomControl: false}).setView([48.695493,19.467773], 8);
	map.addControl( L.control.zoom({position: 'topright'}) );

	// add an OpenStreetMap tile layer
	// also see http://wiki.openstreetmap.org/wiki/Tiles
	//L.tileLayer('http://{s}.tile.osm.org/{z}/{x}/{y}.png', {
	L.tileLayer('http://{s}.www.toolserver.org/tiles/bw-mapnik/{z}/{x}/{y}.png', {
	attribution: '© <a href="http://osm.org/copyright">OpenStreetMap</a> contributors'
	}).addTo(map);

	//add circles
	$.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>";
	}
	/*sum = 0;
	$.each(value.description, function (i, v) {
	tmp = Math.round(parseInt(v.value) / parseInt(value.population) * 1000) / 10;
	description += v.name + ': ' + tmp + '% (' + v.value + ' hlasů)<br>';
	sum += parseInt(v.value)
	});
	tmp = Math.round((parseInt(value.population) - sum) / parseInt(value.population) * 1000) / 10;
	tmp2 = value.population - sum;
	description += "Ostatní: " + tmp + '% (' + tmp2 + ' hlasů)';*/


	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>
	# -- coding: utf-8 --

	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)