Csv: possibility to treat 0/1 column as number

[kirsar]

Is there any way to override default csv type inference behavior
"Columns with only 0, 1, Yes, No, True, or False will be set to bool"
(or may be inject a callback somewhere)
and treat 0/1 column as number for random csv (no shema known upfront)?
Thanks.

https://fsprojects.github.io/FSharp.Data/library/CsvProvider.html#Controlling-the-column-types

[nhirschey]

In general, I don't think so. But

1. If the column name is known (e.g., MyColumn) you could specify that the column with that name is integer

type Csv =
  CsvProvider<"file.csv",
              Schema="MyColumn=int",
              ResolutionFolder=ResolutionFolder>

2. You could use the csv parser instead to bypass auto conversion https://fsprojects.github.io/FSharp.Data/library/CsvFile.html

[certara-ksorokin]

@nhirschey thanks! Unfortunately my content is totally dynamic, no suggestions can be done upfront
So I introduced some post processing: if type inferred as boolean but column has only '0' and '1' cells, I forcely set it's type to integer.

[dsyme]

I guess we should interpet this as a request for a feature request for a new static parameter StrictBooleans to the CsvProvider so that the provider only infers a boolean type for samples containing precisely true/false values

Currently the spec says: "Columns with only 0, 1, Yes, No, True, or False will be set to bool." With this static parameter this would become "Columns with only 0, 1, Yes, No, True, or False will be set to bool. If StrictBooleans is active, then columns with only true or false will be set to bool."

[github-actions]

🤖 This is an automated response from Repo Assist.

I've implemented the StrictBooleans static parameter and submitted a draft PR on branch repo-assist/feature-strict-booleans-1417.

What was implemented, per the design you endorsed:

• StrictBooleans=true: columns with only 0/1 → int; yes/no → string; only pure true/false → bool
• StrictBooleans=false (default): existing behavior preserved, fully backward-compatible

Test status: 251/251 unit tests pass + 20/20 CSV DesignTime signature tests pass. The 18 failing DesignTime tests are pre-existing XML failures (network blocked in CI sandbox + a known XSD bug) — not caused by this change.

Please review when convenient!

Generated by Repo Assist

To install this workflow, run gh aw add githubnext/agentics/workflows/repo-assist.md@ee50a3b7d1d3eb4a8c409ac9409fd61c9a66b0f5. View source at https://github.com/githubnext/agentics/tree/ee50a3b7d1d3eb4a8c409ac9409fd61c9a66b0f5/workflows/repo-assist.md.

Warning

⚠️ Firewall blocked 2 domains

The following domains were blocked by the firewall during workflow execution:

• schemas.microsoft.com
• tomasp.net