dotnet/machinelearning · error · ArgumentException

Must provide at least 1 ID column

Error message

Must provide at least 1 ID column

What it means

Thrown by DataFrame.Melt when the idColumns argument yields an empty list, i.e. no ID columns were supplied (or none matched after processing). Melt needs at least one identifier column to preserve row identity in the long-format output. Raised as ArgumentException (Strings.MissingIdColumns) with paramName 'idColumns'.

Source

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

            var idColumnList = idColumns.ToList();

            HashSet<string> idColumnSet = null;

            if (valueColumns is null)
            {
                idColumnSet = [.. idColumnList];
            }

            var valueColumnList = valueColumns?.ToList()
                ?? _columnCollection
                    .Where(c => !idColumnSet.Contains(c.Name))
                    .Select(c => c.Name)
                    .ToList();

            if (idColumnList.Count == 0)
            {
                throw new ArgumentException(Strings.MissingIdColumns, nameof(idColumns));
            }

            if (valueColumns != null && valueColumnList.Count == 0)
            {
                throw new ArgumentException(Strings.MissingValueColumns, nameof(valueColumns));
            }

            if (valueColumns != null && valueColumnList.Any(v => idColumnList.Contains(v)))
            {
                throw new ArgumentException(Strings.DuplicateColumnsInIdAndValueLists, nameof(valueColumns));
            }

            if (valueColumns == null && valueColumnList.Count == 0)
            {
                throw new InvalidOperationException(Strings.NoValueColumnsRemaining);
            }

            if (_columnCollection.IndexOf(variableName) >= 0)

View on GitHub (pinned to 7b76e69cf9)

Solutions

1. Pass at least one valid ID column name that exists in the DataFrame
2. Validate the selected ID columns are non-empty before calling Melt
3. Ensure the names match DataFrame column names exactly (casing included)

Example fix

// before
df.Melt(new string[0], values);
// after
df.Melt(new[] { "Id" }, values);

if (idColumnList.Count == 0) throw new InvalidOperationException("Select at least one ID column before melting");

try { df.Melt(idColumns, valueColumns); }
catch (ArgumentException ex) when (ex.ParamName == "idColumns") { /* prompt for ID columns */ }

When it happens

Trigger: Calling df.Melt(Enumerable.Empty<string>(), values) or passing a collection whose names do not exist in the DataFrame so the filtered idColumnList ends up empty.

Common situations: Empty config arrays; building the ID list dynamically from user selections where nothing was selected; misspelled column names filtered out before the count check.

Understand the failure class

Background: "missing required argument" and "the following required arguments were not provided": what required-argument errors mean and how to fix them — this error's family across 20 libraries.

Related errors

• Must provide at least 1 value column when specifying value c
• Parameter must not be null, empty, or whitespace
• Value cannot be null. (Parameter 'idColumns')
• Columns cannot exist in both idColumns and valueColumns
• There are no columns in the DataFrame to use as value column

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