def __SetDataFrames(self, data_wrapper):
name, extension = pathfinder.SplitFileNameIntoNameAndExtension(
data_settings.invoices_file)
self.invoices = copy.deepcopy(data_wrapper.data_frames[name])
name, extension = pathfinder.SplitFileNameIntoNameAndExtension(
data_settings.customers_file)
self.customers = copy.deepcopy(data_wrapper.data_frames[name])
def __SetDataFrames(self, data_wrapper):
name, extension = pathfinder.SplitFileNameIntoNameAndExtension(
data_settings.URA_EU_DC_file)
self.URA_EU_DC = copy.deepcopy(data_wrapper.data_frames[name])
name, extension = pathfinder.SplitFileNameIntoNameAndExtension(
data_settings.vendors_file)
self.vendors = copy.deepcopy(data_wrapper.data_frames[name])
def __SetDataFrames(self, data_wrapper):
name, extension = pathfinder.SplitFileNameIntoNameAndExtension(
data_settings.IRA_EU_file)
self.IRA_EU = copy.deepcopy(data_wrapper.data_frames[name])
self.IRA_EU = self.IRA_EU[
(self.IRA_EU[data_settings.IRA_EU_goods_sold] != 0.0) |
(self.IRA_EU[data_settings.IRA_EU_services_sold] != 0.0)]
name, extension = pathfinder.SplitFileNameIntoNameAndExtension(
data_settings.customers_file)
self.customers = copy.deepcopy(data_wrapper.data_frames[name])
def LoadDataFrame(file_name):
name, extension = pathfinder.SplitFileNameIntoNameAndExtension(file_name)
if extension == "xlsx":
data_frame = LoadXLSXIntoDataFrame(file_name)
else:
raise Exception("Unknown extension!")
return data_frame
def __SortData(self):
invoices_file = data_settings.invoices_file
name, extension = pathfinder.SplitFileNameIntoNameAndExtension(
invoices_file)
if name in self.data_frames.keys():
self.data_frames[name] = self.data_frames[name].sort_values(
by=[data_settings.invoices_customer_name])
URA_EU_DC_file = data_settings.URA_EU_DC_file
name, extension = pathfinder.SplitFileNameIntoNameAndExtension(
URA_EU_DC_file)
if name in self.data_frames.keys():
self.data_frames[name] = self.data_frames[name].sort_values(
by=[data_settings.URA_EU_DC_vendor_id])
IRA_EU_file = data_settings.IRA_EU_file
name, extension = pathfinder.SplitFileNameIntoNameAndExtension(
IRA_EU_file)
if name in self.data_frames.keys():
self.data_frames[name] = self.data_frames[name].sort_values(
by=[data_settings.IRA_EU_customer_id])
def __FilterData(self):
customers_file = data_settings.customers_file
name, extension = pathfinder.SplitFileNameIntoNameAndExtension(
customers_file)
if name in self.data_frames.keys():
self.data_frames[name] = filter_data.FilterCustomers(
self.data_frames[name])
invoices_file = data_settings.invoices_file
name, extension = pathfinder.SplitFileNameIntoNameAndExtension(
invoices_file)
if name in self.data_frames.keys():
self.data_frames[name] = filter_data.FilterInvoices(
self.data_frames[name])
IRA_EU_file = data_settings.IRA_EU_file
name, extension = pathfinder.SplitFileNameIntoNameAndExtension(
IRA_EU_file)
if name in self.data_frames.keys():
self.data_frames[name] = filter_data.FilterIRA_EU(
self.data_frames[name])
URA_EU_DC_file = data_settings.URA_EU_DC_file
name, extension = pathfinder.SplitFileNameIntoNameAndExtension(
URA_EU_DC_file)
if name in self.data_frames.keys():
self.data_frames[name] = filter_data.FilterNullRows(
self.data_frames[name])
URA_EU_DOM_file = data_settings.URA_EU_DOM_file
name, extension = pathfinder.SplitFileNameIntoNameAndExtension(
URA_EU_DOM_file)
if name in self.data_frames.keys():
self.data_frames[name] = filter_data.FilterNullRows(
self.data_frames[name])
URA_EU_UVOZ_file = data_settings.URA_EU_UVOZ_file
name, extension = pathfinder.SplitFileNameIntoNameAndExtension(
URA_EU_UVOZ_file)
if name in self.data_frames.keys():
self.data_frames[name] = filter_data.FilterNullRows(
self.data_frames[name])
vendors_file = data_settings.vendors_file
name, extension = pathfinder.SplitFileNameIntoNameAndExtension(
vendors_file)
if name in self.data_frames.keys():
self.data_frames[name] = filter_data.FilterVendors(
self.data_frames[name])
def __LoadFiles(self, file_names):
for file_name in file_names:
name, extension = pathfinder.SplitFileNameIntoNameAndExtension(
file_name)
self.data_frames[name] = load_data.LoadDataFrame(file_name)