I’m very excited to have found Modin yesterday. The OS-Climate project is building a data browser, and Modin matches closely the requested spec for the browser. Yay for open source!
Our data source (corporate financial reports) can be very wide, though it can also be made tidy. When tidy, the observations can be quite simple:
Company X, Reported Year Y, that they emitted Z megatons of CO2
However, users want to browse that data in context, such as an ESG (Environmental-Social-Governance) report that gives:
Company X, in Sector S, Subsector S.1, Subsubsector S.2, Subsubsector S3, Industry Code S.4, in Country C, in Region R, reported an ESG topic Factor Area FA, Factor F, subfactor SF, reported Year Y, that they emitted Z megatons of CO2
In other words, sometimes analysts are interested in browsing down industry taxonomies before looking at what ESG factors are reported, whereas other times they are interested in browsing down ESG factors, and then want to see which sectors/companies are reporting those factors.
What I’d ilke to do is to name column groups and put those in the toolbar as columns that can be shown/hidden in the view. Any guidances or gotchas before I start working on spreadsheet.widget.js and grid.py?
I will note for the record that there is an unfortunate class in naming: change_selection in grid.py operates as users select or de-select rows with the GUI. However, in the tidy data world, “filter” is what selects rows and “select” is what selects columns. My inclination is to change “selection” to “highlighted” or “row_selection” or some such.