Using Python and Streamlit with MS SQL

Table of Contents Create and activate the Python environment Install Python modules Install MS SQL Start coding & Run Prerequisites For this project, we used MS SQL, so the operating system is Windows Server 2012. I installed MS SQL Server 2012 Advanced. If your system is Windows 10 or Windows 11, install the latest version of MS SQL Express instead. Python 3.12 Windows OS MS SQL Express Internet Get started Create and activate the Python environment # Create the virtual environment python -m venv c:\project\event # Activate it cd c:\project\event\Scripts .\activate # Deactivate it when finished deactivateInstall Python modules You can install these modules step by step, or use pip install -r requirement.txt. ...

Install Jupyter notebook on Ubuntu 24.04 and allow remote access.

References: Vultr How to Install Jupyter Notebook on Ubuntu 24.04 https://docs.vultr.com/how-to-install-jupyter-notebook-on-ubuntu-24-04 Prerequisites Ubuntu 24.04 Internet access Install Jupyter Notebook with pip Update the APT package index: sudo apt update Install the virtualenv package: sudo apt install python3-virtualenv -y Create a virtual environment: virtualenv jupyter_env Activate the virtual environment: source jupyter_env/bin/activate Install Jupyter Notebook: pip install jupyter Verify the installed version: jupyter-notebook --version You can deactivate the virtual environment at any time by running deactivate. ...

Deep Live cam Notes

Deep Live cam Notes Project address: https://github.com/hacksider/Deep-Live-Cam This note will not cover cuda, Python, Conda, Git, and other related computer knowledge. There are only records of steps and problems encountered when using the deployment. The following operations are all performed under the Windows operating system. My system version number is: Microsoft Windows 11 Pro 10.0.22631 Build 22631 Prerequisites Desktop or laptop computer with Nvidia graphics card Stable network environment Software or compilation tools required by DeepLiveCam ...

Python batch query express delivery number and fill the query results into Excel

Reason Because November is a time when the express delivery volume is relatively large, there will be a lot of express delivery orders that need to be checked for delivery status; before, because the order volume was small, each order would go to Baidu to directly see the results of Baidu’s query. Since there have been so many express delivery orders in the past two months, I plan to use Python combined with Express 100’s API to check the delivery status. ...

Coding Practice. Use an IP Guide retrieve your ip information

Intuduction When we need to check some IP address information , do we have to open the browser, then type the googl domain and copy-paste the IP address? In this article . I’m goinG to use python with IP GUIDE to check ipaddres information .This much better before. Let’s started Install Python found what version can be match your OS , download it and installl . https://www.python.org/downloads/ Install requests library website: https://pypi.org/project/requests/ $ python -m pip install requests Code #import requests library import requests #get data from ip guide response = requests.get(f'https://ip.guide/').json() #function get_ip def get_ip(): return response["ip"] #function get_location def get_location(): location_data = { "Latitude":response["location"]["latitude"], "Longitude" : response["location"]["longitude"], "City": response["location"]["city"], "Country": response["location"]["country"] } return location_data #function get_network def get_network(): network_data = { "Cidr": response["network"]["cidr"], "Host Start" : response["network"]["hosts"]["start"], "Host end" : response["network"]["hosts"]["end"] } return network_data #dictionary variable network_data = get_network() location_data = get_location() ipaddress = get_ip() # output information print(f"Your internet IPaddress is :{ipaddress}\n and below is this IPaddress other informations\n") # for loop for key,value in network_data.items(): print(f"{key}: {value}") print(" \n") for key,value in location_data.items(): print(f"{key}: {value}") print(" \n")Refrence https://ip.guide/ ...

Using Python with the OpenWeather.org AP

Using Python with the OpenWeathermap.org API In these notes, we will explore how to utilize Python with a free weather API (Application Programming Interface) to retrieve the current weather for a specific city. What You Need to Install and Obtain Python and the ‘requests’ package Access to a Weather API Basic coding knowledge Install requests package $ python -m pip install requests #install package $ python -m pip show requests #display requests version ...

搜尋文章

輸入標題、分類或文章內容

Plz typing to search for articles.