Hacker News Reader

Comment by systemz | Hacker News Reader

Great idea, easy to use GUI for non-tech and Pandas for data oriented at same time.

Is there some similar project but selfhosted? I would be uncomfortable with uploading health related data to external service.

View on HN

There’s a cool one I’ve used called MitoSheet[0]. Runs locally and has some great features, though it doesn’t support TSV files last time I checked. It’s being actively developed still. I believe it was developed with YCombinator funding.

[0] https://www.trymito.io/

grist is sort of similar. its a spreadsheet/database hybrid that lets you use python for formulas, and they have a self-hosted option:

https://www.getgrist.com/product/self-managed

Heavy emphasis on "sort of"; it enforces data types on columns, which is a significant difference from both spreadsheets and pysheets. This enables/requires more database-like behavior and planning (which is great for a lot of applications), but importing spreadsheets is much less intuitive and spreadsheet competence won't get you very far.

Grist's closer to "what if Access had an interface that was more like Excel". Pysheets is more like "what if Python data structures had a GUI that looked like Excel".

To put it another way, I love Grist but _would not_ recommend people who are using spreadsheets to try to bring their spreadsheets into it. I also love pysheets and _would_ recommend it for that usage.

I created buckaroo [1] as a better dataframe viewer for jupyter with built in summary stats. It's built to bring a better dataframe experience to people already using pandas/polars. All of it is extensible [2] so that you can customize stats and transformations to your workflow.

[1] https://github.com/paddymul/buckaroo

[2] https://youtu.be/GPl6_9n31NE

The PySheets server runs anywhere, for example: my laptop, Google AppEngine, and DigitalOcean. I designed it with on-prem in mind, so that PySheets could be deployed at companies that do not want to share data with external services.

That said, only the data stored in the sheet itself is stored in PySheets. Most use cases will load data from another place, filter and convert it, and then render a result. Still, self-hosting would be an interesting use case.

In the docs for my own project in this space, I created a whole related projects page. I figured if someone makes it to my docs, and buckaroo doesn't solve their problem, they should find something that does help them.

https://buckaroo-data.readthedocs.io/en/latest/articles/rela...

That's nice. I will do the same for PySheets, once the dust settles on the original launch.

Not exactly the same but Spyder IDE has very nice spreadsheet functionality for data. Maybe it works for you.

Another good option is Neptyne. Integrates with Google Sheets (provided you're comfortable storing your data there)

Reply on news.ycombinator.com