Spaces:
Sleeping
Sleeping
File size: 1,312 Bytes
13be287 da4b8fb e4456e8 13be287 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
import pandas as pd
class Processor:
def __init__(self):
self.df = None
self.total_impressions = 0
self.actual_impressions_percentage = 0
self.target_impressions_percentage = 0
self.distance_travelled = 0
self.target_travelled = 0
self.actual_travelled = 0
self.total_on_road = 0
self.high_traffic_percentage = 0
self.normal_traffic_percentage = 0
def load_data(self, file):
self.df = pd.read_excel(file)
impression_column = self.df.iloc[:, 4]
self.total_impressions = impression_column[impression_column.shift(-1).isna()].iloc[0]
c_column = self.df.iloc[:, 2]
c_column_empty_cells = c_column[c_column.isna()].index
self.actual_impressions_percentage = c_column[c_column_empty_cells[1]-1]
self.target_impressions_percentage = c_column[c_column_empty_cells[1]-2]
b_column = self.df.iloc[:, 1]
b_column_empty_cells = b_column[b_column.isna()].index
self.distance_travelled = b_column[b_column_empty_cells[3]-1]
self.target_travelled = b_column[b_column_empty_cells[3]-2]
self.actual_travelled = self.distance_travelled
self.total_on_road = c_column[c_column_empty_cells[0]-1]
def process(self):
pass |