gitcheckoutnikhil

# 10_basic.py
# 15_make_soup.py
# 20_search.py
# 25_navigation.py
# 30_edit.py
# 40_encoding.py
# 50_parse_only_part.py

gitcheckoutnikhil

import urllib3
http = urllib3.PoolManager()
r = http.request('GET', 'http://httpbin.org/robots.txt')
# Get status
r.status
# Get data
r.data

gitcheckoutnikhil

Keybase proof

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:

gitcheckoutnikhil

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'

gitcheckoutnikhil

--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,