(TIL) Jupyter: Set environment variables
You can set environment variables directly from the notebook without having to restart the kernel:
Recent Posts
(TIL) Jupyter: Output of all variables
If you try to see the output of more variables without explicitly writing print in front of each, only the last one gets outputted. With this, you get the...
(TIL) Snowflake: Create table with comment
You can specify comments for a table, and even the columns in the table:
(TIL) Pandas: Write DataFrame to table with to_sql
You can write DataFrames to a database table via a sqlalchemy connection as follows:
(TIL) Pandas: sort_index
Dataframes have a new sort_index method to sort a dataframe by index. This is equivalent to the deprecated sort method with the columns argument set to `None.