In [1]:
from bokeh.plotting import figure, show, output_notebook
import pandas as pd
In [3]:
def load_data(fp, index_col, sep="\t"):
x = pd.read_csv(fp, sep=sep, na_values='')
x.set_index(index_col, inplace=True)
return x
def build_figure(data, xcol, ycol, xscale, yscale):
p = figure(x_axis_type=xscale, y_axis_type=yscale)
p.xaxis.axis_label = xcol
p.yaxis.axis_label = ycol
p.circle(data[xcol], data[ycol], fill_alpha=0.2, size=5)
return p
def update(xcol, ycol, xscale, yscale):
show(build_figure(data, xcol, ycol, xscale, yscale))
In [4]:
fp = "/Users/luke/krse2011/db/krse2011_v5_humann_KOrelAbund_read1_wNames.tsv"
data = load_data(fp, "Sample")
In [5]:
from IPython.html.widgets import interact, DropdownWidget, Checkbox
interact(update, xcol=tuple(data.columns), ycol=tuple(data.columns), xscale=["linear", "log"], yscale=["linear", "log"])
In [6]:
data
Out[6]:
Station
Latitude (N)
Longitude (E)
X-coordinate
Y-coordinate
Depth (m)
Temperature (C)
Salinity (psu)
Oxygen (mL/L)
Fluorescence (mg/m^3)
...
K14579
K14581
K14582
K14583
K14584
K14585
K14588
K14591
K14596
K14597
Sample
sample01
12
17.662
40.905
1.20400
0.93281
10
31.200
38.870
4.249
0.0010
...
0.000000e+00
0.000000
0.000000e+00
0.000001
0.000005
0.000000
0.000000e+00
0.000000
0
0.000000
sample02
12
17.662
40.905
1.20400
0.93281
25
31.144
38.869
4.248
0.0157
...
0.000000e+00
0.000002
0.000000e+00
0.000001
0.000003
0.000000
0.000000e+00
0.000000
0
0.000000
sample03
12
17.662
40.905
1.20400
0.93281
47
23.042
37.393
1.969
1.5190
...
0.000000e+00
0.000000
0.000000e+00
0.000001
0.000005
0.000000
0.000000e+00
0.000000
0
0.000001
sample04
22
17.996
39.799
0.38535
1.74800
10
30.454
39.063
4.290
0.0010
...
0.000000e+00
0.000000
0.000000e+00
0.000000
0.000003
0.000000
0.000000e+00
0.000000
0
0.000000
sample05
22
17.996
39.799
0.38535
1.74800
25
29.913
39.072
4.324
0.0010
...
0.000000e+00
0.000000
0.000000e+00
0.000001
0.000002
0.000000
0.000000e+00
0.000000
0
0.000000
sample06
22
17.996
39.799
0.38535
1.74800
50
29.681
39.068
4.319
0.0983
...
0.000000e+00
0.000000
0.000000e+00
0.000000
0.000000
0.000000
0.000000e+00
0.000000
0
0.000000
sample07
22
17.996
39.799
0.38535
1.74800
100
24.374
40.052
3.635
0.0814
...
2.050000e-08
0.000000
0.000000e+00
0.000001
0.000009
0.000000
3.940000e-07
0.000000
0
0.000005
sample08
22
17.996
39.799
0.38535
1.74800
200
21.927
40.453
1.546
0.0010
...
1.020000e-06
0.000002
0.000000e+00
0.000002
0.000007
0.000000
2.400000e-08
0.000000
0
0.000014
sample09
22
17.996
39.799
0.38535
1.74800
500
21.571
40.533
1.089
0.0010
...
7.760000e-07
0.000000
0.000000e+00
0.000000
0.000002
0.000000
2.540000e-07
0.000000
0
0.000017
sample10
34
18.580
40.743
1.49310
1.81900
10
31.021
38.918
4.338
0.0011
...
0.000000e+00
0.000000
0.000000e+00
0.000000
0.000004
0.000000
2.120000e-07
0.000000
0
0.000000
sample11
34
18.580
40.743
1.49310
1.81900
25
30.867
38.937
4.585
0.0120
...
0.000000e+00
0.000001
0.000000e+00
0.000000
0.000006
0.000000
0.000000e+00
0.000000
0
0.000000
sample12
34
18.580
40.743
1.49310
1.81900
50
21.570
37.014
1.288
1.0967
...
4.570000e-07
0.000000
0.000000e+00
0.000000
0.000002
0.000000
3.950000e-07
0.000000
0
0.000002
sample13
34
18.580
40.743
1.49310
1.81900
100
22.382
38.435
1.932
0.0336
...
0.000000e+00
0.000001
0.000000e+00
0.000001
0.000007
0.000000
0.000000e+00
0.000000
0
0.000003
sample14
34
18.580
40.743
1.49310
1.81900
200
22.197
40.398
2.838
0.0010
...
3.260000e-07
0.000001
0.000000e+00
0.000001
0.000003
0.000001
0.000000e+00
0.000000
0
0.000013
sample15
34
18.580
40.743
1.49310
1.81900
258
21.810
40.477
0.602
0.0010
...
6.890000e-07
0.000000
0.000000e+00
0.000000
0.000009
0.000000
7.400000e-07
0.000001
0
0.000014
sample16
91
20.525
38.781
0.67735
4.45850
10
30.361
39.291
4.379
0.0010
...
0.000000e+00
0.000000
0.000000e+00
0.000001
0.000002
0.000001
0.000000e+00
0.000000
0
0.000000
sample17
91
20.525
38.781
0.67735
4.45850
25
30.365
39.291
4.379
0.0010
...
0.000000e+00
0.000000
0.000000e+00
0.000001
0.000001
0.000000
0.000000e+00
0.000000
0
0.000000
sample18
91
20.525
38.781
0.67735
4.45850
50
28.495
39.430
4.635
0.0575
...
0.000000e+00
0.000000
0.000000e+00
0.000000
0.000000
0.000000
3.050000e-07
0.000000
0
0.000000
sample19
91
20.525
38.781
0.67735
4.45850
100
24.118
40.103
3.484
0.2267
...
0.000000e+00
0.000000
0.000000e+00
0.000001
0.000007
0.000000
7.220000e-08
0.000000
0
0.000000
sample20
91
20.525
38.781
0.67735
4.45850
200
21.938
40.450
1.673
0.0010
...
6.100000e-07
0.000001
0.000000e+00
0.000000
0.000008
0.000001
0.000000e+00
0.000000
0
0.000008
sample21
91
20.525
38.781
0.67735
4.45850
500
21.575
40.531
0.915
0.0010
...
1.600000e-06
0.000000
0.000000e+00
0.000001
0.000004
0.000000
3.050000e-06
0.000000
0
0.000008
sample22
108
22.046
37.929
0.64142
6.20150
10
30.529
39.370
4.368
0.0010
...
1.430000e-07
0.000000
0.000000e+00
0.000007
0.000007
0.000006
2.160000e-06
0.000000
0
0.000000
sample23
108
22.046
37.929
0.64142
6.20150
25
30.509
39.373
4.378
0.0010
...
3.510000e-07
0.000001
0.000000e+00
0.000001
0.000003
0.000000
4.110000e-07
0.000000
0
0.000000
sample24
108
22.046
37.929
0.64142
6.20150
50
30.436
39.368
4.382
0.0024
...
0.000000e+00
0.000000
0.000000e+00
0.000000
0.000001
0.000001
1.830000e-07
0.000000
0
0.000000
sample25
108
22.046
37.929
0.64142
6.20150
100
24.214
40.119
3.995
0.4532
...
0.000000e+00
0.000001
0.000000e+00
0.000002
0.000001
0.000002
0.000000e+00
0.000000
0
0.000001
sample26
108
22.046
37.929
0.64142
6.20150
200
22.118
40.420
2.786
0.0010
...
3.780000e-07
0.000002
0.000000e+00
0.000001
0.000010
0.000000
1.700000e-07
0.000000
0
0.000013
sample27
108
22.046
37.929
0.64142
6.20150
500
21.575
40.532
1.003
0.0010
...
1.580000e-06
0.000001
0.000000e+00
0.000000
0.000003
0.000001
4.460000e-07
0.000000
0
0.000014
sample28
149
23.604
37.054
0.60262
7.98800
10
29.800
40.017
4.373
0.0010
...
3.280000e-08
0.000000
0.000000e+00
0.000004
0.000001
0.000004
1.390000e-06
0.000000
0
0.000000
sample29
149
23.604
37.054
0.60262
7.98800
25
29.802
40.017
4.380
0.0010
...
3.850000e-07
0.000000
0.000000e+00
0.000000
0.000002
0.000001
0.000000e+00
0.000000
0
0.000000
sample30
149
23.604
37.054
0.60262
7.98800
50
27.539
39.860
4.682
0.0020
...
3.230000e-07
0.000000
0.000000e+00
0.000001
0.000001
0.000001
2.760000e-07
0.000000
0
0.000000
sample31
149
23.604
37.054
0.60262
7.98800
100
24.549
40.077
4.432
0.3989
...
0.000000e+00
0.000000
0.000000e+00
0.000001
0.000004
0.000002
3.090000e-07
0.000000
0
0.000001
sample32
149
23.604
37.054
0.60262
7.98800
200
22.935
40.331
4.083
0.0569
...
8.700000e-07
0.000001
1.920000e-08
0.000001
0.000009
0.000002
1.940000e-06
0.000000
0
0.000003
sample33
149
23.604
37.054
0.60262
7.98800
500
21.582
40.529
0.775
0.0010
...
2.010000e-06
0.000001
0.000000e+00
0.000001
0.000005
0.000001
2.550000e-06
0.000000
0
0.000013
sample34
169
25.772
36.116
0.79530
10.34200
10
28.943
40.512
4.458
0.0010
...
1.390000e-07
0.000000
0.000000e+00
0.000002
0.000003
0.000002
1.130000e-06
0.000000
0
0.000000
sample35
169
25.772
36.116
0.79530
10.34200
25
28.943
40.512
4.461
0.0010
...
3.290000e-07
0.000000
0.000000e+00
0.000001
0.000003
0.000001
4.200000e-07
0.000000
0
0.000001
sample36
169
25.772
36.116
0.79530
10.34200
50
27.999
40.397
4.633
0.0010
...
6.740000e-08
0.000000
0.000000e+00
0.000000
0.000002
0.000000
0.000000e+00
0.000000
0
0.000000
sample37
169
25.772
36.116
0.79530
10.34200
100
24.825
40.332
4.607
0.3364
...
1.230000e-07
0.000001
8.940000e-08
0.000002
0.000008
0.000001
6.870000e-07
0.000000
0
0.000000
sample38
169
25.772
36.116
0.79530
10.34200
200
22.349
40.409
3.568
0.0010
...
1.170000e-06
0.000000
0.000000e+00
0.000000
0.000004
0.000000
4.860000e-07
0.000000
0
0.000007
sample39
169
25.772
36.116
0.79530
10.34200
500
21.603
40.530
1.407
0.0010
...
2.480000e-06
0.000000
0.000000e+00
0.000007
0.000009
0.000001
1.350000e-06
0.000000
0
0.000009
sample40
192
27.897
34.507
0.37571
12.97500
10
27.891
40.512
4.517
0.0010
...
3.320000e-07
0.000000
0.000000e+00
0.000007
0.000003
0.000006
1.570000e-06
0.000000
0
0.000000
sample41
192
27.897
34.507
0.37571
12.97500
25
27.845
40.515
4.514
0.0034
...
4.060000e-07
0.000000
0.000000e+00
0.000001
0.000003
0.000002
8.340000e-07
0.000000
0
0.000000
sample42
192
27.897
34.507
0.37571
12.97500
50
26.227
40.444
4.608
0.3053
...
2.460000e-07
0.000000
0.000000e+00
0.000002
0.000003
0.000003
2.610000e-07
0.000001
0
0.000000
sample43
192
27.897
34.507
0.37571
12.97500
100
23.678
40.395
4.190
0.1246
...
4.490000e-07
0.000000
0.000000e+00
0.000003
0.000004
0.000001
8.720000e-07
0.000000
0
0.000001
sample44
192
27.897
34.507
0.37571
12.97500
200
22.408
40.442
3.463
0.0010
...
1.870000e-07
0.000000
0.000000e+00
0.000002
0.000007
0.000001
1.460000e-06
0.000000
0
0.000003
sample45
192
27.897
34.507
0.37571
12.97500
500
21.606
40.530
1.387
0.0010
...
1.060000e-06
0.000000
0.000000e+00
0.000002
0.000008
0.000001
4.650000e-07
0.000000
0
0.000011
45 rows × 5792 columns
In [ ]:
Content source: cuttlefishh/papers
Similar notebooks: