How to insert data into Influxdb from CSV file

Question

I wanted to insert data from a CSV file to Influxdb. I have tried the below Python script. It was successful, but I want it to be inserted at particular time (I have a column in which date is specified).

import pandas as pd
from influxdb import InfluxDBClient

client = InfluxDBClient(host='localhost', port=8086)
client.switch_database('databse_name')

file_path = r'file_name.csv'

csvReader = pd.read_csv(file_path)

print(csvReader.shape)
print(csvReader.columns)

for row_index, row in csvReader.iterrows() : 
    tags = row[1]
    #fieldvalue = row[2]
    json_body = [
        {
            "measurement": "Measurement_name",
            "tags": {
                        "Tag_name1": tags
                    },
            "fields": {
                        "Field1": row[2],
                        "Field2": row[3], 
                        "Field3": row[4]
                        }
        }
    ]
    client.write_points(json_body)

Jan Garaj · Accepted Answer · 2020-06-20 15:06:11Z

2

Specify time in the json_body:

json_body = [{
    "time": "<datetime, e.g. 2020-05-02T17:30:45Z>",
    "measurement": "Measurement_name",
    "tags": {
        "Tag_name1": tags
    },
    "fields": {
        "Field1": row[2],
        "Field2": row[3],
        "Field3": row[4]
    }
}]

answered Jun 20, 2020 at 15:06

Jan Garaj

29k3 gold badges49 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to insert data into Influxdb from CSV file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related