Data and tables

Read, clean, summarize and write data with readtable, fillmissing, groupsummary, pivot, writetable and the other table functions you already know.

  • Existing MATLAB table code runs as written
  • On the desktop, scripts read your files where they are on disk
  • Tables open in a viewer beside the code, column by column
  • Free to try, with nothing to install
Download RunMat

Explore the RunMat runtime

Mean force by fixture and hour from a rig log, drawn by RunMat as a heatmap from the saved analysis study
A rig's load log pivoted by fixture and hour, drawn by RunMat with each cell's mean.

Why use RunMat for data and tables

Free for your own analysis

A log can be analyzed on the rig PC or a field laptop with no license server to reach. readtable, groupsummary, fillmissing and the date functions are part of the RunMat runtime, free for individuals, education, research and smaller companies.

Runtime

Analyze logs where the rig wrote them

Copying logs into another tool adds a step to every test day. On the desktop, a script reads CSV, Excel, JSON and HDF5 files from their folders on disk, so the analysis runs where the data already is.

Desktop app

Catch a misread column at once

A number column read as text skews a summary without raising an error. Every table and timetable opens in the variable viewer beside the code, with its column names, types and units, so the bad column shows up before it reaches a report.

Plots and variables

Reopen the numbers behind a report

When a figure in a report is questioned months later, the data and code behind it are hard to find. Each run keeps its tables, figures and code, so the summary opens again with the data it came from.

Desktop app

Examples

Force against time for three fixtures from a rig log, read with the right import options, rendered by RunMat

Messy CSV to a clean table

Preamble lines, a units row, N/A and two date formats, read right.

Mean force per fixture as bars with one-standard-deviation error bars, rendered by RunMat

Summary by group

Mean and spread of force per fixture with groupsummary.

A heatmap of mean force for three fixtures over seven hours, with the values in the cells, rendered by RunMat

Pivot two keys

Fixture by hour as a grid of means, drawn as a heatmap.

A raw temperature trace with dropouts and spikes above the cleaned trace and its moving mean, rendered by RunMat

Clean a sensor trace

Fill dropouts and replace spikes, then compare before and after.

Hourly enclosure temperature over two weeks with the mean of the last 24 hours, rendered by RunMat

Timestamps and a rolling mean

Two weeks of hourly readings in a timetable, on a time axis.

Counts of INFO, WARN and ERROR lines from a controller log as bars, rendered by RunMat

Parse a text log

Pull levels and loads out of log lines, then count by level.

Try it on your own data

Download RunMat
Read the docs