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
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
Share Recipes by dropping them into your recipe folder & rescanning
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
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)
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
Months with 31 days
AVERAGEIF AND CODE
Fixed Notebook Loading issues
"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