Skip to content

Instantly share code, notes, and snippets.

@lundeen-bryan
lundeen-bryan / group_name.txt
Last active July 6, 2023 19:08
formula for list
=IF(OR(LEFT(patient_name, 1)="A", LEFT(patient_name, 1)="B", LEFT(patient_name, 1)="C"), "ABC",
IF(OR(LEFT(patient_name, 1)="D", LEFT(patient_name, 1)="E", LEFT(patient_name, 1)="F"), "DEF",
IF(OR(LEFT(patient_name, 1)="G", LEFT(patient_name, 1)="H", LEFT(patient_name, 1)="I"), "GHI",
IF(OR(LEFT(patient_name, 1)="J", LEFT(patient_name, 1)="K", LEFT(patient_name, 1)="L"), "JKL",
IF(OR(LEFT(patient_name, 1)="M", LEFT(patient_name, 1)="N"), "MN",
IF(OR(LEFT(patient_name, 1)="O", LEFT(patient_name, 1)="P", LEFT(patient_name, 1)="Q"), "OPQ",
IF(OR(LEFT(patient_name, 1)="R", LEFT(patient_name, 1)="S"), "RS",
IF(OR(LEFT(patient_name, 1)="T", LEFT(patient_name, 1)="U", LEFT(patient_name, 1)="V"), "TUV",
IF(OR(LEFT(patient_name, 1)="W", LEFT(patient_name, 1)="X", LEFT(patient_name, 1)="Y", LEFT(patient_name, 1)="Z"), "WXYZ"
)
@lundeen-bryan
lundeen-bryan / README.md
Created May 26, 2023 16:05
readme template

Read Me Template

Project Image

This is a ReadMe template to help save you time and effort.


Link To Project

See the Project Name on Linkify.

@lundeen-bryan
lundeen-bryan / gptchats.md
Last active March 17, 2023 13:30
archive of gpt chats

GPT Chats

These are all chats with GPT just the link is provided

2023-03-17

RE: several programming principles like SOLID, KISS, etc

https://higpt.wiki/jPfFHed

@lundeen-bryan
lundeen-bryan / Excel_Formatting.ipynb
Created February 4, 2023 19:01 — forked from pybokeh/Excel_Formatting.ipynb
Excel Formatting in xlwings
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@lundeen-bryan
lundeen-bryan / xlwings_test.ipynb
Last active January 22, 2023 17:20
just a test for sql in jupyter nb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@lundeen-bryan
lundeen-bryan / bar_chart_exercise.ipynb
Last active January 22, 2023 18:25
bar_chart_exercise.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@lundeen-bryan
lundeen-bryan / .bash_aliases
Last active September 15, 2023 13:24
bash_backups
# list files per line
alias lf="ls -1ASk"
# quit bash like in vim
alias :q="exit"
# clear the screen
alias clr="clear"
# run ipython with vi
alias ipy="ipython --TerminalInteractiveShell.editing_mode='vi'"
# show grep history
alias gh="history|grep"
@lundeen-bryan
lundeen-bryan / file_control.py
Created November 3, 2022 02:08
file read write util
import os
from os import path, sys
def read_file(file_name):
file_name = os.path.join(sys.path[0], file_name)
if path.isfile(file_name):
with open(file_name, mode="r") as file:
contents = file.readlines()
return contents
else:
@lundeen-bryan
lundeen-bryan / _clear_console.py
Last active March 31, 2023 02:15
python snippets
import os
#from os import system
#HINT: You can call clear() to clear the output in the console.
def clear():
os.system("clear")
# test code to put something on the screen: print("A bunch of stuff")
""" test code to call the function
clear_now = input("Do you want to clear the output? (y/n): ")
if clear_now == "y":
@lundeen-bryan
lundeen-bryan / udemy.css
Last active June 27, 2023 19:35
browser_css
/* use for udemy notifications */
.activity-notifications-module--notification-list--3I_hF {
width:1200px
}
.activity-notification-module--notification-info--3Yr2y {
height: 170px;
}
/* create CRLF after title then, normal font for the body text */
span[data-purpose="safely-set-inner-html:activity-notification:notification-template"] span.subject::before {
content: "\A";