I have been using a cmd file to do this but wrote this using Nushell.
#!/usr/bin/env nu
# PR 20250503_1747
# PR 20250913_0020| { | |
| "$help": "https://aka.ms/terminal-documentation", | |
| "$schema": "https://aka.ms/terminal-profiles-schema", | |
| "actions": | |
| [ | |
| { | |
| "command": | |
| { | |
| "action": "copy", | |
| "singleLine": false |
| -- Pull in the wezterm API | |
| -- PR 2026-02-06 17:52:03 | |
| -- Running on windows | |
| -- Using Nushell set OSC133 = false | |
| -- $env.config.shell_integration.osc133 = false | |
| local wezterm = require 'wezterm' |
Show in a Pivot table how much has been spend by Auto and Year The data has to be cleaned and have fields added
This data comes from MS Money, using UE to remove "total" lines, and blank lines.
I saw this in the Nushell Discotrd Channel. They were showing how they used a group-by and histogram together.
The reaction_watch.csv "Subject" field can have more than one "field of study".
This is from Nushell 0.110.0 $nu The $nu constant is a record containing several useful values:
I exported the data from MS Money, for all years (2010 + 2025) the details on Grocies.
I wanted to see how to sum the data by year for one grocey store.
I had done this in Visidata, and I knew both Nushell with the Polars plugin and Xan could do it, so I decided how to get the syntax correct in both.
This is a very small dataset, only 1054 records.