thomas thomascamminady
thomascamminady
/ run_query_against_redshift.py
Created
February 11, 2025 11:59
Run Metabase queries in the command line
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # /// script | |
| # dependencies = [ | |
| # "fire", | |
| # "polars", | |
| # "rich", | |
| # "redshift_connector", | |
| # ] | |
| # /// | |
| import json |
thomascamminady
/ drop_columns_that_are_all_null.py
Created
September 20, 2023 07:40
Polars drop columns that are all null
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import polars as pl | |
| def drop_columns_that_are_all_null(_df: pl.DataFrame) -> pl.DataFrame: | |
| return _df[[s.name for s in _df if not (s.null_count() == _df.height)]] | |