111–120 of 137 posts
Try the Pandas Profiling library [0]. Why do all the clicking and plotting and specifying variables when you can have a couple lines of code do it all for you? [0] https://pypi.org/project/pandas-profiling/
Earlier quoted context omitted.
That looks great, but AGPL makes everyone nervous.
Curious more than anything. If your intent is to use the tool as opposed to importing the tool as a feature or product, is the AGPL a problem? Also, "everyone nervous" is an interesting choice of words - I'm pretty sure most people wouldn't really care one way or the other. What is it about AGPL that causes stress among the masses?
Clarifications: no, using the tool directly is not a problem for us.
"Everyone" - appreciate your question and not guessing :-) I meant everyone at my company. That phrasing maybe speaks to my mindset :-D Basically I really mean legal and those in charge who might listen to legal over tech.
Gephi lets me show how this kind of table bloat happens over time and helps explain performance degradation.
This may be an unpopular opinion, but if you have US$70/mo to spare, it's hard to beat Tableau for this exact use case. "Connect to an arbitrary database, create a view that joins numerous tables (including foreign tables, via blending) together, load to columnar storage on a local SSD for performance if necessary, add arbitrary derived columns (including well-defined lateral lookups for things like 'annotate this ac…
The backstory was a large BI team having no proper tools for reporting, except maybe Looker for tabular KPI reports. So any addition of Tableau was an all our nothing buy, every single analyst or whoever on the BI team needed a seat, even though most of them wouldn't ever use it. For that matter 95 percent of the BI team would never move away from Excel. Anyway, the costs were huge for something that should have been a leap in capabilities.
I use Gephi a good deal to visualize connections between tables and schemas in a messy production MySQL database, mostly with the aim to stop people (read: consultants, junior developers, managers trying their hand writing SQL) from developing ad hoc duplicate tables for their own niche purposes. Gephi lets me show how this kind of table bloat happens over time and helps explain performance degradation.
Metabase is what you're looking for. https://metabase.com/
We use it and or staff are able to get at least a bit of value without knowing sql. but i still have to write most things or create a template they can copy and paste. the visual builder still relies on knowing fundamentally what a db is, what a join is. like mega obvious stuff that actually isn't obvious to non technical people. we area also multi tenent and it's not the best for that. like the default permissions w…
There are maybe 1/10-1/5 or maybe more who will be enabled by them on a technical level. The same kind of people who will build a site out of WP themes and plugins or build quite involved spreadsheets and so on.
I think it’s generally important and useful to enable and respect power users like that. They occupy a unique niche.
I love Metabase ( https://www.metabase.com/ ) and used it successfully with business users, too (small hedge fund). If it's not too much data, getting it out as .csv and using R + data.table + dplyr, etc; = incredible productivity. See [1] Use Excel, QlikSense and Tableau if Business Users need visualization. Excel pivot tables = OG data reshaping. Resist more complicated solutions : do you really need more than Exce…
Disclaimer: I'm one of the co-founders of Veezoo.
You should check out Arctype! ( https://arctype.com ) We're trying to re-imagine popular SQL clients (phpMyAdmin, MySQL Workbench) to have the design and software quality of modern tools like Superhuman, Linear, etc. We make it very easy to query and create charts from your database then share it with your team. We currently support MySQL, Postgres, PlanetScale, Yugabyte, and in the next couple of weeks SQLite and Cl…
You should check out Arctype! ( https://arctype.com ) We're trying to re-imagine popular SQL clients (phpMyAdmin, MySQL Workbench) to have the design and software quality of modern tools like Superhuman, Linear, etc. We make it very easy to query and create charts from your database then share it with your team. We currently support MySQL, Postgres, PlanetScale, Yugabyte, and in the next couple of weeks SQLite and Cl…