See how to use the reactable R package to make an interactive table with rows that expand when clicked ...

See how to use data.table's special .SD symbol to perform calculations and other tasks by group ...