PhloemDocs

Open a run in Excel or pandas

Save one run to a folder, then open its data in a spreadsheet or a notebook.

Before you start

  • Phloem Computer, with a recorded run. See Runs.
  • Excel, or Python with pandas (and pyarrow for Parquet).

Steps

  1. Open Replay and the runs tab on the left.
  2. Find the run. Type part of its name in Filter runs.
  3. Open the run's menu and choose Download…. The Download data sheet opens on that run.
  4. When already holds the run. Press Next.
  5. Under What, pick Everything, or Choose and tick channels. Press Next.
  6. Under How, pick Save as:
    • Spreadsheet for Excel. Under Details, Table offers a file per rate, one wide file or a row per sample.
    • Notebook for pandas.
  7. Press Review. Check the folder's file list.
  8. Press Download, then Show in folder.

Open it

In Excel, open a file from data/. Column t_s is seconds from the start of the window. Each column after it is a channel. channels.csv maps each column to its full channel path and unit.

In pandas, read the Parquet file. It holds one row per sample:

import pandas as pd

df = pd.read_parquet("data/signals.parquet")
# columns: t_us, path, value_f64, value_text, kind
wide = df.pivot_table(index="t_us", columns="path", values="value_f64")

t_us is the exact time in microseconds since 1970 (UTC).

Check it worked

  • The folder holds README.txt, channels.csv, data/ and details/.
  • The README names every data file with its columns and units.
  • A long run's CSV continues in _part2.csv, _part3.csv… Each part opens on its own in Excel.
Tip

Excel set to a comma decimal? Under Details, set the decimal separator to 1,5. The column separator switches to Semicolon.

Updated