select avg( colname) from table;

https://stackoverflow.com/questions/797053/sqlite-how-to-get-average-value

example def get_eta(self,_api): _api = _api.replace('/','_') db = sqlite3.connect('etas/eta_{0}.db'.format(_api)) c = db.cursor() c.execute(''' SELECT count(name) FROM sqlite_master WHERE type='table' AND name='eta' ''') if not c.fetchone()[0]: db.close() return 0 else: c.execute("""SELECT avg(eta) FROM eta""") r = c.fetchone()[0] db.close() return r 21.11.19

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024