You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have my data stored in a single table that I query to grab certain columns (and "de-NULL"). I was previously saving as a CSV (due to another issue re: certificate trust) and training largely successfully. However, as I move into retraining, I'm trying to pull directly from the database with a train/test split. When I do this, I get an InvalidCastException: "Unable to cast object of type 'System.Int32' to type 'System.Single'". Presumably this is due to any number of INT fields that I'm returning (I've got some MONEY, some INT, some DATE, and some NVARCHAR); I think the CSV route is treating everything as a string and parsing to whatever, whereas the DB is typing everything.
My question is - is it up to me to prepare the data with the right types here (either by transform or by having my SQL convert everything to MONEY/NVARCHAR), or is there something I'm missing to get it to handle the conversion automatically?
The text was updated successfully, but these errors were encountered:
I have my data stored in a single table that I query to grab certain columns (and "de-NULL"). I was previously saving as a CSV (due to another issue re: certificate trust) and training largely successfully. However, as I move into retraining, I'm trying to pull directly from the database with a train/test split. When I do this, I get an InvalidCastException: "Unable to cast object of type 'System.Int32' to type 'System.Single'". Presumably this is due to any number of INT fields that I'm returning (I've got some MONEY, some INT, some DATE, and some NVARCHAR); I think the CSV route is treating everything as a string and parsing to whatever, whereas the DB is typing everything.
My question is - is it up to me to prepare the data with the right types here (either by transform or by having my SQL convert everything to MONEY/NVARCHAR), or is there something I'm missing to get it to handle the conversion automatically?
The text was updated successfully, but these errors were encountered: