Skip to main content
Advanced Search
Search Terms
Content Type

Exact Matches
Tag Searches
Date Options
Updated after
Updated before
Created after
Created before

Search Results

12 total results found

chatterboc

PowerBI things

VBA

chat1

chatterboc

import polars as pl chunk_size = 1000  # Adjust based on available memorydataframes = [] for i in range(0, len(a_list), chunk_size):    chunk = a_list[i:i + chunk_size]    dataframes.append(pl.DataFrame(chunk, schema=["stsdf", "abc"])) combined_df = pl.conc...

chat1

chatterboc

import polars as pl def flag_offline_periods(df):    # Count entries per bucket    counts = df.groupby('timestamp_bucket').agg(pl.count('*').alias('count'))        # Identify buckets with more than 20 entries    high_count_buckets = counts.filter(pl.col('coun...

Holiday

PowerBI things

categories/any(c:c eq 'Holiday') and start/Datetime ge '@{startOfDay(addDays(utcNow(),1),'yyyy-MM-ddTHH:mmZ')}'     Title eq '@{items('Apply_to_each')['Subject']}' and Date eq '@{formatDateTime(items('Apply_to_each')['Start'], 'yyyy-MM-ddTHH:mm:ssZ')}' and ...

VBA

VBA

Sub GenerateOrgStructure()    Dim olApp As Outlook.Application    Dim objNS As Outlook.Namespace    Dim xlApp As Excel.Application    Dim wb As Excel.Workbook    Dim ws As Excel.Worksheet    Dim addr As Outlook.AddressList    Dim entry As Object    Dim row As ...

BB

VBA

Sub ExportGALToExcelOptimized()    Dim olApp As Outlook.Application    Dim olNS As Outlook.Namespace    Dim olGAL As Outlook.AddressList    Dim olEntries As Outlook.AddressEntries    Dim olEntry As Outlook.AddressEntry    Dim olUser As Outlook.ExchangeUser    ...

bro

chatterboc

#!/usr/bin/env bash # Usage: ./group_by_date_hour_symbol_source.sh path_to_logfile LOGFILE="$1" awk '  {    # Split the first field (20250209-13:45:02.123456) on the dash.    # dt[1] will hold "20250209", dt[2] will hold "13:45:02.123456".    split($1, dt, ...

asdf

VBA

1. System PrerequisitesFirst, install required system packages: bashCopy Code# Update systemsudo apt update && sudo apt upgrade -y # Install required system dependenciessudo apt install -y \    python3-pip \    python3-venv \    chromium \    chromium-driver...

asdasd

chatterboc

@echo offstart wt new-tab --profile "Command Prompt" --title "Program" cmd.exe /k "program.exe" ^; split-pane --horizontal cmd.exe /k "stuff.exe" ^; split-pane --vertical cmd.exe /k "morestuff.exe" ^; new-tab --profile "Git Bash" --title "UAT Servers" bash.exe...

sadfzxcv

chatterboc

#!/bin/bash## This script loads all tables in /stuff/kdb, runs a hardcoded multi-line Q-syntax query,# and writes the results into /home/stuff/output with a timestamped filename. # Move to the kdb directorycd /stuff/kdb || {  echo "Error: Failed to cd into /s...