Dataframe load data from excel and query using sql

dotnet / machinelearning

ML.NET is an open source and cross-platform machine learning framework for .NET.

https://dot.net/ml

MIT License

9.04k stars 1.89k forks source link

Dataframe load data from excel and query using sql #5646

Open Kumar3010 opened 4 years ago

Kumar3010 commented 4 years ago

can we load excel data using this libraray and query the dataframe as we do in padnas using sql command df.select("select col1,col2,from df")

pgovind commented 3 years ago

No, we can't do this yet. However, if you find a library that lets you read excel files and exposes it as an IDataReader, we should be able to read it into a DataFrame once https://github.com/dotnet/corefxlab/pull/2924/files goes in

YohDeadfall commented 3 years ago

There's ExcelDataReader which is ADO.NET compatible.

Kumar3010 commented 3 years ago

@pgovind - could you please let us know if this is possilbe now

pgovind commented 3 years ago

Not yet unfortunately. dotnet/corefxlab#2924 is inactive at the moment. Would you be interested in adding unit tests to that PR? If not, this is on the list for the next DataFrame release. I'm tied up with .NET 6 work at the moment though, so it'll be a while before I can get to this.