dotnet / dotnet/machinelearning-modelbuilder

The Model 2022 reads true/false data as a string when csv file is loaded

Open
#2,782 0 comments 0 reactions 0 assignees View on GitHub
GS Tutorial Stale
Dominant language
Dockerfile
Stars
285
Forks
66
PR merge metrics
No merged PRs in 30d

Description

**System Information (please complete the following information):**
- Model Builder version 2022
- Microsoft.ML (tested with 2.0.1 and 3.0.0-preview.23511.1)
- Visual Studio Version: Community 2022 (64-bit) Version 17.7.6

**Describe the bug**
- When I load the CSV file the model treats several columns as being of type string. However, all columns are only of one type, boolean, with true ou false values.
- The CSV file has a first line with 3653 columns names, and has 82020 rows of data.
- ** I can't just change more than 2000 columns manually each time I load the file.

**To Reproduce**
Steps to reproduce the behavior:
1. Go to 'Add Data'
2. Click on 'Browse'
3. Select the file
4. Click in 'Advanced data options..."
5. Check the 'Data type' column.
6. Many of them are treated as a 'string'.

**Expected behavior**
All the columns should be only as a boolean data type.

The Data Lines (exemple):
true,true,false,false,false,true,false,true,true,true,false,true,false,true,false,false,false,false,true,false,false,false,true,false,false,...

** PS: The column names are unique in the file, despite the screenshot showing the same names. Full names have been hidden.

**Screenshots**
![image](https://github.com/dotnet/machinelearning-modelbuilder/assets/26722579/ee890a3a-8c43-455d-8661-278a5ae55c70)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.