Brian Dunnette bdunnette

Reading MS Access data in Pandas

Download and install 32-bit Python 3.9 (this is the latest version that works with Access drivers) https://www.python.org/ftp/python/3.9.13/python-3.9.13.exe
Create a virtualenv: mkvirtualenv -p 3.9 pandas-32bit
Install pandas 2.0.3 (the last with 32-bit wheels) and pyodbc: pip install pandas==2.0.3 pyodbc sqlalchemy
List drivers: import pyodbc; pyodbc.drivers() - the usual driver will be Microsoft Access Driver (*.mdb, *.accdb)
Connect using sqlalchemy:

DRIVER = "Microsoft Access Driver (*.mdb, *.accdb)"

Enter the virtualenv and run Django shell:

cd /srv/funkwhale/
source virtualenv/bin/activate
./manage shell

Import Funkwhale models:

	export WORKON_HOME=$HOME/.virtualenvs
	export PROJECT_HOME=$HOME/GitHub
	export VIRTUALENVWRAPPER_SCRIPT=/usr/share/virtualenvwrapper/virtualenvwrapper.sh
	source /usr/share/virtualenvwrapper/virtualenvwrapper_lazy.sh

	SENDGRID_API_KEY=Paste key from https://app.sendgrid.com/settings/api_keys here
	[email protected]
	RECIPIENTS=${SENDER},[email protected]
	NWS_STATION=KMIC
	MIN_PRECIP=25

	from datetime import datetime
	import logging
	import requests

	logger = logging.getLogger(__name__)
	logging.basicConfig(level=logging.INFO, format="%(asctime)s %(message)s")

	# Start Configuration
	NWS_STATION = "KMIC"
	MIN_PRECIP = 10

	version: "3"

	services:
	dremio:
	image: dremio/dremio-oss:latest
	container_name: dremio-oss
	ports:
	- "9047:9047"
	- "31010:31010"
	- "45678:45678"

	# One-liner to fix "no unqualified-search registries are defined" errors in Podman
	mkdir -p ~/.config/containers && echo unqualified-search-registries = [\"docker.io\"] >> ~/.config/containers/registries.conf