AgspStream

Agriscope data interface for python

This module allows to get data from yours Agribases programmatically Data are retreived as an Pandas Datagrams

The development map will introduce data computing capabilities, to enhance data analysis comming from agricultural field.

What's New

• (2023/05) v2.0.12 : - syntax error correction when something dirty is coming
• (2022/09) v2.0.10 : - add excluded_virtual_types_pattern to exclude some virtual on demand - Add some robust thing agains dirty event (DST switch, sensor id move)
• (2022/09) v2.0.9 : Use Https
• (2022/01) v2.0.8 : Bug correction in logger
• (2022/01) v2.0.7 : Add a retry API when something wrong seems to be there
• (2022/01) v2.0.6 : Improve capabilities to select virtual datasources to update
• (2022/01) v2.0.0 : Add capabilities to get virtual datasources
• (2021/06) v1.0.4 : Again optimize exception reporting when server is not joinable
• (2021/06) v1.0.3 : Optimize exception reporting when server is not joinable
• (2021/03) v1.0.2 : Optimize sensor data retrieving
• (2020/09) v0.0.13 : Better support of module and sensor position
• (2020/01) v0.0.12 : export some internals methods
• (2019/09) v0.0.10 : solve some display problems
• (2019/08) Porting to python 3
• (2018/05) Add functionnal information on Agribases (type, sampling)
• (2018/05) Solve bug on from, to date
• (2018/02) First version

Dependencies

Agstream is written to be use with python 3 It requires Pandas (>= 0.12.0)::

pip install pandas

Installations

pip install agstream

Uses cases

code :

from agstream.session import AgspSession
session = AgspSession()
session.login("masnumeriqueAgStream", "1AgStream", updateAgribaseInfo=True)
session.describe()
for abs in session.agribases :
    print ("****************************************")
    print (abs)
    df = session.getAgribaseDataframe(abs)
    print (df.tail())
print("Fin du programme")

Output :

**************************************************
* Example 1 :  simplest way to get data
* get the data, and feed an xlsfile
**************************************************
****************************************
Compteur Mourvedre Rang 9(2301) AGRIBASE3S_STC SIGFOX containing 3 sensors
Récuperation de 864 données
						compteur d'eau  alimentation #4  humectation foliaire
2021-03-28 14:18:28+02:00             0.0            3.312                   0.0
2021-03-28 14:33:29+02:00             0.0            3.316                   0.0
2021-03-28 14:48:29+02:00             0.0            3.318                   0.0
2021-03-28 15:03:29+02:00             0.0            3.314                   0.0
2021-03-28 15:18:29+02:00             0.0            3.310                   0.0
Ecriture des  données dans le fichier Compteur Mourvedre Rang 9.xlsx
****************************************
Debitmetre Grenache Rang 10(2299) AGRIBASE3S_STC SIGFOX containing 3 sensors
Récuperation de 39 données
						humectation foliaire  compteur d'eau  alimentation #4
2021-03-31 11:07:31+02:00                   0.0             0.0            0.000
2021-03-31 11:22:20+02:00                   0.0             0.0            3.298
2021-03-31 11:37:20+02:00                   0.0             0.0            3.299
2021-03-31 11:52:20+02:00                   0.0             0.0            3.298
2021-03-31 12:07:20+02:00                   0.0             0.0            3.301
Ecriture des  données dans le fichier Debitmetre Grenache Rang 10.xlsx	

Code for UTC:

from agstream.session import AgspSession
session = AgspSession(timezoneName='UTC')
session.login("masnumeriqueAgStream", "1AgStream", updateAgribaseInfo=True)
session.describe()
for abs in session.agribases :
    print ("****************************************")
    print (abs)
    df = session.getAgribaseDataframe(abs)
    print (df.tail())
print("Fin du programme")

Output :

**************************************************
* Example 1 :  simplest way to get data
* get the data, and feed an xlsfile
**************************************************
****************************************
Compteur Mourvedre Rang 9(2301) AGRIBASE3S_STC SIGFOX containing 3 sensors
Récuperation de 864 données
						compteur d'eau  alimentation #4  humectation foliaire
2021-03-28 12:18:28+00:00             0.0            3.312                   0.0
2021-03-28 12:33:29+00:00             0.0            3.316                   0.0
2021-03-28 12:48:29+00:00             0.0            3.318                   0.0
2021-03-28 13:03:29+00:00             0.0            3.314                   0.0
2021-03-28 13:18:29+00:00             0.0            3.310                   0.0
Ecriture des  données dans le fichier Compteur Mourvedre Rang 9.xlsx
****************************************
Debitmetre Grenache Rang 10(2299) AGRIBASE3S_STC SIGFOX containing 3 sensors
Récuperation de 39 données
						humectation foliaire  compteur d'eau  alimentation #4
2021-03-31 09:07:31+00:00                   0.0             0.0            0.000
2021-03-31 09:22:20+00:00                   0.0             0.0            3.298
2021-03-31 09:37:20+00:00                   0.0             0.0            3.299
2021-03-31 09:52:20+00:00                   0.0             0.0            3.298
2021-03-31 10:07:20+00:00                   0.0             0.0            3.301
Ecriture des  données dans le fichier Debitmetre Grenache Rang 10.xlsx