dotnet/machinelearning · error · InvalidOperationException

There are no columns in the DataFrame to use as value column

Error message

There are no columns in the DataFrame to use as value columns after excluding the ID columns

What it means

Thrown by DataFrame.Melt when valueColumns is not supplied and every column in the DataFrame is an ID column, leaving no columns to melt into value rows. Because this is a state problem of the DataFrame itself (not a bad argument), it is raised as InvalidOperationException (Strings.NoValueColumnsRemaining).

Source

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

            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)
            {
                throw new ArgumentException(string.Format(Strings.VariableNameAlreadyExists, variableName), nameof(variableName));
            }

            if (_columnCollection.IndexOf(valueName) >= 0)
            {
                throw new ArgumentException(string.Format(Strings.ValueNameAlreadyExists, valueName), nameof(valueName));
            }

            if (string.Equals(variableName, valueName))
            {
                throw new ArgumentException(string.Format(Strings.VariableNameAndValueNameMustBeDifferent, nameof(variableName), nameof(valueName)), nameof(valueName));
            }

            foreach (var columnName in idColumnList)

View on GitHub (pinned to 7b76e69cf9)

Solutions

1. Remove at least one column from idColumns so it can serve as a value column
2. Load/add measurement columns to the DataFrame before melting
3. Check DataFrame.Columns.Count > idColumns.Count before calling

Example fix

// before
df.Melt(new[] { "A", "B" }); // DataFrame only has columns A and B
// after
df.Melt(new[] { "A" }); // B becomes the value column

if (idColumnList.Count >= df.Columns.Count) throw new InvalidOperationException("At least one non-ID column must remain to melt");

try { df.Melt(ids); }
catch (InvalidOperationException ex) when (ex.Message.Contains("value columns")) { /* reduce idColumns or add data columns */ }

When it happens

Trigger: Calling df.Melt(ids) where ids contains every column name of the DataFrame, so the non-ID column list is empty.

Common situations: Selecting all columns as identifiers in a UI; a DataFrame with only key columns loaded from a narrow source; idColumns accidentally containing a wildcard or over-broad selection.

Understand the failure class

Background: UnsupportedOperationException and "is not supported" errors: when a library deliberately refuses a call — this error's family across 30 libraries.

Related errors

• Parameter must not be null, empty, or whitespace
• Value cannot be null. (Parameter 'idColumns')
• Must provide at least 1 ID column
• Must provide at least 1 value column when specifying value c
• Columns cannot exist in both idColumns and valueColumns

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