In [1]:
import argparse
import pandas as pd
from influxdb import DataFrameClient
In [9]:
host="172.18.8.180"
port=8086
user = 'root'
password = 'root'
dbname = 'demo'
# Temporarily avoid line protocol time conversion issues #412, #426, #431.
protocol = 'json'
client = DataFrameClient(host, port, user, password, dbname)
number=4000
df = pd.read_csv(r"C:\dev\repos\software-data\projects\buschmais-spring-petclinic-joa\git_log_refactoring.log")
df['timestamp'] = pd.to_datetime(df['timestamp'])
df = df.set_index('timestamp')
df.head()
Out[9]:
additions
deletions
file
timestamp
2017-12-31 19:41:29
19
0
src/main/java/org/springframework/samples/petc...
2017-12-30 12:48:20
55
0
src/main/java/org/springframework/samples/petc...
2017-12-30 12:48:20
29
0
src/main/java/org/springframework/samples/petc...
2017-12-30 00:38:54
0
99
src/main/java/org/springframework/samples/petc...
2017-12-30 00:38:54
19
0
src/main/java/org/springframework/samples/petc...
In [10]:
#client.create_database(dbname)
client.write_points(df, 'demo', protocol=protocol)
Out[10]:
True
In [13]:
d = client.query("select * from demo")
pd.DataFrame(d['demo'])
Out[13]:
additions
counter
deletions
file
2013-05-15 03:35:33+00:00
250.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2013-05-15 17:36:46+00:00
38.0
NaN
0.0
src/test/java/org/springframework/samples/petc...
2013-05-16 02:15:44+00:00
50.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2013-05-16 22:05:34+00:00
194.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2013-05-17 15:12:26+00:00
78.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2013-05-17 19:27:07+00:00
30.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2013-05-20 06:28:34+00:00
0.0
NaN
55.0
src/main/java/org/springframework/samples/petc...
2013-05-21 03:46:00+00:00
8.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2013-05-22 04:28:55+00:00
20.0
NaN
0.0
src/test/java/org/springframework/samples/petc...
2013-05-24 01:26:10+00:00
116.0
NaN
0.0
src/test/java/org/springframework/samples/petc...
2013-05-24 05:52:31+00:00
142.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2013-05-25 01:04:34+00:00
0.0
NaN
116.0
src/main/java/org/springframework/samples/petc...
2013-05-27 18:44:05+00:00
89.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2013-05-28 04:51:48+00:00
78.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2013-05-28 08:15:35+00:00
123.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2013-05-29 09:18:45+00:00
0.0
NaN
18.0
src/main/java/org/springframework/samples/petc...
2013-05-29 15:41:48+00:00
4.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2013-05-30 14:06:02+00:00
77.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2013-05-30 16:11:41+00:00
28.0
NaN
0.0
src/test/java/org/springframework/samples/petc...
2013-05-31 08:23:07+00:00
0.0
NaN
36.0
src/main/java/org/springframework/samples/petc...
2013-06-03 10:58:12+00:00
24.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2013-06-03 18:03:44+00:00
0.0
NaN
112.0
src/main/java/org/springframework/samples/petc...
2013-06-04 07:31:37+00:00
0.0
NaN
39.0
src/main/java/org/springframework/samples/petc...
2013-06-05 18:44:45+00:00
0.0
NaN
103.0
src/test/java/org/springframework/samples/petc...
2013-06-06 04:09:05+00:00
71.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2013-06-06 19:22:39+00:00
36.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2013-06-07 19:50:43+00:00
0.0
NaN
143.0
src/test/java/org/springframework/samples/petc...
2013-06-07 21:23:27+00:00
52.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2013-06-10 13:39:25+00:00
46.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2013-06-10 17:17:14+00:00
0.0
NaN
178.0
src/main/java/org/springframework/samples/petc...
...
...
...
...
...
2017-12-04 23:24:16+00:00
0.0
NaN
14.0
src/main/java/org/springframework/samples/petc...
2017-12-05 20:22:58+00:00
0.0
NaN
113.0
src/main/java/org/springframework/samples/petc...
2017-12-06 12:32:31+00:00
0.0
NaN
10.0
src/main/java/org/springframework/samples/petc...
2017-12-07 03:57:11+00:00
0.0
NaN
93.0
src/main/java/org/springframework/samples/petc...
2017-12-07 14:52:26+00:00
184.0
NaN
0.0
src/test/java/org/springframework/samples/petc...
2017-12-08 04:48:14+00:00
0.0
NaN
35.0
src/main/java/org/springframework/samples/petc...
2017-12-08 19:15:09+00:00
55.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2017-12-09 21:24:52+00:00
0.0
NaN
43.0
src/main/java/org/springframework/samples/petc...
2017-12-12 02:20:20+00:00
142.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2017-12-12 14:23:26+00:00
0.0
NaN
27.0
src/main/java/org/springframework/samples/petc...
2017-12-13 10:42:31+00:00
0.0
NaN
66.0
src/main/java/org/springframework/samples/petc...
2017-12-14 08:39:41+00:00
0.0
NaN
0.0
src/test/java/org/springframework/samples/petc...
2017-12-16 02:48:37+00:00
0.0
NaN
82.0
src/main/java/org/springframework/samples/petc...
2017-12-16 19:40:46+00:00
33.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2017-12-18 18:25:42+00:00
5.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2017-12-19 12:58:43+00:00
0.0
NaN
71.0
src/test/java/org/springframework/samples/petc...
2017-12-20 13:55:28+00:00
18.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2017-12-21 04:32:42+00:00
0.0
NaN
42.0
src/main/java/org/springframework/samples/petc...
2017-12-21 20:55:48+00:00
35.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2017-12-22 16:14:34+00:00
46.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2017-12-23 10:08:01+00:00
85.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2017-12-25 01:27:16+00:00
27.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2017-12-26 00:29:48+00:00
0.0
NaN
30.0
src/main/java/org/springframework/samples/petc...
2017-12-26 04:57:46+00:00
121.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2017-12-27 10:57:35+00:00
142.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2017-12-28 20:38:05+00:00
0.0
NaN
110.0
src/main/java/org/springframework/samples/petc...
2017-12-29 15:28:42+00:00
0.0
NaN
47.0
src/main/java/org/springframework/samples/petc...
2017-12-30 00:38:54+00:00
261.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2017-12-30 12:48:20+00:00
29.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
2017-12-31 19:41:29+00:00
19.0
NaN
0.0
src/main/java/org/springframework/samples/petc...
6220 rows × 4 columns
Content source: feststelltaste/software-analytics
Similar notebooks: