In [0]:
In [13]:
import IPython
js_code = '''
document.querySelector("#output-area").appendChild(document.createTextNode("hello world!"));
'''
display(IPython.display.Javascript(js_code))
In [0]:
In [0]:
!pip install --upgrade -q gspread
In [17]:
from google.colab import auth
auth.authenticate_user()
import gspread
from oauth2client.client import GoogleCredentials
gc = gspread.authorize(GoogleCredentials.get_application_default())
worksheet = gc.open('Oak2009').sheet1
# get_all_values gives a list of rows.
rows = worksheet.get_all_values()
print(rows)
# Convert to a DataFrame and render.
import pandas as pd
pd.DataFrame.from_records(rows)
IOPub data rate exceeded.
The notebook server will temporarily stop sending output
to the client in order to avoid crashing it.
To change this limit, set the config variable
`--NotebookApp.iopub_data_rate_limit`.
Current values:
NotebookApp.iopub_data_rate_limit=1000000.0 (bytes/sec)
NotebookApp.rate_limit_window=3.0 (secs)
Out[17]:
0
1
2
3
4
5
6
7
8
9
10
0
TIME
TREE
TREE
AIR
AIR
AIR
AIR
AIR
AIR
SOIL
SOIL
1
TIMESTAMP
stem movements
sap flow
air temperature
irradiance
rainfall
relative humidity (%)
vapor pressure deficit
wind speed
soil temperature
soil drought
2
4/10/09 0:00
0
28.761649
13.51
0
0
76.84383333
0.3520767
2.083732
10.4156
-15.472905
3
4/10/09 0:10
-0.42072
28.746251
13.46
0
0
76.93802667
0.3496081
2.136968
10.39589
-15.45384
4
4/10/09 0:20
-0.62897
28.736732
13.41
0
0
77.00506
0.347428533
2.128868
10.37899
-15.479745
5
4/10/09 0:30
-0.68707
28.727732
13.36
0
0
77.11501333
0.3447211
2.084727
10.35647
-15.464065
6
4/10/09 0:40
-0.70888
28.730999
13.32
0
0
77.27699667
0.340822667
2.072155
10.34191
-15.46281
7
4/10/09 0:50
-0.69817
28.727122
13.28
0
0
77.2808
0.339524867
2.181498
10.32087
-15.4596
8
4/10/09 1:00
-0.7314
28.704631
13.23
0
0
77.15603
0.341178567
2.61543
10.29605
-15.462855
9
4/10/09 1:10
-0.72452
28.662316
13.19
0
0
76.94847
0.345327067
2.420937
10.28067
-15.459325
10
4/10/09 1:20
-0.7284
28.648008
13.17
0
0
76.94922667
0.3446572
2.350137
10.26249
-15.46528
11
4/10/09 1:30
-0.75755
28.641373
13.15
0
0
76.81667333
0.346441167
2.171626
10.24514
-15.47727
12
4/10/09 1:40
-0.76614
28.635382
13.14
0
0
76.79787667
0.346944967
2.468358
10.23126
-15.47166
13
4/10/09 1:50
-0.82191
28.628539
13.13
0
0
76.88390333
0.344520267
2.3622
10.21214
-15.45159
14
4/10/09 2:00
-1.0062
28.629407
13.11
0
0
77.01854333
0.341065933
2.413344
10.19581
-15.465735
15
4/10/09 2:10
-1.0791
28.630556
13.09
0
0
77.1397
0.3377582
2.414942
10.17948
-15.461155
16
4/10/09 2:20
-1.0858
28.62405
13.06
0
0
77.14083667
0.3376784
2.489909
10.16307
-15.457365
17
4/10/09 2:30
-1.09027
28.619771
13.06
0
0
77.01949
0.341638067
2.579257
10.1466
-15.465035
18
4/10/09 2:40
-1.14041
28.616866
13.09
0
0
76.83244
0.345524367
2.393125
10.14663
-15.48742
19
4/10/09 2:50
-1.20324
28.609343
13.11
0
0
76.77167
0.346572433
2.437611
10.1385
-15.480985
20
4/10/09 3:00
-1.17176
28.598465
13.14
0
0
76.75078
0.347324567
2.769908
10.12107
-15.48101
21
4/10/09 3:10
-1.34445
28.590861
13.16
0
0
76.69457
0.3478893
2.569351
10.12121
-15.49398
22
4/10/09 3:20
-1.27176
28.588611
13.17
0
0
76.98113333
0.341304633
2.478213
10.10665
-15.466305
23
4/10/09 3:30
-1.18878
28.603555
13.13
0
0
77.44601
0.330671933
2.562857
10.09649
-15.462605
24
4/10/09 3:40
-1.18626
28.619801
13.06
0
0
77.94013
0.320302733
2.230645
10.07564
-15.47613
25
4/10/09 3:50
-1.27301
28.650453
12.95
0
0
78.22118667
0.313314933
2.343018
10.05672
-15.479105
26
4/10/09 4:00
-1.28604
28.664382
12.85
0
0
78.54288
0.307518067
2.190517
10.04668
-15.477755
27
4/10/09 4:10
-1.29413
28.669166
12.8
0
0
78.36303667
0.3110899
2.425113
10.02511
-15.4603
28
4/10/09 4:20
-1.30492
28.689796
12.78
0
0
78.13971667
0.316627233
2.249084
10.0221
-15.48886
29
4/10/09 4:30
-1.34558
28.705078
12.8
0
0
77.97488333
0.3206753
2.282169
10.02151
-15.466385
...
...
...
...
...
...
...
...
...
...
...
...
30788
11/9/09 19:00
2763.7878
22.49656
7.595
0
0
98.94992
0.010281267
0.245106
8.116982
-12.318165
30789
11/9/09 19:10
2763.8061
22.55097333
7.544
0
0
98.95524
0.010220056
0.2434297
8.100277
-12.324055
30790
11/9/09 19:20
2763.799
22.62181667
7.497
0
0
98.92464667
0.010500515
0.2949813
8.100371
-12.325305
30791
11/9/09 19:30
2763.8243
22.64383333
7.457
0
0
98.80117333
0.011715194
0.4303023
8.100913
-12.33329
30792
11/9/09 19:40
2763.8312
22.65714333
7.415
0
0
98.65547
0.013117387
0.2965518
8.094389
-12.335425
30793
11/9/09 19:50
2763.8382
22.68903
7.39
0
0
98.55022667
0.014154479
0.324012
8.076616
-12.33107
30794
11/9/09 20:00
2763.854
22.53417667
7.353
0
0
98.50900667
0.014550667
0.2944342
8.075683
-12.32122
30795
11/9/09 20:10
2763.8494
22.62317333
7.322
0
0
98.48297667
0.014773546
0.2977386
8.07592
-12.316625
30796
11/9/09 20:20
2763.8312
22.69227
7.296
0
0
98.47405
0.01485274
0.1558335
8.074048
-12.335185
30797
11/9/09 20:30
2763.845
22.66722333
7.256
0
0
98.50463667
0.014532903
0.2485784
8.055597
-12.346645
30798
11/9/09 20:40
2763.8063
22.68253667
7.226
0
0
98.52173333
0.014378194
0.296246
8.051866
-12.34096
30799
11/9/09 20:50
2763.8267
22.77109667
7.197
0
0
98.53351
0.014257851
0.322789
8.050632
-12.350915
30800
11/9/09 21:00
2763.8131
22.71801333
7.18
0
0
98.46227333
0.014961929
0.2360294
8.03162
-12.335835
30801
11/9/09 21:10
2763.8313
22.76093333
7.164
0
0
98.43283
0.015227792
0.4619904
8.025702
-12.34306
30802
11/9/09 21:20
2763.8153
22.73279
7.159
0
0
98.43302
0.015244957
0.2897716
8.025702
-12.349535
30803
11/9/09 21:30
2763.8287
22.73223
7.159
0
0
98.44973333
0.015099111
0.2148669
8.00709
-12.35071
30804
11/9/09 21:40
2763.8219
22.74472667
7.159
0
0
98.43282333
0.015215869
0.2487103
8.000322
-12.338135
30805
11/9/09 21:50
2763.8038
22.70575667
7.141
0
0
98.40908333
0.015371502
0.2300905
8.000322
-12.347835
30806
11/9/09 22:00
2763.8014
22.78024667
7.137
0
0
98.39654667
0.015455995
0.1936149
8.000322
-12.3548
30807
11/9/09 22:10
2763.8014
22.82070667
7.119
0
0
98.41136667
0.015294955
0.1593152
7.995669
-12.34717
30808
11/9/09 22:20
2763.7785
22.93416667
7.095
0
0
98.45695
0.01486477
7.976633
-12.346455
30809
11/9/09 22:30
2763.7809
22.95197667
7.076
0
0
98.50065
0.014405522
0.1927602
7.974941
-12.370435
30810
11/9/09 22:40
2763.7628
22.84877
7.059
0
0
98.52990333
0.014091367
0.1087424
7.974941
-12.36024
30811
11/9/09 22:50
2763.7764
22.88382667
7.049
0
0
98.54795
0.013906943
0.06264515
7.966477
-12.366785
30812
11/9/09 23:00
2763.8042
22.90414667
7.031
0
0
98.57997333
0.013580633
0.05641082
7.94955
-12.36508
30813
11/9/09 23:10
2763.774
23.06468667
7.013
0
0
98.61195333
0.013304668
0.0399579
7.94955
-12.36797
30814
11/9/09 23:20
2763.7628
23.16435
7.006
0
0
98.63768667
0.01308312
0.03151839
7.94955
-12.354095
30815
11/9/09 23:30
2763.763
23.14253667
7.006
0
0
98.65099333
0.012948949
0.06737932
7.94955
-12.360105
30816
11/9/09 23:40
2763.7267
23.11093333
7.006
0
0
98.6665
0.012786721
0.04013728
7.948703
-12.3589
30817
11/9/09 23:50
2763.7148
23.18570333
6.991
0
0
98.69574333
0.012483088
0.04300022
7.936426
-12.367315
30818 rows × 11 columns
In [0]:
Content source: scotgl/sonify
Similar notebooks: