ML.NET加载来自枚举的数据返回空空IDataview
我正在尝试将数据库中的数据放入列表中,然后将其加载到IDATAVIEW中,但是每次Idataview都是空的。这是问题代码:
(IDataView training, IDataView test) LoadData(MLContext mlContext)
{
var trainData = new List<ModelInput>();
try
{
using var conn = new MySqlConnection(connection);
conn.Open();
var selectCmd = "SELECT user_id, movie_id, review_value FROM review";
var command = new MySqlCommand(selectCmd, conn);
var reader = command.ExecuteReader();
while (reader.Read())
{
trainData.Add(new ModelInput
{
user_id = reader.GetInt32(0),
movie_id = reader.GetInt32(1),
review_value = reader.GetFloat(2),
});
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
var testDataPath = "recommendation-ratings-test.csv";
IDataView trainingDataView = mlContext.Data.LoadFromEnumerable<ModelInput>(trainData);
IDataView testDataView = mlContext.Data.LoadFromTextFile<ModelInput>(testDataPath, hasHeader: true, separatorChar: ',');
return (trainingDataView, testDataView);
}
我找不到有关此问题以及如何解决问题的任何内容。请帮忙。
I am trying to put data from a database into a list and then loading it into an IDataView, but the IDataView is empty every time. Here is the problem code:
(IDataView training, IDataView test) LoadData(MLContext mlContext)
{
var trainData = new List<ModelInput>();
try
{
using var conn = new MySqlConnection(connection);
conn.Open();
var selectCmd = "SELECT user_id, movie_id, review_value FROM review";
var command = new MySqlCommand(selectCmd, conn);
var reader = command.ExecuteReader();
while (reader.Read())
{
trainData.Add(new ModelInput
{
user_id = reader.GetInt32(0),
movie_id = reader.GetInt32(1),
review_value = reader.GetFloat(2),
});
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
var testDataPath = "recommendation-ratings-test.csv";
IDataView trainingDataView = mlContext.Data.LoadFromEnumerable<ModelInput>(trainData);
IDataView testDataView = mlContext.Data.LoadFromTextFile<ModelInput>(testDataPath, hasHeader: true, separatorChar: ',');
return (trainingDataView, testDataView);
}
I cannot find anything only about this problem and about how to solve it. Please help.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论