Get Started: Row64 for Excel Users

What exactly is Row64 to Excel?

We have essentially built Row64 as a multi-purpose application where it’s easy for Excel users to use their knowledge of spreadsheets and formulas to do more advanced data science projects.

The main difference in Row64 is that we connect dataframes to spreadsheets. Basically a dataframe is similar to a tab filled with raw data in Excel.

Dataframes look and work like raw data sheets but they have extra super powers like the ability to load millions of records and transform the data with recipes that generate Python.

Millions of records can load exponentially faster compared to traditional spreadsheet applications due to Row64’s ability to handle multi-layer operations all at once.

Quick Tips to Get Started:

  1. When you first open Row64, you are greeted by the default Spreadsheet UI which you can immediately begin to edit.

  2. To use your own data to work on, select the “Import” tab and then “Import Data.”

  3. Choose either “Automatic” or “Detailed” Import to load your records. Use the latter function for higher density data.

Screenshot 2021-08-17 at 11.38.50 AMTIP: Row64 supports CSV, TSV, WORD, XLSX, files; use “Detailed Import” for better control.

  1. Once your data has been imported, select “Run Diagnostic,” in which Row64 will automatically generate a summarized display of what type of data you are working with.

  2. The generated summary allows for easy edits to column or row data types and names, allowing you to immediately apply document-wide changes instantaneously.

  3. Once finished, click Ok to exit the Diagnostics UI and then select “Complete Import” to automatically move your spreadsheet data into the Dataframe tab to allow more direct changes to data through the use of Python scripting.

  1. You can also transpose your data unto different types of charting, including GeoAnalysis through the Charts tab.

  • The key to Row64’s vast functionality is through the merging of Python and Spreadsheet analysis capabilities and using a the concepts of dataframes to work with large amounts of data.

  • The gif below briefly breaks down exactly which integrations are included to provide extremely fast speeds when loading millions of records.

  • Python can be automatically generated from Excel Formulas as shown below: