An open-use web application created for easy access, collaboration, and sharing of datasets through rich metadata search, filter, sort, and direct viewing in common industry applications or in our web-based 3D Volume Viewer.
The current version of the Python Snippet only supports external use cases (data read from csv, json or parquet and converted to strings). However, it should also support internal use cases, where data is read from the AICS database and has different types.
In the "Code Snippet" modal:
Render the code to read data from AICS to pandas
Add support for range filters and sorting on non-string types (e.g., date, date-time, numerical)
Account for potential pandas type conversions: By default, pandas tries to make assumptions about dtypes when it creates a dataframe, which may conflict with our internal types.
The current version of the Python Snippet only supports external use cases (data read from csv, json or parquet and converted to strings). However, it should also support internal use cases, where data is read from the AICS database and has different types.
In the "Code Snippet" modal:
dtypeswhen it creates a dataframe, which may conflict with our internal types.Originally posted by @SeanLeRoy in https://github.com/AllenInstitute/aics-fms-file-explorer-app/issues/80#issuecomment-2101224894