pandas write client does not work

[cosmo86]

Steps to reproduce:
List the minimal actions needed to reproduce the behavior.

1. ...using window11, intel 12th gen, Python 3.9.7
2. ...
   import h5py
   import numpy as np
   import matplotlib.pyplot as plt
   import pandas as pd
   import tables

dataframe look like this

using the official tutorial : replacing the _data_frame with my own df shown in the last step

3. ...

Expected behavior:
Describe what you expected to happen.
expect the data to be written to the influxdb
Actual behavior:
Describe What actually happened.
nothing get written, the measurment wont even be created either, no error returnd to jupyter notebook console
Specifications:

• Client Version:
• InfluxDB Version:2.x
• Platform:python

[cosmo86]

add:
I am new to database, so sorry if the question is stupid
thanks for the help

[bednar]

Hi @cosmo86,

thanks for using our client.

For the jupyter notebook will be better to use synchronous write API. Try to change initialisation of the WriteApi to:

from influxdb_client import InfluxDBClient
from influxdb_client.client.write_api import SYNCHRONOUS

with InfluxDBClient(url="http://localhost:8086", token="my-token", org="my-org", debug=False) as client:
    write_api = client.write_api(write_options=SYNCHRONOUS)

For more info see:

• https://influxdb-client.readthedocs.io/en/stable/usage.html#synchronous-client
• https://influxdb-client.readthedocs.io/en/stable/usage.html#write

[cosmo86]

Hi @bednar
I just tried using your suggestion, but the issue still exist:

the notebook cell seems excuted the code just fine:

but there is nothing in the database: i have refreshed the page

[bednar]

Your timestamp is 1970-08-22 .... Do you have correct time range in InfluxDB UI?

[cosmo86]

@bednar
like I said, I am stupid.
thanks for answering my question. I will close this issue.
If you dont mind, can i ask you another question?

Is aggregate function mandatory for displaying data in the UI?
Could I just display a column value VS the timestamp?

[bednar]

Is aggregate function mandatory for displaying data in the UI? Could I just display a column value VS the timestamp?

You can switch to Query Builder and use your custom query:

[cosmo86]

@bednar thanks a lot!