himanshk96
himanshk96
/ address.txt
Created
June 24, 2017 06:24
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 0x5D10cd4B3Aa56184Ef777c93D2f3e299eBA37E77 |
himanshk96
/ OpenDataGovHack.txt
Last active
September 23, 2017 08:07
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 | |
himanshk96
/ ALS_implementation.py
Created
June 23, 2019 19:15
Recommendation using ALS for implicit data. Code for Medium Blog
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # -*- 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 |
himanshk96
/ SQLZOO Window Function Solutions
Created
April 6, 2020 11:27
SQLZOO Window Function Solutions
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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? |