Tools that finish the job .NET left open.

using Datafication.Core.Data;
using Datafication.Extensions.Connectors.CsvConnector;

var sales = await DataBlock.Connector.LoadCsvAsync("sales.csv");

var result = sales
    .Where("region", "North America", ComparisonOperator.Equals)
    .Compute("profit_margin", "profit / revenue")
    .Where("profit_margin", 0.25, ComparisonOperator.GreaterThan)
    .GroupByAggregate("product_category", "revenue",
        AggregationType.Sum, "total_revenue")
    .Sort(SortDirection.Descending, "total_revenue");

using Datafication.Core.Data;
using Datafication.Connectors.CsvConnector;
using Datafication.Storage.Velocity;

// Stream a large CSV to disk in batches, in the DFC columnar format
var connector = new CsvDataConnector(new CsvConnectorConfiguration
{
    Source = new Uri(Path.GetFullPath("data/orders.csv"))
});

using var orders = new VelocityDataBlock("data/orders.dfc");
await connector.GetStorageDataAsync(orders, batchSize: 10000);
await orders.FlushAsync();

// The same query API: Where, GroupByAggregate and Sort build a plan; Execute runs it
var totals = orders
    .Where("region", "North America", ComparisonOperator.Equals)
    .GroupByAggregate("product_category", "revenue",
        AggregationType.Sum, "total_revenue")
    .Sort(SortDirection.Descending, "total_revenue")
    .Execute();

// [1] C#
record Sale(string Region, decimal Revenue);
var revenue = new[] { new Sale("East", 52_000m), new Sale("West", 38_500m) };
var threshold = 40_000m;

# [2] Python: revenue and threshold came from the C# cell
over = [r.Region for r in revenue if r.Revenue > threshold]

-- [3] SQL: bound from the shared store
SELECT * FROM orders WHERE total > @threshold

<!-- [4] Markdown -->
Regions above @threshold are on track this quarter.

using Verso;
using Verso.Abstractions;
using Verso.Extensions;

var extensionHost = new ExtensionHost();
await extensionHost.LoadBuiltInExtensionsAsync();

var scaffold = new Scaffold(new NotebookModel(), extensionHost, filePath: null);
scaffold.InitializeSubsystems();

scaffold.AddCell("code", language: "csharp", source: "var greeting = \"hello\";");
scaffold.AddCell("code", language: "csharp", source: "greeting.ToUpper()");
await scaffold.ExecuteAllAsync();

scaffold.Variables.Set("threshold", 0.95);
var threshold = scaffold.Variables.Get<double>("threshold");

$ verso serve my-notebook.verso         # open in the browser
$ verso run pipeline.verso --param region=us-east --fail-fast
$ verso convert notebook.ipynb --to verso
$ verso repl --kernel fsharp

using Motus;
using Motus.Testing.MSTest;
using static Motus.Assertions.Expect;

[MotusTestClass]
public class SearchTests : MotusTestBase
{
    [TestMethod]
    public async Task SearchReturnsResults()
    {
        var page = await Context.NewPageAsync();
        await page.GotoAsync("https://example.com");
        await page.Locator("input[name='q']").FillAsync("motus automation");
        await page.Locator("button[type='submit']").ClickAsync();
        await That(page).ToHaveUrlAsync("**/search**");
        await That(page.Locator(".results")).ToBeVisibleAsync();
    }
}

{
  "mcpServers": {
    "motus": {
      "command": "motus",
      "args": ["mcp"]
    }
  }
}

// Add capabilities by name when an assistant needs them:
// motus mcp --caps coordinates,recording,contexts,routing