Re: [Therion] Statistics on surveys of a network

[Martin Sluka via Therion]

#!/usr/bin/env python3
# -*- coding: utf-8 -*-

# grab data to generate summary for surveys of a cave network

import sqlite3
import pandas as pd
import numpy as np

conn = sqlite3.connect(':memory:')
conn.executescript(open('cave.sql').read())
stats = open('survey_stats.dat','w')

# sql to panda
surv = pd.read_sql_query('select ID, NAME from SURVEY', conn)
surv = surv[surv.NAME  != ''] # drop empty survey names
ctli = pd.read_sql_query('select ID, SURVEY_ID, TOPO_DATE, LENGTH from 
CENTRELINE', conn)
ctli = ctli.dropna() # drop empty date centerlines
topo = pd.read_sql_query('select PERSON_ID, CENTRELINE_ID from TOPO', conn)
team = pd.read_sql_query('select ID, NAME, SURNAME from PERSON', conn)
team = team.drop_duplicates()
team = team.to_numpy()

#iterate over surveys
for index, s in surv.iterrows():
    print(s.NAME)
    stats.write('%s\n'%(s.NAME))
        
    for index, c in ctli.iterrows():
        if (c.SURVEY_ID == s.ID) :
                print('      date   ',c.TOPO_DATE)
                stats.write('      date   %s\n'%(c.TOPO_DATE))
                print('      length ',c.LENGTH)
                stats.write('      length %s\n'%(c.LENGTH))
                for index, t in topo.iterrows():
                        if (t.CENTRELINE_ID == c.ID) :
                                name = team[team[:,0] == t.PERSON_ID]
                                print ('                 {} 
{}'.format(name[0,1],name[0,2]))
                                stats.write('                 {} 
{}\n'.format(name[0,1],name[0,2]))
    
stats.close()

Odesláno z iPhonu

> 10. 5. 2023 v 12:05, Bruce Mutton <br...@tomo.co.nz>:
> 
> MS Outlook blocks attachments with extension .py
> Perhaps you can repost after changing the extension to .txt?
> Thanks
> Bruce
> 
> 
> -----Original Message-----
> From: Therion <therion-boun...@speleo.sk> On Behalf Of Philippe Vernant
> Sent: Wednesday, 10 May 2023 20:54
> To: List for Therion users <therion@speleo.sk>
> Subject: Re: [Therion] Statistics on surveys of a network
> 
> Hi guys,
> 
> Thanks for the answers. I wrote a python script. It is far from being
> elegant but it does the job. I attach it to this message in case it can be
> helpful to some of you.
> 
> Cheers,
> Phil
> 
> 
> 
> _______________________________________________
> Therion mailing list
> Therion@speleo.sk
> https://mailman.speleo.sk/listinfo/therion
_______________________________________________
Therion mailing list
Therion@speleo.sk
https://mailman.speleo.sk/listinfo/therion