Translate query into Python Snippet

AllenInstitute / biofile-finder

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.

https://biofile-finder.allencell.org/

BSD 3-Clause "New" or "Revised" License

3 stars 1 forks source link

Translate query into Python Snippet #80

Closed SeanLeRoy closed 6 months ago

SeanLeRoy commented 7 months ago

In the "Code Snippet" modal we would like to provide options for exporting the current query into programmatic queries. As an initial shot at this lets start with adding Python using Pandas. To do this: In the modal:

Add a dropdown for selecting which language to export the query to with just "Python (pandas)" as the one option for now
Instead of TODO render the code it would take to query a pandas dataframe and get the same result as what would render in the file list of the app
Test with various versions of pandas to get a minimum version to set for the pandas install

SeanLeRoy commented 6 months ago

As an MVP for this app this version of the Python Snippet should at minimum support just the external use cases. External use cases will read from CSV, JSON, or Parquet so we can use pandas to read them in and mirror the currently selected query in the pandas query. Keep in mind at the moment of writing this that all data in external data sources will be read in as strings.Eventually it would be nice to support querying FMS too by using aicsfiles or writing a dynamic script.