Check for existing data before writing to database
My goal is, when writing time series data from a pandas dataframe to an InfluxDB bucket, to check whether a specific row of data already exists in the bucket (and thus prevent data from being written again).
unable to set specific timestamp for data points in Influxdb using Python
import pandas as pd from influxdb_client import InfluxDBClient, Point, WriteOptions import influxdb_client, os from influxdb_client.client.write_api import SYNCHRONOUS, WritePrecision from dotenv import dotenv_values # Environment variables token = dotenv_values(“.env”)[“INFLUXDB_TOKEN”] #configurations org = “Aquilo” url = “http://localhost:8086” # Initialize the InfluxDB client write_client = InfluxDBClient(url=url, token=token, org=org) # Load the dataset file_path = “steamData sales.xlsx” steam_data = […]