查看InfluxDB Quick Start的源代码
←
InfluxDB Quick Start
跳转到:
导航
,
搜索
因为以下原因,你没有权限编辑本页:
您刚才请求的操作只有这个用户组中的用户才能使用:
用户
您可以查看并复制此页面的源代码:
== Python Notes == <source lang=bash> $ pip install influxdb $ pip install --upgrade influxdb $ pip uninstall influxdb </source> On Debian/Ubuntu, you can install it with this command: <source lang=bash> $ sudo apt-get install python3-influxdb </source> * http://influxdb-python.readthedocs.io/en/latest/api-documentation.html#influxdb.InfluxDBClient.write_points <source lang=python> #!/usr/bin/python import datetime from influxdb import client as influxdb db = influxdb.InfluxDBClient('localhost', 8086, '', '', 'mydb') def read_data(): with open('quark.csv') as f: return [x.split(',') for x in f.readlines()[1:]] a = read_data() for metric in a: influx_metric = [{ 'measurement': 'quark', 'time': datetime.datetime.utcfromtimestamp(int(metric[1])/1000/1000/1000).isoformat(), 'fields': { 'Alt': float(metric[2]), 'CO2': float(metric[3]), 'Humi': float(metric[4]), 'Lat': float(metric[5]), 'Light': float(metric[6]), 'Lon': float(metric[7]), 'Press': float(metric[8]), 'RSSI': int(metric[9]), 'SNR': int(metric[10]), 'Temp': float(metric[11]), 'Vbat': float(metric[12]) }, 'tags': { 'dev_id': metric[13][:-1] } }] #print influx_metric db.write_points(influx_metric) </source> '''Old does not work now:''' <source lang=python> $ python Python 2.7.14 (default, Sep 23 2017, 22:06:14) >>> import pandas as pd >>> d=pd.read_csv('test.csv', date_parser=lambda x: pd.to_datetime(float(x)), index_col='time') >>> d=d.drop(columns=['name']) >>> d Humi Temp dev_id mac time 2018-05-13 07:45:29 39.3 27.0 NOD78783243232 AABBCCDDEEFF 2018-05-13 09:12:18 39.3 26.9 NOD78783243232 AABBCCDDEEFF 2018-05-13 09:21:30 39.4 26.9 NOD78783243232 AABBCCDDEEFF 2018-05-13 09:21:38 39.4 26.9 NOD78783243232 AABBCCDDEEFF 2018-05-13 09:21:43 39.4 26.9 NOD78783243232 AABBCCDDEEFF >>> from influxdb import DataFrameClient >>> client = DataFrameClient(host='127.0.0.1', port=8086, database='mydb') >>> client.write_points(d, 'test', tag_columns=['dev_id','mac'] True </source> * https://www.influxdata.com/blog/writing-data-to-influxdb-with-python/ <br><br>
返回到
InfluxDB Quick Start
。
个人工具
登录
名字空间
页面
讨论
变换
查看
阅读
查看源代码
查看历史
操作
搜索
导航
首页
社区专页
新闻动态
最近更改
随机页面
帮助
工具箱
链入页面
相关更改
特殊页面