Hope for new math and Statistics functions for Columns and Rows

[sfd99]

sqlitebrowser
is absolutely GREAT!

As the Subject says:
Hope for new Math and Statistics functions
for Columns and or Rows,
integrated in sqlitebrowser...

For ex:
yesterday, I was in [Data Browser] mode
and had a specific column selected.

I simply needed the
SUM and the AVERAGE (mean)
of all the values in that selected column.

A Dropdown Menu in the [Data Browser] mode
with some common Math and Stats Fxs
would be VERY useful!

Suggested Stats functions
for that Menu
in [Data Browser] mode:
- SUM, MAX, Min, AVERAGE, MEDIAN, MODE, Q1, Q3, etc.

I use the R language,
so that would be a marriage made in heaven...

Right now,
we need to exit the DB Browser
go to a spreadsheet program,
or go to Rstudio (R program)
to calculate and then return to DB Browser...

Hope you can add this...
Best Greetings!.

SFd
San Francisco
Ubuntu LINUX 20.04
R, Rstudio

[justinclift]

Interesting. That's not a bad idea, and is probably do-able too. 😄

Btw, it looks like you've accidentally created a duplicate of this discussion as well, so I'll close that duplicate shortly.

[chrisjlocke]

Right now, we need to exit the DB Browser

Just a nod that you can perform maths functions via the 'execute SQL' tab in DB4S.

So to calculate the sum of field a:

select sum(field_a)
from table_a

[chrisjlocke]

Also, if you select cells in the 'Browse data' tab, the status bar has maximum, sum, minimum and average values.

[justinclift]

Oh, that's cool. Didn't realise DB4S did that. 😁

[MKleusberg]

Just an extra note: In case this doesn't work for you, it's likely because you're selecting too many rows. For performance reasons we only calculate these values if you select less rows than configured here:

Also make sure to not hover any toolbar button or similar after selecting the cells because this overrides the status bar with some help text.

[sfd99]

Thanks all,
Chris, Martin and Justin
for the good advice and tips!.

(After selecting a Column,
I hadn't noticed the stats: ave, max, min,... info
@ bottom of screen!).

Q:
Is there a way to select MULTIPLE cols
in [Browse Data] and get stats for each col?.

+Suggestion:
It would still be very useful
to allow choosing several typical stats fxs
applied to user-selected col(s),
but in the [Browse Data] tab.
(faster than typing in the [Execute SQL] tab!...).

I was thinking of a dropDown Menu w/Math Fxs
in the [Browse Data] tab,
or (daring alert!):
user types the chosen Math/Stats fxs
in the "Filter in any column field",
as comma-sep entries:
ie:
SUM, MAX, Min, AVERAGE, MEDIAN, MODE, Q1, Q3, etc.

Anyhow,
you guys deserve my greatest admiration
for your work!.
Very useful, clear and simple to use.

SFd
San Francisco
DB Browser for SQLite 3.12.2
Ubuntu LINUX 20.04
R, Rstudio

Irene Steves: Using SQL in Rstudio
https://irene.rbind.io/post/using-sql-in-rstudio/

above image credit to Ana Milana:
https://anamilana.com/how-to-start-practising-sql-for-data-analysis/
(using DB Browser SQLite, of course!).