DeveloperLoad - DeveloperLoad

pandas multi-level index series: index value convert to dataframe columns name

Pandas question: I have a multi-level index series as following index1 index2 A 2022-01-01 1.0 2022-01-02 2.0 2022-01-03

Storing a billion long snowflake query into a json file

I am running an sql query from a python script using the snowflake python connector and sqlalchemy. The query returns more than 6 billion rows of information (e

Lost creating a .sh file using either echo -en or printf

I'm trying to create a .sh file to write to a serial usb relay... on a Raspberry pi running Rasbian. If run the following lines from the command prompt it sets

How to trap ERR when using 'set -e' in Bash

I have a simple script : #!/bin/bash set -e trap "echo BOO!" ERR function func(){ ls /root/ } func I would like to trap ERR if my script fails (as it

download pdf from google sheet and

I found this code where I can download google sheet to pdf but I want to change it in order to chose another sheet then the active one and download the pdf once

Check if an extension is in use before dropping it in a postgres db

I want to drop unnecessary extensions in my database. But before i do that , i want to make sure that they are not being used anywhere in the database. I have t

Allow sites to be reloaded in Internet Explorer mode

I need to use Selenium to start up Edge and allow sites to be opened in IE mode (with Selenium). I did do settings -> default browser -> and selected Allo