bhrnjica / daany Goto Github PK

I am getting below error while installing the package in .Net interactive within Jupyter Notebook

Package Daany.DataFrame 1.2.0 is not compatible with net5.0 (.NETCoreApp,Version=v5.0). Package Daany.DataFrame 1.2.0 supports: net6.0 (.NETCoreApp,Version=v6.0)

I have uninstalled .Net 5.0 from my system and installed .Net 6.0 fresh, still getting this error.

In control panel, there is only .Net 6.0

If you want, the notebook is available at https://github.com/praveenraghuvanshi/tech-sessions/blob/master/16062021-Global-AI-Community-2021/CricketAnalysis.ipynb

Let me know if you need more information.

Hi there,

when trying to save the dataframes in the "Predictive Maintenance in .NET" notebook, DataFrame.ToCsv throws an InvalidCastException from within the function; code is as follows:

//constructing the label column which indicate if the current machine will //fail in the next predTime` (24 hours as default) due to failur certain component.
//create final data frame from from feature df
var finalDf = new DataFrame(features_final);

//group failures by machineID and datetime
string[] cols = new string[] { "machineID" , "datetime"};
var failDfgrp = failures.GroupBy(cols);

//Add failure column to finalDF
finalDf.AddCalculatedColumn("failure", (object[]row, int i) => "none");
finalDf.RowCount();

DataFrame.ToCsv("../df1roll121212.txt", finalDf);
finalDf=DataFrame.FromCsv(@"../df1roll121212.txt");
`

And the stack trace:

Error: System.InvalidCastException: Invalid cast from 'Double' to 'DateTime'. at System.Double.System.IConvertible.ToDateTime(IFormatProvider provider) at Daany.DataFrame.ToCsv(String filePath, DataFrame dataFrame, Char delimiter, String dateFormat, Boolean writHeader) at Submission#70.<<Initialize>>d__0.MoveNext() --- End of stack trace from previous location --- at Microsoft.CodeAnalysis.Scripting.ScriptExecutionState.RunSubmissionsAsync[TResult](ImmutableArray1 precedingExecutors, Func2 currentExecutor, StrongBox1 exceptionHolderOpt, Func2 catchExceptionOpt, CancellationToken cancellationToken)

• DataFrame Unit Tests covered all public methods. However different scenarios when Exception is thrown is not covered well.

Great library!!!

Q1: Is there a sample present to transform a DataFrame into HTML table so that it can render properly in Jupyter notebook with dotnet interactive. Something similar to An Introduction to DataFrame.

Q2: How do we do GroupBy on multiple columns in a DataFrame, something similar to link

Currently Daany.DataFrame has stabilized and works well, so the next step is to provide 1D Series implementation mostly for time series data transformation and handling.

• Series should have its own Index with the same implementation as in DataFrame.
• Once the Series would have enough features, it will be merged with Daany.Stat project in order to implement much simpler usage of the current Time Series decomposition features and future implementation.