<jupyter_start><jupyter_text>EPOS S&Op Planner Some description  1. Begin S&Op Planning Session<jupyter_code># we begin by creating the authentication to sharepoint
from shareplum import Site
from shareplum import Office365
from shareplum.site import Version
import requests
import getpass

username1=getpass.getuser()+"<EMAIL>"
username2=getpass.getuser()+"@<EMAIL>.<EMAIL>"
password=get<PASSWORD>pass(prompt='Password: ', stream=None)

try:
    authcookie = Office365('https://demant.sharepoint.com', username=username1, password=password).GetCookies()
except:
    authcookie = Office365('https://demant.sharepoint.com', username=username2, password=password).GetCookies()
import pandas as pd

# we now get the data from the sharepoint forecast site
site = Site('https://demant.sharepoint.com/sites/ProjectForecasts/', version=Version.v2016, authcookie=authcookie)
folder = site.Folder('Shared Documents/MP Forecasts')

resp = folder.get_file('Production Forecast.xlsx')

df_mpFC = pd.read_excel(resp, header = 3)

df_mpFC
%load_ext watermark

%watermark -v -m -p requests,getpass,pandas

print(" ")
%watermark -u -n -t -z<jupyter_output>Python implementation: CPython
Python version       : 3.7.6
IPython version      : 7.12.0

requests: 2.22.0
getpass : unknown
pandas  : 1.0.1

Compiler    : MSC v.1916 64 bit (AMD64)
OS          : Windows
Release     : 10
Machine     : AMD64
Processor   : Intel64 Family 6 Model 94 Stepping 3, GenuineIntel
CPU cores   : 8
Architecture: 64bit

 
Last updated: Fri Jul 23 2021 12:32:53GMT Daylight Time
{'fraction_non_alphanumeric': 0.10707332900713822, 'fraction_numerical': 0.04282933160285529, 'mean_word_length': 4.885496183206107, 'pattern_counts': {'":': 0, '<': 8, '<?xml version=': 0, '>': 8, 'https://': 3, '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': '1', 'dir': 'jupyter-structured-clean-dedup', 'id': '631128', 'license': 'MIT', 'n_tokens_mistral': 565, 'n_tokens_neox': 506, 'n_words': 140, 'path': 'EPOS S&Op Planner.ipynb', 'repo_name': 'TummasM/EPOS_S-Op_Planning', 'size': '1542'}