import pandas as pd
from datetime import datetime

date_format = "%d/%m/%Y"



df = pd.read_excel('Data/cleaned_data_2.xlsx')


def total_hits(area_name, date1 , date2):

    t1 = datetime.strptime(date1, date_format)
    t2 = datetime.strptime(date2, date_format)

    i=0
    count=0

    while (df.iloc[i][0] != area_name):
        if (i <= 142417):
            i = i + 1
        else:
            return 0

    while (df.iloc[i][0] == area_name):
        if (df.iloc[i][2] > t1 and df.iloc[i][2] < t2):
            count=count+1

        if (i <= 142417):
            i = i + 1
        else:
            return count

    return count



print(total_hits( "A Narayanapura", "27/2/2018" , "2/4/2018"))
4c6bb5e825767c9242e4dac4cd9a4c423be8d0d1
<mask token>


def total_hits(area_name, date1, date2):
    t1 = datetime.strptime(date1, date_format)
    t2 = datetime.strptime(date2, date_format)
    i = 0
    count = 0
    while df.iloc[i][0] != area_name:
        if i <= 142417:
            i = i + 1
        else:
            return 0
    while df.iloc[i][0] == area_name:
        if df.iloc[i][2] > t1 and df.iloc[i][2] < t2:
            count = count + 1
        if i <= 142417:
            i = i + 1
        else:
            return count
    return count


<mask token>

<mask token>


def total_hits(area_name, date1, date2):
    t1 = datetime.strptime(date1, date_format)
    t2 = datetime.strptime(date2, date_format)
    i = 0
    count = 0
    while df.iloc[i][0] != area_name:
        if i <= 142417:
            i = i + 1
        else:
            return 0
    while df.iloc[i][0] == area_name:
        if df.iloc[i][2] > t1 and df.iloc[i][2] < t2:
            count = count + 1
        if i <= 142417:
            i = i + 1
        else:
            return count
    return count


print(total_hits('A Narayanapura', '27/2/2018', '2/4/2018'))

<mask token>
date_format = '%d/%m/%Y'
df = pd.read_excel('Data/cleaned_data_2.xlsx')


def total_hits(area_name, date1, date2):
    t1 = datetime.strptime(date1, date_format)
    t2 = datetime.strptime(date2, date_format)
    i = 0
    count = 0
    while df.iloc[i][0] != area_name:
        if i <= 142417:
            i = i + 1
        else:
            return 0
    while df.iloc[i][0] == area_name:
        if df.iloc[i][2] > t1 and df.iloc[i][2] < t2:
            count = count + 1
        if i <= 142417:
            i = i + 1
        else:
            return count
    return count


print(total_hits('A Narayanapura', '27/2/2018', '2/4/2018'))

import pandas as pd
from datetime import datetime
date_format = '%d/%m/%Y'
df = pd.read_excel('Data/cleaned_data_2.xlsx')


def total_hits(area_name, date1, date2):
    t1 = datetime.strptime(date1, date_format)
    t2 = datetime.strptime(date2, date_format)
    i = 0
    count = 0
    while df.iloc[i][0] != area_name:
        if i <= 142417:
            i = i + 1
        else:
            return 0
    while df.iloc[i][0] == area_name:
        if df.iloc[i][2] > t1 and df.iloc[i][2] < t2:
            count = count + 1
        if i <= 142417:
            i = i + 1
        else:
            return count
    return count


print(total_hits('A Narayanapura', '27/2/2018', '2/4/2018'))

import pandas as pd
from datetime import datetime

date_format = "%d/%m/%Y"



df = pd.read_excel('Data/cleaned_data_2.xlsx')


def total_hits(area_name, date1 , date2):

    t1 = datetime.strptime(date1, date_format)
    t2 = datetime.strptime(date2, date_format)

    i=0
    count=0

    while (df.iloc[i][0] != area_name):
        if (i <= 142417):
            i = i + 1
        else:
            return 0

    while (df.iloc[i][0] == area_name):
        if (df.iloc[i][2] > t1 and df.iloc[i][2] < t2):
            count=count+1

        if (i <= 142417):
            i = i + 1
        else:
            return count

    return count



print(total_hits( "A Narayanapura", "27/2/2018" , "2/4/2018"))