TIL 45
- Creating a Python .gitignore from a template via a keyboard shortcut
- Creating indexed views in Azure SQL Database
- Fixing Azure SQL Database connection issues
- JSON serialization of nan values in Django REST Framework
- Using pandas' where() function
- pandas handling of integers and NaNs
- Updating virtual environment settings when folder names change
- Carrying out two-factor fixed effects regressions
- Installing Python packages from GitHub repositories
- Debugging Azure App Service issues
- Using Django
- Calculating p-values
- Using pipenv
- Doing imports in a Python project
- Fending off Pylance errors when using Jupyter magic commands in VSCode
- Using SQLAlchemy ORM
- Running SQL queries containing parameters in Python scripts
- Hiding pages in Streamlit navigation sidebars
- Connecting to a SQL Server database in Streamlit Community Cloud
- Adding hyperlinks to columns in AG Grid
- Naming Python constants and functions
- Using variables and secrets in GitHub Actions
- Installing Microsoft ODBC Driver 18 for SQL Server in GitHub Actions
- Setting .gitignore exceptions
- Using Python virtual environments
- Installing distutils in Python
- Treating Python warnings as errors
- Handling VSCode kernel crashes
- Using pandas' to_sql()
- Adding images to Markdown documents
- Connecting to Azure SQL Database in a Python script
- Installing Microsoft ODBC driver for SQL Server on GitHub Codespaces
- Using pre-commit
- Getting size of a table in Azure SQL Database
- Building a Jekyll site locally
- Identifying non-numeric values in a DataFrame column containing numerics
- Installing pyodbc on Python 3.13
- Syncing Azure Data Studio settings
- Configuring Git user email, username
- Uploading files to Azure Blob Storage
- Uploading files to Azure Blob Storage using AzCopy
- Running two commands in one Command Prompt window
- Deciding when to do data manipulation using Python, SQL
- Naming React components
- Installing node.js