I hereby claim:
- I am gitcheckoutnikhil on github.
- I am nikhil_bhat (https://keybase.io/nikhil_bhat) on keybase.
- I have a public key ASAklgF7gDsrAW6tHqWiU4yanjis9Ad2dt6SiJ-UqaayVQo
To claim this, I am signing this object:
# 10_basic.py | |
# 15_make_soup.py | |
# 20_search.py | |
# 25_navigation.py | |
# 30_edit.py | |
# 40_encoding.py | |
# 50_parse_only_part.py |
import urllib3 | |
http = urllib3.PoolManager() | |
r = http.request('GET', 'http://httpbin.org/robots.txt') | |
# Get status | |
r.status | |
# Get data | |
r.data |
I hereby claim:
To claim this, I am signing this object:
CASE | |
WHEN context_device_model IN ('iPhone1,1') THEN 'iPhone' | |
WHEN context_device_model IN ('iPhone1,2') THEN 'iPhone 3G' | |
WHEN context_device_model IN ('iPhone2,1') THEN 'iPhone 3GS' | |
WHEN context_device_model IN ('iPhone3,1', 'iPhone3,2', 'iPhone3,3') THEN 'iPhone 4' | |
WHEN context_device_model IN ('iPhone4,1', 'iPhone4,2', 'iPhone4,3') THEN 'iPhone 4S' | |
WHEN context_device_model IN ('iPhone5,1', 'iPhone5,2') THEN 'iPhone 5' | |
WHEN context_device_model IN ('iPhone5,3', 'iPhone5,4') THEN 'iPhone 5C' | |
WHEN context_device_model IN ('iPhone6,1', 'iPhone6,2') THEN 'iPhone 5S' | |
WHEN context_device_model IN ('iPhone7,2') THEN 'iPhone 6' |
--first value | |
first_value(country_id) | |
over(partition by user_id order by row_date | |
rows between unbounded preceding and unbounded following) as country_id, | |
--rank | |
rank() | |
over(partition by user_id order by view_date) as rank, | |