Ishmam156

monthObject = {
  1: 'Jan', 
  2: 'Feb', 
  3: 'Mar',
  4: 'Apr',
  5: 'May',
  6: 'Jun',
  7: 'Jul',
  8: 'Aug',
  9: 'Sep',

Ishmam156

<div dir="ltr">
    <div class="gmail_default" style="font-family:georgia,serif">
        <div class="gmail_default">Hi everyone, </div>
        <div class="gmail_default">
            <br>
        </div>
        <div class="gmail_default">This is the daily unit economics report for Company Name for <?= data[0][1] ?>.</div>
        <div class="gmail_default">
            <br>
        </div>

Ishmam156

from openpyxl import load_workbook
import xlwings as xw

wb = load_workbook('deliveryData - raw.xlsx')
ws = wb['rawdata']
ws.title = 'raw'

column_headers = list(ws.rows)[0]
SALES_AGENTS = []
AGENTS_SUMMARY = {}

Ishmam156

const AUTHKEY = 'your_clickup_auth_token'
const LIST_ID = 'your_list_id_in_clickup'

const priority_matrix = {
  "Urgent" : 1,
  "High" : 2,
  "Normal" : 3,
  "Low" : 4,
}

Ishmam156

import openpyxl
import xlwings as xw

# Main variables for the transformation
starting_file_location = 'your_original_file.xlsx'
sheet_to_use = 'name_of_sheet_of_original_file'
formatted_file_location = 'new_file_name.xlsx'
column_to_use = 'G' # Column that will be used for creating new sheets
column_to_sort = 'E'
min_column = 'I'

Ishmam156

import config
from google.cloud import speech, texttospeech
import gradio as gr
import io
import openai
import os
from playsound import playsound

openai.api_key = config.OPENAI_API_KEY ## API Key from ChatGPT stored in a config.py file in same directory
os.environ["GOOGLE_APPLICATION_CREDENTIALS"] = "./cloud_creds.json" ## Path to service account credentials JSON from Google Cloud Platform

Ishmam156

import requests
from bs4 import BeautifulSoup
import pandas as pd

url = 'http://localhost:3000/branch' # replace this with the URL that you want to scrape
response = requests.get(url)

soup = BeautifulSoup(response.text, 'html.parser')

# Replace below class name if you have a class identifier. 

Ishmam156

# Install the required packages as below
# On Windows: pip install selenium webdriver_manager pandas
# On Mac: pip3 install selenium webdriver_manager pandas
import datetime
import pandas as pd
import time
from selenium import webdriver
from selenium.webdriver.common.by import By
from webdriver_manager.chrome import ChromeDriverManager