def __init__(self):
crm_data_path = os.path.join(DATASET_DIR, "crm.xlsx")
crm_data_reader = CRMData(crm_data_path)
crm_df = crm_data_reader.get_all_data()
merchant_data_path = os.path.join(DATASET_DIR, "MerchantSumAmountPerDay.txt")
merchant_data_reader = MerchantData(merchant_data_path)
merchant_df = merchant_data_reader.all_processed_dataframe()
self.data_reader = CRMMerchant(crm_df, merchant_df)
def __init__(self, merchant_data_df):
if merchant_data_df is None:
merchant_data_path = os.path.join(
DATASET_DIR, "Merchants-PerDay-GRTOneThousand.txt")
merchant_data_reader = MerchantData(merchant_data_path)
self._merchant_data_df = merchant_data_reader.all_processed_dataframe(
)
self._merchant_data_df = merchant_data_df.set_index(
"merchant_number")
print(self._merchant_data_df)
else:
self._merchant_data_df = merchant_data_df
#print(self._merchant_data_df)
crm_data_path = os.path.join(DATASET_DIR, "CRM-Senf-Merchant.xlsx")
self.crm_data_reader = CRMData(crm_data_path)
self._crm_df = self.crm_data_reader.get_all_data()
print(self._crm_df)
self._crm_merchant_df = CRMMerchant(self._crm_df,
self._merchant_data_df)
import matplotlib.pyplot as plt from mpl_toolkits.mplot3d import Axes3D from sklearn import preprocessing from readdata.crmmerchant import CRMMerchant from readdata.merchantdata import MerchantData from readdata.crmdata import CRMData from visualization import plotlyvisualize import os DATASET_DIR = "dataset" PLOT_OUT_DIR = "plotsout" # Data Read merchant_data_path = os.path.join(DATASET_DIR, "MerchantSumAmountPerDay.txt") merchant_data_reader = MerchantData(merchant_data_path) merchant_df = merchant_data_reader.all_processed_dataframe() crm_data_path = os.path.join(DATASET_DIR, "crm.xlsx") crm_data_reader = CRMData(crm_data_path) crm_df = crm_data_reader.get_all_data() crm_merchant_df = CRMMerchant(crm_df, merchant_df) # harmonic_amount = crm_merchant_df[["harmonic"]].as_matrix().astype(np.float) # no_transaction = crm_merchant_df[["all_transactions"]].as_matrix().astype(np.float) # sum_amounts = crm_merchant_df[["sum_amounts"]].as_matrix().astype(np.float) # senf_code = crm_merchant_df["senf_code"].tolist() # plotlyvisualize.histogram(senf_code) mm = crm_data_reader.get_guild_series() guild_all_amounts = crm_merchant_df.get_guild_all_amounts()