在C#中使用Deedle连接两个字符串列

using System;
using Deedle;

class Program
{
    static void Main()
    {
        // 创建两个数据帧
        var df1 = Frame.FromRows(new object[][]
        {
            new object[] { "A", 1 },
            new object[] { "B", 2 }
        }, new string[] { "Letter", "Number" });

        var df2 = Frame.FromRows(new object[][]
        {
            new object[] { "A", "X" },
            new object[] { "C", "Y" }
        }, new string[] { "Letter", "Code" });

        // 按列名连接两个数据帧
        var joinedDf = df1.Join(df2, "Letter");

        // 输出结果
        Console.WriteLine(joinedDf);
    }
}

// 重新设置索引
df1.IndexRowsBy("Letter");
df2.IndexRowsBy("Letter");

// 检查列名是否存在
if (!df1.ColumnNames.Contains("Letter") || !df2.ColumnNames.Contains("Letter"))
{
    throw new ArgumentException("指定的列名不存在");
}