Ishmam156’s gists

Ishmam156 / scape.py

Created May 5, 2023 14:38

Simple script that uses selenium to replicate browser behavior to save data in an excel format

	# 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

Ishmam156 / scrape.py

Created April 7, 2023 09:56

Simple python script that demonstrates web scraping

	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 / banglaspeakChatGPT.py

Last active March 16, 2023 06:33

Python script based on gradio library to create a quick website showcasing the ability to use audio to interact with ChatGPT

	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 / format_excel.py

Created March 3, 2023 13:49

Python script to format an excel file according to your needs

	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 / Google Form to Clickup Issue - Automation.js

Last active February 19, 2023 14:36

Short appscript code to help automate creation of issues in Clickup when a user is submitting a Google Form.

	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 / automateAgentSegregation.py

Last active November 1, 2022 16:54

Python script to filter out raw data in a summary as well as singular agent wise view

	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 / gist:fc6c7f4151a8098f284120bb496d8954

Created July 1, 2022 09:44

HTML Template for auto generated email from spreadsheet

	<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 / gist:c63dafddb6053d3483a6454c0b1a17c2

Created July 1, 2022 09:44

JavaScript Code to send email from spreadsheet

Ishmam Chowdhury Ishmam156