dotnet/machinelearning · error · System.ArgumentException

Column '{0}' does not exist

Error message

Column '{0}' does not exist

What it means

DataFrame.GroupBy(columnName) looks the column up with IndexOf and throws ArgumentException (Strings.InvalidColumnName, 'Column \'{0}\' does not exist') when the name is not found. The library needs the column's index to build the GroupBy object, so an unknown name is rejected. This error also surfaces from GroupBy<T>, Count, First, Head, Tail, Max etc., which all call GroupBy internally.

Source

Thrown at src/Microsoft.Data.Analysis/DataFrame.cs:371

                shuffleLowerLimit++;
            }
            ArraySegment<int> segment = new ArraySegment<int>(shuffleArray, 0, shuffleLowerLimit);

            PrimitiveDataFrameColumn<int> indices = new PrimitiveDataFrameColumn<int>("indices", segment);

            return Clone(indices);
        }

        /// <summary>
        /// Groups the rows of the <see cref="DataFrame"/> by unique values in the <paramref name="columnName"/> column.
        /// </summary>
        /// <param name="columnName">The column used to group unique values</param>
        /// <returns>A GroupBy object that stores the group information.</returns>
        public GroupBy GroupBy(string columnName)
        {
            int columnIndex = _columnCollection.IndexOf(columnName);
            if (columnIndex == -1)
                throw new ArgumentException(String.Format(Strings.InvalidColumnName, columnName), nameof(columnName));

            DataFrameColumn column = _columnCollection[columnIndex];
            return column.GroupBy(columnIndex, this);
        }

        /// <summary>
        /// Groups the rows of the <see cref="DataFrame"/> by unique values in the <paramref name="columnName"/> column.
        /// </summary>
        /// <typeparam name="TKey">Type of column used for grouping</typeparam>
        /// <param name="columnName">The column used to group unique values</param>
        /// <returns>A GroupBy object that stores the group information.</returns>
        public GroupBy<TKey> GroupBy<TKey>(string columnName)
        {
            GroupBy<TKey> group = GroupBy(columnName) as GroupBy<TKey>;

            if (group == null)
            {
                DataFrameColumn column = this[columnName];

View on GitHub (pinned to 7b76e69cf9)

Solutions

1. Verify the exact name against df.Columns — print or assert the column list before grouping.
2. Match casing and trim whitespace from the column name string (headers may carry a BOM or spaces).
3. Guard with df.Columns.Contains(columnName) before calling GroupBy and give a clear error if absent.
4. Catch ArgumentException around GroupBy to report the missing column in user-facing messages.

Example fix

// before
var g = df.GroupBy("Categry");
// after
if (!df.Columns.Contains("Category"))
    throw new InvalidOperationException($"Column missing. Have: {string.Join(',', df.Columns.Select(c => c.Name))}");
var g = df.GroupBy("Category");

if (!df.Columns.Contains(columnName))
    throw new InvalidOperationException($"Column '{columnName}' missing. Available: {string.Join(',', df.Columns.Select(c => c.Name))}");
var g = df.GroupBy(columnName);

bool HasColumn(DataFrame df, string name) => df.Columns.Contains(name);

try { g = df.GroupBy(columnName); }
catch (ArgumentException ex) { logger.LogError(ex, "GroupBy column '{0}' not found", columnName); throw; }

When it happens

Trigger: df.GroupBy("Sales") where no column is literally named 'Sales' — typos, different casing, names with whitespace, or columns that were never loaded (CSV header mismatch) or renamed/dropped earlier in the pipeline.

Common situations: Case-sensitive mismatch ('sales' vs 'Sales'); CSV headers with BOM or trailing spaces; a column added conditionally; renaming a column in one pipeline stage but not downstream consumers.

Understand the failure class

Background: "Not found" and "does not exist" errors: why "Task not found", "No such folder", and "Can't find" fire when a lookup comes back empty — this error's family across 14 libraries.

Related errors

• nameof(groupByColumnIndex)
• {fieldType.Name}
• MismatchedColumnLengths
• Exception of type 'System.ArgumentException' was thrown.
• kind

AI-assisted analysis of dotnet/machinelearning@7b76e69cf9 (2026-09-11). Data as JSON: /api/errors/cc4990e08be72410. Report an issue: GitHub.