lhe2sqlite

Simple utility to convert LesHouchesEvents files to a sqlite database

Setup

To run, simply install the package

pip install lhe2sqlite [--user]

Then run with:

convertlhe2sqlite input.lhe output.sqlite3

Then you can examine the content with either stright SQL or your analysis tool of choice (eg pandas).

Schema

The resulting database has just 2 tables, event, and particle with a one-to-many relationship between them.

CREATE TABLE event (
    event_number INTEGER PRIMARY KEY,
    procId INTEGER,
    weight FLOAT,
    scale FLOAT,
    aqed FLOAT,
    aqcd FLOAT
);
CREATE TABLE particle (
    event_number INTEGER REFERENCES event(event_number),
    pdgId INTEGER,
    status INTEGER,
    mother1 INTEGER,
    mother2 INTEGER,
    color1 INTEGER,
    color2 INTEGER,
    px FLOAT,
    py FLOAT,
    pz FLOAT,
    e FLOAT,
    m FLOAT,
    lifetime FLOAT,
    spin FLOAT
);