CognitiveRocket VS daany

It totally depends upon you as how you want to secure Power Platform environment. It can be your sandbox, your trial instance or also a Developer Plan. I have got a M365 Developer Plan and I will be using that. My complete solution (Custom Connector + Power Virtual Agents) is available on my usual GitHub repo for the AI for Every Developer series. You can play with it.

In my Personalizer Library, I am using the preview version of the .NET SDK

Although I created CognitiveRocket repo for the purpose of sharing my demos, slide decks etc. but I still remember submitting my first ever pull request on my friend's (James Mann) repo which later became one of the reasons to start Bot Builder Community Project and to enable all the Microsoft Bot Framework enthusiasts and developers to join hands together to build fantastic tools for everyone. 🛠

In this blog post, I've applied a generic approach and created an Azure Function for you. As I've kept it opensource so feel free to download and use in your own projects. All you have to do is to change the endpoint URL and API Key.

/// /// Adds a total_score column to the DataFrame by calculating the cumulative sum /// /// DataFrame to which new column is added public void AddTotalScorePerBallDaany(Daany.DataFrame df) { // https://github.com/bhrnjica/daany // calculate total_score per ball df.AddCalculatedColumn(CSV_COLUMN_TOTAL_SCORE, (r, i) => { var response = Convert.ToSingle(r[CSV_COLUMN_SCORE]); return 0; }); int previousMatchId = -1; int previousInning = -1; float previousScore = -1; int rowIndex = 0; foreach (var dfRow in df.GetRowEnumerator()) { var matchId = (int)dfRow[0]; var inning = (int)dfRow[4]; var score = Convert.ToSingle(dfRow[df.Columns.Count - 2]); // Score if (previousMatchId == -1) // First time { // Reset previousMatchId = matchId; previousInning = inning; if (previousScore == -1) { previousScore = score; } } if (matchId == previousMatchId && inning == previousInning) { float newScore = previousScore + score; // Total Score dfRow[df.Columns.Count - 1] = newScore; df[rowIndex, df.Columns.Count - 1] = newScore; previousScore = newScore; } else { // Total Score dfRow[df.Columns.Count - 1] = score; df[rowIndex, df.Columns.Count - 1] = score; // Reset previousMatchId = -1; previousInning = -1; previousScore = score; } rowIndex++; } }