Category: Python
Load a broken csv file into duckdb
Some CSV files have issues with them. Below is a code snippet to save the information in a csv file into a duckdb database, ignoring all the ‘broken’ rows.
Pandas for data analysis – Video mega guide
Pandas is the go to library in Python for analysing and manipulating data. This post lists some useful video resources for learning this package. Brandon Rhodes – Pandas From The …
Execute queries in BigQuery in parallel using python
An example of how to run multiple queries in parallel.
Simple logging to SQLite database from python
A lightweight example of saving some logs to an SQLite database in a python script.
Adding user login to Streamlit apps
A short guide to adding user authentication to Streamlit apps. So you’ve created a beautiful Streamlit app which your users love, but only certain people should be able to access …
Adding web analytics tracking to Streamlit apps
Having gone through all the effort of creating a Streamlit application, you want to know if the people you have shared the application with are actually using it or not. …
Getting started with Streamlit
Video Tutorials 30 days of Streamlit Build a different Streamlit app each day for 30 days https://blog.streamlit.io/30-days-of-streamlit/ Streamlit documentation Offical Streamlit documentation. Very user friendly and accessible reference materials. https://docs.streamlit.io/library/get-started …
How to host a Streamlit app on Google Cloud Run
A short guide for deploying a Streamlit app to Cloud Run on Google Cloud platform. Google Cloud Run is a managed platform for hosting and running docker containers. So once …
Introduction to Google Colab
Colab is a free Jupyter notebook environment that runs entirely in the cloud. Most importantly, it does not require a setup and the notebooks that you create can be simultaneously …