In [40]:
import numpy as np
import pandas as pd
import cec_utils as ut
from sklearn.cluster import KMeans
import matplotlib.pyplot as plt
%matplotlib inline
In [2]:
eng = ut.dbconfig(ut.user, ut.passwd, ut.dbname)
rawTreeCounts = pd.read_sql('select ceil(dead_trees_acre)::int dt_ac from lemmav2.lemma_total limit 100000', eng)
In [7]:
reload(ut)
Out[7]:
<module 'cec_utils' from 'cec_utils.py'>
In [40]:
rawTre
Out[40]:
dt_ac 20.310265
dtype: float64
In [8]:
ut.clusterFRCSVariable(rawTreeCounts)
Out[8]:
array([[ 6.65790723],
[ 48.07872079],
[ 122.90740741],
[ 21.99254261]])
In [ ]:
ut.clusterFRCSVariable(rawTreeCounts)
In [44]:
runs = pd.read_pickle("Runsfrcs")
runs
Out[44]:
C
D
E
F
H
J
A
B
G
I
K
0
11.433349
1.0
1.000000
0
48
3.706521
frcs_batch_0
CA
Ground-Based Mech WT
0.8
60
1
11.433349
1.0
1.000000
0
48
141.722174
frcs_batch_1
CA
Ground-Based Mech WT
0.8
60
2
11.433349
1.0
1.000000
0
48
10.744726
frcs_batch_2
CA
Ground-Based Mech WT
0.8
60
3
11.433349
1.0
1.000000
0
48
1.150027
frcs_batch_3
CA
Ground-Based Mech WT
0.8
60
4
11.433349
1.0
1.000000
0
2003
3.706521
frcs_batch_4
CA
Ground-Based Mech WT
0.8
60
5
11.433349
1.0
1.000000
0
2003
141.722174
frcs_batch_5
CA
Ground-Based Mech WT
0.8
60
6
11.433349
1.0
1.000000
0
2003
10.744726
frcs_batch_6
CA
Ground-Based Mech WT
0.8
60
7
11.433349
1.0
1.000000
0
2003
1.150027
frcs_batch_7
CA
Ground-Based Mech WT
0.8
60
8
11.433349
1.0
1.000000
0
142
3.706521
frcs_batch_8
CA
Ground-Based Mech WT
0.8
60
9
11.433349
1.0
1.000000
0
142
141.722174
frcs_batch_9
CA
Ground-Based Mech WT
0.8
60
10
11.433349
1.0
1.000000
0
142
10.744726
frcs_batch_10
CA
Ground-Based Mech WT
0.8
60
11
11.433349
1.0
1.000000
0
142
1.150027
frcs_batch_11
CA
Ground-Based Mech WT
0.8
60
12
11.433349
1.0
1.000000
0
6
3.706521
frcs_batch_12
CA
Ground-Based Mech WT
0.8
60
13
11.433349
1.0
1.000000
0
6
141.722174
frcs_batch_13
CA
Ground-Based Mech WT
0.8
60
14
11.433349
1.0
1.000000
0
6
10.744726
frcs_batch_14
CA
Ground-Based Mech WT
0.8
60
15
11.433349
1.0
1.000000
0
6
1.150027
frcs_batch_15
CA
Ground-Based Mech WT
0.8
60
16
11.433349
1.0
7.333333
0
48
3.706521
frcs_batch_16
CA
Ground-Based Mech WT
0.8
60
17
11.433349
1.0
7.333333
0
48
141.722174
frcs_batch_17
CA
Ground-Based Mech WT
0.8
60
18
11.433349
1.0
7.333333
0
48
10.744726
frcs_batch_18
CA
Ground-Based Mech WT
0.8
60
19
11.433349
1.0
7.333333
0
48
1.150027
frcs_batch_19
CA
Ground-Based Mech WT
0.8
60
20
11.433349
1.0
7.333333
0
2003
3.706521
frcs_batch_20
CA
Ground-Based Mech WT
0.8
60
21
11.433349
1.0
7.333333
0
2003
141.722174
frcs_batch_21
CA
Ground-Based Mech WT
0.8
60
22
11.433349
1.0
7.333333
0
2003
10.744726
frcs_batch_22
CA
Ground-Based Mech WT
0.8
60
23
11.433349
1.0
7.333333
0
2003
1.150027
frcs_batch_23
CA
Ground-Based Mech WT
0.8
60
24
11.433349
1.0
7.333333
0
142
3.706521
frcs_batch_24
CA
Ground-Based Mech WT
0.8
60
25
11.433349
1.0
7.333333
0
142
141.722174
frcs_batch_25
CA
Ground-Based Mech WT
0.8
60
26
11.433349
1.0
7.333333
0
142
10.744726
frcs_batch_26
CA
Ground-Based Mech WT
0.8
60
27
11.433349
1.0
7.333333
0
142
1.150027
frcs_batch_27
CA
Ground-Based Mech WT
0.8
60
28
11.433349
1.0
7.333333
0
6
3.706521
frcs_batch_28
CA
Ground-Based Mech WT
0.8
60
29
11.433349
1.0
7.333333
0
6
141.722174
frcs_batch_29
CA
Ground-Based Mech WT
0.8
60
...
...
...
...
...
...
...
...
...
...
...
...
994
82.513182
2500.0
13.666667
0
48
10.744726
frcs_batch_994
CA
Cable Manual WT
0.8
60
995
82.513182
2500.0
13.666667
0
48
1.150027
frcs_batch_995
CA
Cable Manual WT
0.8
60
996
82.513182
2500.0
13.666667
0
2003
3.706521
frcs_batch_996
CA
Cable Manual WT
0.8
60
997
82.513182
2500.0
13.666667
0
2003
141.722174
frcs_batch_997
CA
Cable Manual WT
0.8
60
998
82.513182
2500.0
13.666667
0
2003
10.744726
frcs_batch_998
CA
Cable Manual WT
0.8
60
999
82.513182
2500.0
13.666667
0
2003
1.150027
frcs_batch_999
CA
Cable Manual WT
0.8
60
1000
82.513182
2500.0
13.666667
0
142
3.706521
frcs_batch_1000
CA
Cable Manual WT
0.8
60
1001
82.513182
2500.0
13.666667
0
142
141.722174
frcs_batch_1001
CA
Cable Manual WT
0.8
60
1002
82.513182
2500.0
13.666667
0
142
10.744726
frcs_batch_1002
CA
Cable Manual WT
0.8
60
1003
82.513182
2500.0
13.666667
0
142
1.150027
frcs_batch_1003
CA
Cable Manual WT
0.8
60
1004
82.513182
2500.0
13.666667
0
6
3.706521
frcs_batch_1004
CA
Cable Manual WT
0.8
60
1005
82.513182
2500.0
13.666667
0
6
141.722174
frcs_batch_1005
CA
Cable Manual WT
0.8
60
1006
82.513182
2500.0
13.666667
0
6
10.744726
frcs_batch_1006
CA
Cable Manual WT
0.8
60
1007
82.513182
2500.0
13.666667
0
6
1.150027
frcs_batch_1007
CA
Cable Manual WT
0.8
60
1008
82.513182
2500.0
20.000000
0
48
3.706521
frcs_batch_1008
CA
Cable Manual WT
0.8
60
1009
82.513182
2500.0
20.000000
0
48
141.722174
frcs_batch_1009
CA
Cable Manual WT
0.8
60
1010
82.513182
2500.0
20.000000
0
48
10.744726
frcs_batch_1010
CA
Cable Manual WT
0.8
60
1011
82.513182
2500.0
20.000000
0
48
1.150027
frcs_batch_1011
CA
Cable Manual WT
0.8
60
1012
82.513182
2500.0
20.000000
0
2003
3.706521
frcs_batch_1012
CA
Cable Manual WT
0.8
60
1013
82.513182
2500.0
20.000000
0
2003
141.722174
frcs_batch_1013
CA
Cable Manual WT
0.8
60
1014
82.513182
2500.0
20.000000
0
2003
10.744726
frcs_batch_1014
CA
Cable Manual WT
0.8
60
1015
82.513182
2500.0
20.000000
0
2003
1.150027
frcs_batch_1015
CA
Cable Manual WT
0.8
60
1016
82.513182
2500.0
20.000000
0
142
3.706521
frcs_batch_1016
CA
Cable Manual WT
0.8
60
1017
82.513182
2500.0
20.000000
0
142
141.722174
frcs_batch_1017
CA
Cable Manual WT
0.8
60
1018
82.513182
2500.0
20.000000
0
142
10.744726
frcs_batch_1018
CA
Cable Manual WT
0.8
60
1019
82.513182
2500.0
20.000000
0
142
1.150027
frcs_batch_1019
CA
Cable Manual WT
0.8
60
1020
82.513182
2500.0
20.000000
0
6
3.706521
frcs_batch_1020
CA
Cable Manual WT
0.8
60
1021
82.513182
2500.0
20.000000
0
6
141.722174
frcs_batch_1021
CA
Cable Manual WT
0.8
60
1022
82.513182
2500.0
20.000000
0
6
10.744726
frcs_batch_1022
CA
Cable Manual WT
0.8
60
1023
82.513182
2500.0
20.000000
0
6
1.150027
frcs_batch_1023
CA
Cable Manual WT
0.8
60
1024 rows × 11 columns
In [54]:
#Slope
plt.figure()
runs['C'].plot.hist()
Out[54]:
<matplotlib.axes._subplots.AxesSubplot at 0x10b3ea6a0>
In [55]:
# yarding distance
plt.figure()
runs['D'].plot.hist()
Out[55]:
<matplotlib.axes._subplots.AxesSubplot at 0x10b512550>
In [56]:
# Treatment area
plt.figure()
runs['E'].plot.hist()
Out[56]:
<matplotlib.axes._subplots.AxesSubplot at 0x10b639588>
In [57]:
# trees per acre
plt.figure()
runs['H'].plot.hist()
Out[57]:
<matplotlib.axes._subplots.AxesSubplot at 0x10b672438>
In [58]:
# cubic feet - volume per tree
plt.figure()
runs['J'].plot.hist()
Out[58]:
<matplotlib.axes._subplots.AxesSubplot at 0x10b8d0a90>
In [ ]:
Content source: WoodResourcesGroup/EPIC_AllPowerLabs
Similar notebooks: