In an alternate universe we have nice specialised GUI front ends on things like netCDF or SQLite that enable what you say. Ease of use and lack of friction are paramount.
SQLITESTUDIO MANUAL SOFTWARE
In short, they are regular users, even if the software they use can be highly specific. Then they nod politely, keep doing their stuff in Excel, and call you when they need a bit of wizardry for a paper. They start getting distracted when you talk about architecture, and they’re lost when you go into things like pandas and scipy. I’ve seen it countless times: when you show them the results of a complex workflow, they are excited. Startup time, learning curve, steps to get a useful graph to check a trend, etc. It’s much heavier, the IDEs are much more complex than Excel, and quite a lot of people on Earth are not natural programmers. > In a second moment, python, pandas and notebook are pretty accessible too Or be very proficient in a given piece of complex software to process NMR spectra and barely able to operate Outlook.
One can be a great chemist or know all there is to know about how purple long-tailed fruit flies from Siberia and have no clue about how computers work. Just like anybody, they’ll jump through a lot of hoops if they think the results justify it, but they are sometimes quite resistant to change for the sake of change, and sometimes even to change itself. > We are talking about scientists, which are for sure able and used to work through different tools during their career. If not, I'd be happy if you did a Show HN when you're ready :) Sounds like a very interesting project, if you got a link I'd be interested in tracking progress. Definitely ranges, especially for numbers (just larger than 0 for example, or between 5 and 10). Sometimes I just want to view all the values matching X, other times I want to quickly see any outliers. > Perhaps instead of filtering, you'd like to see outliers or the range of values? Though I'm not super happy with the way Excel does that, surely some room for improvement. I've also used lookups, ie find the row matching this and extract the value from the given column in that row.
Also string formatting of numbers and dates (for concatenating with text). I mostly use SUM, COUNT and IF (if-then), along with functions to check if a string value is a valid number.
> What are the other most common formulae that you use? > Formulae are supported, but the cell (not column) must be set as the Formulae datatypeĪs long as it's not tedious to set a few thousand that sounds great. tons of other GUI features like formulas, spell check, etc Excel has user specified row ordering as default out-of-the-box behavior. That type of behavior is not easy in generic database viewers because most tables - by typical design of RDBMS table row ids - do not consider the visible spatial ordering of rows the way the end user wants to see them on the screen unless one adds an extra column to the table such as "gui_view_order_id". cut rows 37 to 52 and paste them above row 5. hide rows or collapse rows into outlines pivot the data via drag & drop UI (instead of manually writing a SQL cross-tab query) formatting any arbitrary row or column with bold/italics and change the font color or background cell color. They are often missing features that are taken for granted by Excel users: Millions are already familiar with the GUI of Excel.Ģ) The datagrid viewers in those tools are not powerful and feature-rich like Excel. >What'd be wrong with using something like DBeaver, SqliteStudio, or PG-Admin? Or buying a tool like DataGrip? Microsoft Accessġ) Those utilities are not typically included in the workstation image of laptops/desktops unlike MS Excel which is already part of Office 365.
0 kommentar(er)
