How to export InfluxDB database for data analysis in python on external computer

Configuration
1

Dear all,

I am currently logging temperature/humidity/pressure data into an influxdb database and visualising them with grafana.
I would like to use these timeseries for some data analysis and machine learning with python on my computer. Therefore I was looking for possible ways of exporting the data within influxdb to an external computer or drive.
I was assuming to be a straightforward process but my research on google were fruitless so far…

Does anyone have suggestion? Am I logging my data into a sort of sink hole??

I am running Home Assistant Operating System on rpi4.

KR,
ilMitch

2

Use their REST interface, maybe?

https://docs.influxdata.com/influxdb/v1.7/guides/querying_data/

3

You can use influxdb-client: https://github.com/influxdata/influxdb-client-python

4

I have published some sample Python files that show how to read the InfluxDB database
through the IP connection to Home Assistant and get the data onto another computer.
It uses the version 1 API with influxdb (pip install influxdb), not influxdb-client.
Home Assistant InfluxDB seems to be version 1.8.10 as of this writing,
so authentication is by username and password, not tokens.

The files are on github.com. Sample Python code showing how to read values from an InfluxDB running on Home Assistant is provided. Also, code to write the readings from an entity_id into a file, and to plot the data, are provided.