-
Notifications
You must be signed in to change notification settings - Fork 0
/
emp_night.py
69 lines (56 loc) · 3.14 KB
/
emp_night.py
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
#! /usr/bin/env python3
import pandas as pd
import os, datetime, re
# config file path append to call config.py
# sys.path.append(os.path.abspath('/media/sf_shared/my_program/scripts/Finance_Umami'))
# sys.path.append(os.path.abspath('/home/sung/Umami/scripts/Finance_Umami'))
from config import *
# To use this func, df should have datetime convertible index
# Use this function on df with datetime convertible index. Should be all numbers to use this program
def dfWithDateIndexNoDollar(df):
df.index = pd.to_datetime(df.index)
df = df.replace( '[\$,)]', '', regex=True ). \
replace( '[(]', '-', regex=True)
df = df.apply(pd.to_numeric, downcast='float', errors='ignore')
return df
locs = ['Dimond', 'Uptown']
for n, loc in enumerate(locs):
square_night_file = period + 'N_' + locs[n] + '.csv'
doordash_night_file = period + '_Doordash_' + locs[n] + '_Night.csv'
uber_night_file = period + '_Uber_' + locs[n] + '_Night.csv'
night_worker_file = period + '_manual_input.xlsx'
folder = os.path.join(path_shared, period)
try:
dfsq = pd.read_csv(folder+'/meta/square/'+square_night_file, index_col=[0], header=[0]).T
dfcv = pd.read_csv(folder+'/report/'+doordash_night_file, index_col=[0], header=[0])
dfub = pd.read_csv(folder+'/report/'+uber_night_file, index_col=[0], header=[0])
dfnw = pd.read_excel(folder+'/report/'+ night_worker_file, sheet_name='Cash_Payment', index_col=0, header=0)
dfnw = dfnw.dropna(how='all')
dfnw['initials worked at_Dimond_Night'] = dfnw['initials worked at_Dimond_Night'].str.upper()
dfnw.index = pd.to_datetime(dfnw.index).date
except FileNotFoundError as e:
print(f'File related to {locs[n]} not present. \n\
Processing has been sucessfully done upto {locs[n-1]} data')
continue
dfsq = dfWithDateIndexNoDollar(dfsq).drop(columns= ['Returns', 'Discounts & Comps', \
'Net Sales', 'Gift Card Sales', 'Refunds by Amount', \
'Payments', 'Total Collected', 'Fees', 'Net Total', 'Tax', 'Total'])
dfcv = dfWithDateIndexNoDollar(dfcv).drop(columns=['Tax', 'Fee', 'Umami portion'])
dfub = dfWithDateIndexNoDollar(dfub).drop(columns=['Tax', 'Fee', 'Umami portion'])
dfnw = dfnw[['initials worked at_Dimond_Night']]
# Make a copy of umami df
globals()[locs[n] + '_cu'] = dfsq.dropna(how='all', axis=1)
deliveries = [dfcv, dfub]
for df in deliveries:
# df.reset_index(inplace=True)
# df = df.groupby([pd.Grouper(key='Pickup time', freq='d'), 'day', 'Location'])['Price'].sum()
# dfcv = dfcv.reset_index().set_index('Pickup time')
df = df.resample('d').sum() # 1 day transaction summed
globals()[locs[n] + '_cu'] = pd.concat([globals()[locs[n] + '_cu'], df], axis=1).fillna(0.0)
globals()[locs[n] + '_cu']['Day'] = globals()[locs[n] + '_cu'].index.day_name()
globals()[locs[n] + '_cu'] = pd.concat([globals()[locs[n] + '_cu'], dfnw], axis=1)
globals()[locs[n] + '_cu'].columns = ['Gross Sales', 'Tip', 'doordash', 'uber', 'Day', 'Name'] # 'caviar'
# globals()[locs[n] + '_cu']['Name'] = "" # Make Empty columns for input later
filename = os.path.join(path_shared, period, report, period +'_'+ locs[n] + '_Night' + '.csv')
with open(filename, 'w') as f:
globals()[locs[n]+'_cu'].to_csv(f, header=True)