Your code for pushing data is fine. The produced data are correct:
"measurement","tags","fields","time"
"measurement1","{'Tag1' : ""tag"", 'Tag2' : ""tag2"" }","{""Apple"": 11, ""Banana"": 12,""Grapes"": 13, ""Orange"": 14}",1653029005621
"measurement2","{'Tag1' : ""tag"", 'Tag2' : ""tag2"" }","{""Potato"": 11, ""Cucumber"": 12,""Onion"": 13, ""Carrot"": 14}",1653029005622
"measurement1","{'Tag1' : ""tag"", 'Tag2' : ""tag2"" }","{""Apple"": 11, ""Banana"": 12,""Grapes"": 13, ""Orange"": 14}",1653029005623
"measurement2","{'Tag1' : ""tag"", 'Tag2' : ""tag2"" }","{""Potato"": 11, ""Cucumber"": 12,""Onion"": 13, ""Carrot"": 14}",1653029005624
"measurement1","{'Tag1' : ""tag"", 'Tag2' : ""tag2"" }","{""Apple"": 11, ""Banana"": 12,""Grapes"": 13, ""Orange"": 14}",1653029005625
"measurement2","{'Tag1' : ""tag"", 'Tag2' : ""tag2"" }","{""Potato"": 11, ""Cucumber"": 12,""Onion"": 13, ""Carrot"": 14}",1653029005626
import json
import pandas as pd
dataframe = pd.read_csv('demo.csv')
data = dataframe.to_json(orient='records')
sensor_data = json.loads(data)
sensor_list = []
for item in sensor_data:
sensor_list.append(
{
'measurement': item['measurement'],
'tags': eval(item['tags']),
'fields': eval(item['fields']),
'time': item['time']
}
)
print(sensor_list)
[
{'measurement': 'measurement1', 'tags': {'Tag1': 'tag', 'Tag2': 'tag2'}, 'fields': {'Apple': 11, 'Banana': 12, 'Grapes': 13, 'Orange': 14}, 'time': 1653029005621},
{'measurement': 'measurement2', 'tags': {'Tag1': 'tag', 'Tag2': 'tag2'}, 'fields': {'Potato': 11, 'Cucumber': 12, 'Onion': 13, 'Carrot': 14}, 'time': 1653029005622},
{'measurement': 'measurement1', 'tags': {'Tag1': 'tag', 'Tag2': 'tag2'}, 'fields': {'Apple': 11, 'Banana': 12, 'Grapes': 13, 'Orange': 14}, 'time': 1653029005623},
{'measurement': 'measurement2', 'tags': {'Tag1': 'tag', 'Tag2': 'tag2'}, 'fields': {'Potato': 11, 'Cucumber': 12, 'Onion': 13, 'Carrot': 14}, 'time': 1653029005624},
{'measurement': 'measurement1', 'tags': {'Tag1': 'tag', 'Tag2': 'tag2'}, 'fields': {'Apple': 11, 'Banana': 12, 'Grapes': 13, 'Orange': 14}, 'time': 1653029005625},
{'measurement': 'measurement2', 'tags': {'Tag1': 'tag', 'Tag2': 'tag2'}, 'fields': {'Potato': 11, 'Cucumber': 12, 'Onion': 13, 'Carrot': 14}, 'time': 1653029005626}
]
How do you check your data?