Kernel: Python 3 (Ubuntu Linux)
In [3]:
In [0]:
In [4]:
['.bash_profile',
'.jupyter-blobs-v0.db',
'raw.csv',
'.Untitled.ipynb.sage-jupyter2',
'.sage',
'.config',
'.cache',
'Untitled.ipynb',
'.smc',
'.ssh',
'.local',
'.bashrc',
'.ipython',
'.snapshots']
In [5]:
In [6]:
Date | Serial | RawValue | |
---|---|---|---|
0 | 2018-02-05T13:33:16.014912-05:00 | 28-000006794411 | 22187 |
1 | 2018-02-05T13:33:31.014395-05:00 | 28-000006794411 | 22187 |
2 | 2018-02-05T13:33:46.014433-05:00 | 28-000006794411 | 22187 |
3 | 2018-02-05T13:34:01.001281-05:00 | 28-000006794411 | 22187 |
4 | 2018-02-05T13:34:16.014052-05:00 | 28-000006794411 | 22187 |
In [7]:
Date | Serial | RawValue | |
---|---|---|---|
37118 | 2018-02-08T00:32:35.814453-05:00 | 28-00000220db9f | 36250 |
37119 | 2018-02-08T00:31:49.894421-05:00 | 28-000008ab5383 | 34312 |
37120 | 2018-02-08T00:32:04.934432-05:00 | 28-000008ab5383 | 34187 |
37121 | 2018-02-08T00:32:19.894856-05:00 | 28-000008ab5383 | 34125 |
37122 | 2018-02-08T00:32:34.934434-05:00 | 28-000008ab5383 | 34062 |
In [8]:
Date | Serial | |
---|---|---|
count | 37123 | 37123 |
unique | 37123 | 4 |
top | 2018-02-07T22:39:20.774438-05:00 | 10-000802b68231 |
freq | 1 | 10608 |
In [9]:
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 37123 entries, 0 to 37122
Data columns (total 3 columns):
Date 37123 non-null object
Serial 37123 non-null object
RawValue 37123 non-null int64
dtypes: int64(1), object(2)
memory usage: 870.1+ KB
0 28-000006794411
1 28-000006794411
2 28-000006794411
3 28-000006794411
4 28-000006794411
5 28-000006794411
6 28-000006794411
7 28-000006794411
8 28-000006794411
9 28-000006794411
10 28-000006794411
11 28-000006794411
12 28-000006794411
13 28-000006794411
14 28-000006794411
15 28-000006794411
16 28-000006794411
17 28-000006794411
18 28-000006794411
19 28-000006794411
20 28-000006794411
21 28-000006794411
22 28-000006794411
23 28-000006794411
24 28-000006794411
25 28-000006794411
26 28-000006794411
27 28-000006794411
28 28-000006794411
29 28-000006794411
...
37093 28-00000220db9f
37094 28-00000220db9f
37095 28-000008ab5383
37096 28-000008ab5383
37097 28-000008ab5383
37098 28-000008ab5383
37099 10-000802b68231
37100 10-000802b68231
37101 10-000802b68231
37102 10-000802b68231
37103 28-00000220db9f
37104 28-00000220db9f
37105 28-00000220db9f
37106 28-00000220db9f
37107 28-000008ab5383
37108 28-000008ab5383
37109 28-000008ab5383
37110 28-000008ab5383
37111 10-000802b68231
37112 10-000802b68231
37113 10-000802b68231
37114 10-000802b68231
37115 28-00000220db9f
37116 28-00000220db9f
37117 28-00000220db9f
37118 28-00000220db9f
37119 28-000008ab5383
37120 28-000008ab5383
37121 28-000008ab5383
37122 28-000008ab5383
Name: Serial, Length: 37123, dtype: object
In [10]:
In [11]:
' 10-000802b68231'
In [12]:
0 10-000802b68231
1 28-00000220db9f
2 28-000006794411
3 28-000008ab5383
Name: Serial, dtype: object
In [13]:
In [22]:
index | Date | RawValue | DateTime | |
---|---|---|---|---|
0 | 224 | 2018-02-05T16:16:02.875448-05:00 | 19875 | 2018-02-05 21:16:02.875448 |
1 | 225 | 2018-02-05T16:16:17.915357-05:00 | 19875 | 2018-02-05 21:16:17.915357 |
2 | 226 | 2018-02-05T16:16:32.996151-05:00 | 19875 | 2018-02-05 21:16:32.996151 |
3 | 227 | 2018-02-05T16:16:47.915447-05:00 | 19875 | 2018-02-05 21:16:47.915447 |
4 | 236 | 2018-02-05T16:17:02.875560-05:00 | 19875 | 2018-02-05 21:17:02.875560 |
In [0]:
In [0]:
In [0]:
In [24]:
In [15]:
In [16]:
In [17]:
In [18]:
In [19]:
Timestamp('2018-02-05 21:24:15.926087')
In [20]:
Timestamp('2018-02-07 03:00:04.012627')
In [21]:
---------------------------------------------------------------------------
NameError Traceback (most recent call last)
<ipython-input-21-e983f374794d> in <module>()
----> 1 d
NameError: name 'd' is not defined
In [0]:
In [0]: