Sven-Bo

import json

import requests  # pip install requests
import streamlit as st  # pip install streamlit
from streamlit_lottie import st_lottie  # pip install streamlit-lottie

# GitHub: https://github.com/andfanilo/streamlit-lottie
# Lottie Files: https://lottiefiles.com/

def load_lottiefile(filepath: str):

Sven-Bo

import pandas_datareader as pdr  # pip install pandas-datareader
import pandas as pd

start = "2020-01-01"
end = "2020-07-31"

# List of FRED codes for economic indicators
economic_indicators = {
    "GDP": "GDP",
    "Unemployment Rate": "UNRATE",

Sven-Bo

# Author: Sven Bosau
# YouTube: https://youtube.com/@codingisfun
# This script is a modified version of the original code from the following video:
# https://github.com/Sven-Bo/word-entry-form/blob/master/2.Step%20-%20Create%20GUI/Vendor_Contract_Example/vendor-contract-gui.py
# The modification allows the user to save generated documents in a specified folder.

import datetime
from pathlib import Path

import PySimpleGUI as sg

Sven-Bo

"""
This script is based on the original code from the YouTube tutorial:
- https://youtu.be/svcv8uub0D0

The initial code can be found on GitHub at:
- https://github.com/Sven-Bo/data-entry-form-pysimplegui

Modifications made to the original code:
- Added a "Delete Last Row" button to remove the last row from the Excel file.

Sven-Bo

"""
This code is a modification of the initial code from the video tutorial:
"How to Create an Excel Data Entry Form in 10 Minutes Using Python (No VBA) | Easy & Simple"
Video link: https://youtu.be/svcv8uub0D0

Modifications:
- Added a scrollbar to the main window layout using sg.Column and sg.VerticalScroll.
"""

from pathlib import Path

Sven-Bo

"""
This code is a modification of the initial code from the video tutorial:
"How to Create an Excel Data Entry Form in 10 Minutes Using Python (No VBA) | Easy & Simple"
Video link: https://youtu.be/svcv8uub0D0
Modifications:
- Added a timestamp next to the entry in the Excel file
"""

from pathlib import Path
import PySimpleGUI as sg

Sven-Bo

"""
Title: Case-Insensitive Text Replacement in Excel Files

Author: Sven Bosau
Website: https://pythonandvba.com
YouTube Channel: https://Youtube.com/@codingisfun

This script leverages the openpyxl library to perform case-insensitive replacement of text in Excel files (.xlsx, .xls). 
It traverses each cell in each worksheet of an Excel file, compares the lowercase content of the cell to the keys 
of a predefined dictionary, and if a match is found, replaces the cell's content with the corresponding value. 

Sven-Bo

# This code was provided by Sven Bosau
# Website: https://pythonandvba.com
# YouTube: https://youtube.com/@codingisfun

import xlwings as xw
import pandas as pd

# Constants
WORKBOOK_PATH = 'workbook.xlsx'
SHEET_NAME = 'Sheet1'

Sven-Bo

from pathlib import Path
import PySimpleGUI as sg
import pandas as pd
from openpyxl import load_workbook

# Add some color to the window
sg.theme('DarkTeal9')

current_dir = Path(__file__).parent if '__file__' in locals() else Path.cwd()
EXCEL_FILE = current_dir / 'Data_Entry.xlsx'

Sven-Bo

#EXTM3U
#EXTINF:-1,BBC - Radio 1
http://as-hls-ww-live.akamaized.net/pool_904/live/ww/bbc_radio_one/bbc_radio_one.isml/bbc_radio_one-audio%3d96000.norewind.m3u8
#EXTINF:-1,BBC - Radio 1Xtra
http://as-hls-ww-live.akamaized.net/pool_904/live/ww/bbc_1xtra/bbc_1xtra.isml/bbc_1xtra-audio%3d96000.norewind.m3u8
#EXTINF:-1,BBC - Radio 1Dance
http://as-hls-ww-live.akamaized.net/pool_904/live/ww/bbc_radio_one_dance/bbc_radio_one_dance.isml/bbc_radio_one_dance-audio%3d96000.norewind.m3u8
#EXTINF:-1,BBC - Radio 1Relax
http://as-hls-ww-live.akamaized.net/pool_904/live/ww/bbc_radio_one_relax/bbc_radio_one_relax.isml/bbc_radio_one_relax-audio%3d96000.norewind.m3u8
#EXTINF:-1,BBC - Radio 2