<jupyter_start><jupyter_text>Welcome to Marketing Reportauthor: <NAME> last edit: 13/10/19 purpose: this report is use to show the advertising spending and pricing info in intopia<jupyter_code>import pandas as pd
import os
from intopia_analysis import *
path = r'%s' % os.getcwd().replace('\\','/')

df_contact = pd.read_csv('Intopia - Contact List - Sheet1.csv')
df_price = get_live_price_data(path,'phase2/period3/') #<---- ademend path between library 
df_ad = get_advertising_data(path,'phase2/period4/') #<---- ademend path between library<jupyter_output><empty_output><jupyter_text>Team Tracking<jupyter_code>team_tracker(df_contact, 17) #<-- admend the team you want information regarding<jupyter_output><empty_output><jupyter_text>Marketing Expense Tracking  Central Canada Marketing Expese<jupyter_code>df_ad[df_ad['region'] == 'cc'].sort_values(by='Total', ascending=False)<jupyter_output><empty_output><jupyter_text>Western Canada Marketing Expese<jupyter_code>df_ad[df_ad['region'] == 'wc'].sort_values(by=['type','Total'], ascending=False)<jupyter_output><empty_output><jupyter_text>Pricing Information<jupyter_code>print('Central Canada Price')
df_price[df_price['region'] == 'cc'].sort_values(by='Standard Price Cannabis', ascending=False)
print('Western Canada Price')
df_price[df_price['region'] == 'wc'].sort_values(by='Standard Price Cannabis', ascending=False)
print('Eastern Canada Price')
df_price[df_price['region'] == 'ec'].sort_values(by='Standard Price Cannabis', ascending=False)<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.14322916666666666, 'fraction_numerical': 0.008463541666666666, 'mean_word_length': 9.527397260273972, 'pattern_counts': {'":': 0, '<': 25, '<?xml version=': 0, '>': 22, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '5', 'dir': 'jupyter-structured-clean-dedup', 'id': '489017', 'license': 'MIT', 'n_tokens_mistral': 535, 'n_tokens_neox': 508, 'n_words': 97, 'path': '.ipynb_checkpoints/marketing_report-checkpoint.ipynb', 'repo_name': 'jacklau0497/jack_low_key_project', 'size': '1538'}