prose VS daany

Our program synthesis APIs are available publicly, but for non-commercial use only. <https://github.com/microsoft/prose> You want to look for API samples corresponding to Transformation.Text capability. This is a more powerful capability than Flash Fill. If you happen to try this out, we'd be very interested in getting your feedback on whether this is powerful enough to handle your use cases, and if not, we would love to be inspired by your use cases for a future version of this technology. You may reach us at [email protected].

/// /// 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++; } }