Row64 V2.0 - Redefining Data Speed, Visualization and Collaboration

If our core philosophy of Row64 1.0 was to scale the data capability of the individual, our core philosophy of V2.0 is to scale the data capability of the team.

We accomplished this by not only further improving our core functions & stability of big data manipulation and data visualization—but by adding learning resources to immediately ramp up new users, and an incredible new data collaboration tool we're calling the 'Recipe Universe'. These features all converge to deliver a Row64 that's faster and easier to use than ever before.

Here's a breakdown of the exciting improvements based on your feedback that you can expect from our newly release V2.0:

Share Your Python With Anyone (Even Non-Coders)

One of Row64's most popular features is our 'data science' recipes, which takes 300+ Python snippets, and expresses them as drag-and-drop spreadsheet formulas. These recipes package the power of Python into custom workflows at a scale and simplicity not possible in Excel, such as Cohort Analysis and Database Connectors.

With Row64 V2.0, we pushed this concept further, opening up the ability for any Row64 user to create their own recipes by saving their Python scripts to the Recipe Universe. These neatly packaged 'no-code' solutions can then be immediately deployed across any team using Row64—including by non-coding analysts.

Plus, our Recipe Universe includes an IDE, meaning it streamlines not just the deployment but the entire creation process of Python recipes—including automated Python package and dependency management (full release notes at the bottom).

Large Scale Data Manipulation

As part of the Row64 V2.0 release, we increased the data frame manipulation capabilities by, allowing users to drag, edit, re-order and delete columns of up to 1 billion rows. This real-time ' Slice & Dice' capability at this scale is truly groundbreaking, and cannot be found in any competing software.

Enhanced Visual Animation

Animation reveal features have become increasingly useful as a means to display time as a parameter within a visualization. Our V2.0 release utilizes our "easy animate" feature to enable users to animate our static data visualizations, to create racing bar charts, dynamically revealed line charts, and much more.

Learn By Example

In order to better serve our new users, our V2.0 release comes equipped with a gallery of examples on our range of data visualization, manipulation and discovery tools. Browse example files of geospatial analysis, financial analysis, animated charting, text search to easily grasp the software's functionality.

Product Release Notes

Data Collaboration: Recipe Universe

  • Recipes are JSON files that define:

    • Spreadsheet style Formulas

    • Functions (Python Defs)

    • The Argument Mapping between Formula & Python including any pip library installations required

    • How your recipe will work in the Row64 UI

  • Formulas in custom recipes are very powerful, you have the power to modify the formula language in Row64 and offer a simple, one-click tool to less technical users

  • Recipe Manager: IDE for development and deployment of python recipes

    • Python Library Install (using pip):

      • Libraries specified in the "Pip" field in .recipe files will be installed when the recipe is clicked on in the app

      • All built-in recipes have been updated for automatic pip install

    • New "Reset Libraries" feature

      • If you corrupt your installation while experimenting with pip install, “Reset libraries” makes it easy to reset all libraries back to factory defaults

    • Recipe Scanning:

      • Recipes manage dependency trees of installation

      • "At a Glance" display of recipe version and dependencies

      • Cycle detection in poorly written libraries includes

      • Start rescan: either from the UI Settings(->recipemanager->scan Pro version only) or restart the app

  • Overhaul of Formula/Python Typing

    • More predictable, changes in Python that are not argument mapped, now always explode

    • Python into Formula Windows

      • A more stable & predictable undo/redo system will now undo both views simultaneously.

    • New Typing Features:

      • End Key, PgUp, PgDn

  • Default Location for Recipes

    • C:\Users\\Documents\Row64\_Recipes_V2_0

  • Share Recipes by dropping them into your recipe folder & rescanning

  • Download the detailed recipe creation documentation

Dataframe Manipulation: Slice & Dice

  • Typing & editing directly in Dataframe cells

  • Column reordering - 2 Methods

    • Select the column(s) you want, then hover over the selected column header until you see the drag icon. Then click to drag and move column(s) to a new location

    • Select the column(s) you want, then use ALT-Left or ALT-Right arrow keys to relocate

  • Column reorder works with Undo/Redo

  • Delete column

    • Select the column(s) you want. Right-click on the column header to open the context menu. The last option is "Delete Columns."

    • Note: If your dataset is >1M rows, there is no Undo for column delete.

Visual Analytics: Animated Charting

  • Bar Chart reordering

  • "Dynamic Reveal" style Line Chart

  • Chart "grows" into place, the axes & ticks adjust with the data

  • New keyframe system for X and Y tick spacing, Y axis upper/lower bounds

    • X and Y tick keyframes blend is a fade-in/fade-out

    • Y axis upper/lower bound keyframe blend is a linear interpolation of the values

  • New "Edit Animation" button at the top right to enter the keyframe editing mode

    • Click and drag to move keyframes around

    • Shift-Click on the keyframe to edit the tick or axes bound values

    • Use Arrow keys to move the keyframe around (hold down Shift for a bigger jump)

    • DEL key to remove a selected keyframe

    • "Auto" button at the top right to auto-reset the keyframes

    • Pro Tip: open the Animation PPG timeline and scrub the animation so you can see the keyframes behavior

  • Improved chart zooming & panning experience

  • New radial charts recipes

Simplicity: Out of Box Experience

  • New empty dataframe instruction box

    • Explains dataframes, what they are for and how to get a spreadsheet

  • Gallery template pop-up on app open

    • Allows users to download project examples from our website

New Recipe Categories

  • Cohort / Vintage analysis

  • Database Connectors for ingest (includes on-prem & cloud DBs)

Misc Improvements

  • Fixed the "Export CSV" button

  • Updated the SettingsPPG UI

  • Nvidia driver bug affecting the FilterUI and Dedup is now fixed for all driver versions

  • Worksheet TEXTJOIN fixed

  • Spreadsheet number format code fixes

    • negative numbers

    • Months with 31 days

    • AVERAGEIF AND CODE

  • Fixed Notebook Loading issues

  • Installer improvements

    • "on-demand" install of python libraries

    • installs a small set of critical libraries

  • Boot sequence improvements

    • Recipe scanning is threaded

    • Discovery templates are threaded

    • Discovery templates have a new local image cache improving performance

Published: Oct 3, 2022 5:00pm UTC

Recommended Reading