himanshk96

## SQLZOO Window Function Solutions
1.
Show the lastName, party and votes for the constituency 'S14000024' in 2017.

SELECT lastName, party, votes
  FROM ge
 WHERE constituency = 'S14000024' AND yr = 2017
order by votes desc


Who won?

## ALS_implementation.py
# -*- coding: utf-8 -*-
"""
Created on Sun Jun 23 22:20:58 2019

@author: himansh
"""
#import libraries
import sys
import pandas as pd
import numpy as np

## OpenDataGovHack.txt
xls to sqlite:
http://www.parallelcodes.com/android-import-excel-into-sqlite-database-part-2/


https://stackoverflow.com/questions/5396286/sort-list-of-lon-lat-points-start-with-nearest


## address.txt
0x5D10cd4B3Aa56184Ef777c93D2f3e299eBA37E77
	1.
	Show the lastName, party and votes for the constituency 'S14000024' in 2017.

	SELECT lastName, party, votes
	FROM ge
	WHERE constituency = 'S14000024' AND yr = 2017
	order by votes desc


	Who won?
	# -- coding: utf-8 --
	"""
	Created on Sun Jun 23 22:20:58 2019

	@author: himansh
	"""
	#import libraries
	import sys
	import pandas as pd
	import numpy as np
	xls to sqlite:
	http://www.parallelcodes.com/android-import-excel-into-sqlite-database-part-2/


	https://stackoverflow.com/questions/5396286/sort-list-of-lon-lat-points-start-with-nearest