Skip to content

Instantly share code, notes, and snippets.

@rwblair
Created April 28, 2020 17:04
Show Gist options
  • Save rwblair/deabd683a4229277dd69aa54f39adb1c to your computer and use it in GitHub Desktop.
Save rwblair/deabd683a4229277dd69aa54f39adb1c to your computer and use it in GitHub Desktop.
for file in $(find . -maxdepth 2 -name participants.tsv -exec grep -lP "\tage" {} \;); do echo $file && csvcut -t -c age $file | sort | uniq; done > age_by_ds.txt
./ds001544/participants.tsv
0
age
./ds000001/participants.tsv
19
20
21
22
24
26
27
30
age
./ds001810/participants.tsv
18
19
20
21
22
24
26
27
28
age
n/a
./ds000244/participants.tsv
"26,9"
"27,4"
"28,2"
"28,3"
"32,8"
"33,1"
"35,8"
"36,5"
"38,5"
"38,8"
"39,5"
"40,8"
age
./ds002724/participants.tsv
19
20
21
22
23
24
age
./ds002080/participants.tsv
39
40
44
46
48
49
51
52
53
55
57
58
60
61
62
64
67
70
72
74
75
77
age
./ds001344/participants.tsv
22
23
24
26
33
34
41
age
./ds001534/participants.tsv
18
19
20
21
22
age
./ds000168/participants.tsv
18
19
20
21
age
n/a
./ds000229/participants.tsv
19
21
24
25
28
29
31
age
./ds002572/participants.tsv
18
19
20
21
22
23
25
27
29
30
33
49
54
55
56
57
58
59
62
63
64
65
66
67
68
69
71
75
age
./ds002242/participants.tsv
age
F
M
./ds000253/participants.tsv
./ds001740/participants.tsv
018
019
021
022
023
024
025
027
029
030
034
035
041
044
049
073
age
./ds000234/participants.tsv
27
28
31
35
55
age
./ds001454/participants.tsv
19
20
21
22
23
26
27
28
29
30
32
33
38
age
./ds001771/participants.tsv
18
20
21
22
23
24
25
26
28
29
30
33
35
36
41
age
./ds001603/participants.tsv
18
20
21
22
23
24
25
26
28
29
30
33
35
36
41
age
./ds002711/participants.tsv
24
27
28
29
32
34
43
47
57
age
./ds001547/participants.tsv
""
21
23
25
32
33
age
./ds002712/participants.tsv
20
21
22
23
24
25
27
29
age
./ds001232/participants.tsv
18
19
20
21
22
23
24
25
27
29
age
./ds002732/participants.tsv
19
20
21
22
23
24
25
26
27
28
31
38
age
./ds001338/participants.tsv
19
20
22
23
24
25
27
28
29
30
32
34
35
age
./ds001608/participants.tsv
23
24
25
26
28
29
31
32
age
./ds000122/participants.tsv
22
24
26
28
29
30
31
32
33
41
age
./ds001761/participants.tsv
24
29
31
44
age
./ds002245/participants.tsv
18
"18,18"
"18,18,18"
"18,18,18,18"
"18,19,19"
"18,19,19,21,21"
19
"19,19"
"19,19,19"
"19,19,19,19"
"19,19,22"
"19,20,20,20,20"
20
"20,20"
"20,20,20"
"20,20,20,20"
"20,20,20,21,21"
"20,20,21"
"20,20,22,22"
"20,21,21"
21
"21,21"
"21,21,21"
"21,21,21,21"
"21,22,22"
22
"22,22"
"22,22,22"
"22,22,22,22"
"22,23"
23
"23,23"
"23,23,23"
"23,23,25"
24
"24,23,23"
"24,24"
"24,24,24,24"
"24,24,24,24,25"
"24,26,27,27"
25
"25,25"
"25,25,25,25"
26
"26,26"
"26,26,26"
"26,26,26,26"
"26,27,27,27,27"
27
"27,27"
"27,28,28"
28
"28,28,28"
"28,28,28,28"
"28,28,28,31,31"
29
"29,29"
"30,30"
31
"31,30,30,32,32,32,32"
"31,31,31"
"31,31,33"
"32,32"
"32,33,33,33"
"33,34,34"
"34,35,35"
"35,35,35,35"
"38,38,38,38"
41
45
"47,47"
"50,50,50,50"
"53,53,53,53"
age
n/a
"n/a,20,20"
"n/a,n/a"
./ds002152/participants.tsv
20
26
29
30
31
33
34
38
39
age
./ds000108/participants.tsv
18
19
20
21
22
23
24
25
26
27
29
41
age
./ds002419/participants.tsv
23
24
25
26
27
28
29
30
31
33
36
38
39
age
./ds001499/participants.tsv
24
25
26
27
age
./ds001510/participants.tsv
age
F
M
./ds001505/participants.tsv
30
age
./ds000102/participants.tsv
19.65
21.8
21.94
22.22
22.7
22.79
23.24
23.27
24.03
24.67
25.24
25.72
25.98
26
26.22
27
27.24
32.16
34.06
34.19
34.56
34.72
35.77
49.03
49.79
age
./ds002721/participants.tsv
18
22
23
26
29
30
31
32
34
35
36
38
39
44
49
51
59
60
61
62
63
66
age
./ds001461/participants.tsv
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
44
45
46
49
50
52
53
59
60
age
./ds002033/participants.tsv
18
19
20
21
22
23
24
25
26
27
29
30
31
33
34
35
36
37
39
age
./ds000007/participants.tsv
18
19
20
21
22
27
30
32
34
39
age
./ds002336/participants.tsv
19
25
26
27
29
31
36
39
age
./ds002655/participants.tsv
age
F
M
./ds000009/participants.tsv
18
19
20
21
22
26
27
33
age
./ds000212/participants.tsv
19
20
21
22
23
24
25
26
27
28
29
30
32
33
36
37
38
39
40
41
43
44
45
46
50
age
./ds002720/participants.tsv
18
19
20
21
23
24
26
28
age
./ds001555/participants.tsv
23
24
28
age
./ds000247/participants.tsv
21
23
28
30
35
age
n/a
./ds001746/participants.tsv
10
11
12
14
15
16
21
22
23
24
26
27
28
30
31
32
34
age
./ds001895/participants.tsv
67
age
./ds000224/participants.tsv
24
26
27
28
29
31
34
age
./ds000232/participants.tsv
22
24
25
27
29
30
31
36
37
38
age
./ds000218/participants.tsv
19
20
21
22
23
24
25
26
30
32
age
./ds001241/participants.tsv
20
21
22
23
24
25
26
27
28
29
30
31
33
age
./ds001652/participants.tsv
18
19
20
25
26
27
age
./ds001511/participants.tsv
19
20
21
22
23
26
28
38
age
./ds001110/participants.tsv
18
19
20
21
22
23
25
26
45
age
./ds000120/participants.tsv
10.5
11.2
11.7
11.8
12.7
14.3
14.8
15.1
15.7
16.0
16.3
17.0
17.1
17.5
18.5
18.7
19.3
19.7
20.2
21.9
22.5
22.6
22.7
25.6
8.8
age
./ds000246/participants.tsv
""
25
age
n/a
./ds001927/participants.tsv
19
22
23
24
25
26
27
28
29
30
31
32
age
./ds002270/participants.tsv
21
22
23
24
26
27
28
29
age
./ds002543/participants.tsv
19
20
21
22
23
24
27
28
29
age
./ds001378/participants.tsv
./ds000171/participants.tsv
18
19
21
22
23
24
25
26
27
29
30
31
37
39
42
44
46
52
54
55
56
59
age
./ds001021/participants.tsv
59.0
age
./ds001545/participants.tsv
18
19
20
21
22
23
24
25
27
28
29
32
33
age
./ds002276/participants.tsv
25
age
./ds000101/participants.tsv
21.16
23.12
23.34
24.41
25.63
25.71
25.79
26.2
26.33
28.24
29.06
29.83
29.97
30.14
30.83
31.53
37.88
40.48
40.85
41.71
49.16
age
./ds001569/participants.tsv
""
19
22
24
25
28
age
./ds002722/participants.tsv
19
20
21
22
23
24
30
age
./ds001670/participants.tsv
18
19
20
21
22
25
29
36
38
age
./ds001645/participants.tsv
24
age
./ds001525/participants.tsv
18
19
20
21
22
23
25
26
31
35
age
./ds001882/participants.tsv
20
21
22
23
24
25
26
28
29
30
33
36
38
39
55
age
./ds001908/participants.tsv
26
age
./ds000239/participants.tsv
26
30
31
age
./ds001365/participants.tsv
0.006
0.556
0.876
-0.994
0.996
1.416
1.486
1.696
1.726
1.916
1.976
-2.074
2.096
2.136
2.306
-2.364
-2.484
2.546
2.596
-2.664
2.666
-2.834
2.946
2.966
-2.994
3.046
3.176
-3.454
-3.634
-3.894
-3.924
-3.974
-4.214
4.296
age
./ds002250/participants.tsv
018Y
019Y
020Y
021Y
023Y
024Y
025Y
026Y
027Y
029Y
032Y
036Y
age
./ds001131/participants.tsv
18
19
20
21
22
23
24
26
27
28
31
34
age
./ds000110/participants.tsv
18
19
20
21
22
23
27
age
./ds000030/participants.tsv
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
age
./ds001784/participants.tsv
30
40
50
60
70
age
./ds000115/participants.tsv
11.6687
12.3696
12.6051
13.1307
13.8344
14.6092
15.4716
15.5099
16.1725
16.9199
17.2512
17.6865
18.486
18.6229
18.7187
18.7488
18.768
18.8747
18.9706
19.2115
19.4579
19.5346
19.6906
19.9562
19.9617
19.9836
20.4025
20.5941
20.6489
20.7036
20.835
20.9692
21.024
21.1088
21.2266
21.2594
21.3005
21.473000000000003
21.5168
22.2834
22.319000000000003
22.7105
22.7187
22.7433
22.8172
22.9295
22.9541
23.0171
23.0746
23.1157
23.2471
23.269000000000002
23.373
23.5893
24.0329
24.1588
24.4983
24.5749
24.5941
24.7447
24.8323
24.8378
24.9719
24.9802
25.1499
25.3771
25.4976
25.5852
25.6454
25.8344
25.9247
26.0096
26.0315
26.0397
26.2177
26.2642
26.2806
26.2861
26.3628
26.4504
26.6146
26.8419
26.9651
27.5838
27.6468
27.6632
27.6797
27.7728
27.9069
28.961
28.9938
29.013
29.2156
29.4648
29.7221
29.744
29.9603
30.7488
30.7871
age
./ds002723/participants.tsv
19
20
21
22
23
30
age
./ds001743/participants.tsv
19
21
26
34
54
57
59
65
66
age
./ds001491/participants.tsv
18
20
21
22
23
24
25
26
27
28
29
age
./ds000008/participants.tsv
20
21
22
23
24
25
29
31
37
age
./ds001928/participants.tsv
21
22
23
25
27
30
31
34
36
38
40
41
42
44
45
46
47
48
50
51
53
55
57
61
66
70
age
./ds000003/participants.tsv
18
19
20
21
22
25
29
36
38
age
./ds000200/participants.tsv
12
13
14
15
17
18
19
age
./ds000148/participants.tsv
19
20
21
22
23
24
25
age
./ds000233/participants.tsv
21
24
25
26
28
31
age
./ds000113/participants.tsv
15-20
20-25
25-30
30-35
35-40
age
n/a
./ds001419/participants.tsv
25
age
./ds001408/participants.tsv
18
19
20
21
22
23
24
25
26
27
28
29
30
31
33
34
36
39
41
44
age
n/a
./ds001966/participants.tsv
18
19
20
21
22
23
24
25
26
27
age
./ds002110/participants.tsv
45
age
./ds001650/participants.tsv
18
19
20
21
22
23
24
25
age
./ds000117/participants.tsv
23
24
25
26
29
30
31
age
n/a
./ds000121/participants.tsv
age
F
M
./ds000236/participants.tsv
61
64
66
69
73
74
75
77
83
84
89+
age
./ds001618/participants.tsv
18
23
24
25
27
29
31
32
33
34
37
38
39
40
42
43
45
46
47
48
50
51
52
56
61
64
65
age
./ds001631/participants.tsv
20
21
23
25
26
27
30
32
33
34
35
40
age
./ds002034/participants.tsv
""
21
22
23
24
27
age
./ds000231/participants.tsv
18.7
19.3
19.7
20.9
23.5
23.7
27.4
33.5
34.9
age
./ds000157/participants.tsv
19.0
20.0
21.0
22.0
23.0
24.0
25.0
26.0
age
./ds000170/participants.tsv
19
20
21
22
23
24
26
27
29
31
35
age
./ds000174/participants.tsv
./ds001417/participants.tsv
20
21
22
23
24
25
26
27
28
29
30
31
33
34
age
./ds000119/participants.tsv
age
F
M
./ds001971/participants.tsv
18-38
23
28
32
38
age
./ds002578/participants.tsv
30
age
./ds002653/participants.tsv
./ds000256/participants.tsv
10.23
10.64
11.18
11.47
11.48
12.51
12.53
13.23
13.60
14.35
14.38
15.04
15.11
15.87
5.89
6.79
7.43
7.51
7.63
7.99
8.52
8.68
9.93
age
./ds000138/participants.tsv
23
24
25
26
27
28
29
32
40
age
./ds001493/participants.tsv
30
age
./ds002718/participants.tsv
23
24
25
26
29
30
31
age
n/a
./ds002683/participants.tsv
18
19
20
21
22
23
24
25
26
27
28
33
age
./ds001353/participants.tsv
019Y
021Y
022Y
023Y
024Y
025Y
026Y
027Y
028Y
029Y
030Y
031Y
032Y
033Y
038Y
046Y
age
./ds002522/participants.tsv
18
19
20
21
22
23
24
25
26
27
28
30
age
./ds002221/participants.tsv
""
20
21
22
23
24
25
26
28
29
31
33
40
age
./ds002748/participants.tsv
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
42
43
44
45
46
47
50
52
55
age
./ds000053/participants.tsv
18
19
20
21
22
23
24
25
26
27
28
29
30
age
./ds001840/participants.tsv
18
22
23
24
25
26
27
28
29
30
37
age
./ds002278/participants.tsv
25
age
./ds002749/participants.tsv
21
22
23
24
25
27
28
29
30
31
32
33
39
42
44
45
46
50
52
age
./ds001168/participants.tsv
./ds002236/participants.tsv
10.5
10.67
10.75
10.83
10.92
11
11.08
11.17
11.25
12.67
12.75
12.83
13
13.08
13.17
13.25
13.33
13.42
14.5
14.67
14.75
14.83
14.92
15.33
15.5
8.67
8.72
8.75
8.83
8.92
9
9.17
9.25
9.33
age
./ds002041/participants.tsv
18
19
20
21
22
23
24
age
./ds001566/participants.tsv
21
age
./ds001894/participants.tsv
./ds000017/participants.tsv
25
44
49
50
age
n/a
./ds002363/participants.tsv
019Y
021Y
023Y
024Y
025Y
026Y
027Y
030Y
032Y
age
./ds002330/participants.tsv
20
21
22
23
24
25
27
28
29
30
31
32
33
34
35
age
./ds001531/participants.tsv
18
20
21
22
23
24
25
26
27
28
34
35
age
./ds001229/participants.tsv
18
19
20
21
22
23
24
28
29
33
34
age
./ds001486/participants.tsv
./ds002334/participants.tsv
45
age
./ds002685/participants.tsv
"26,9"
"27,4"
"28,2"
"28,3"
"30,3"
"32,8"
"33,1"
"35,8"
"36,5"
"38,5"
"38,8"
"39,5"
"40,8"
age
./ds000002/participants.tsv
19
20
22
23
24
25
26
31
age
./ds001934/participants.tsv
""
19
21
22
23
24
25
26
27
31
33
34
36
age
./ds000217/participants.tsv
18
19
20
21
23
24
25
26
27
28
31
age
./ds000222/participants.tsv
21
22
23
24
25
26
27
28
29
30
31
32
34
60
61
62
63
64
65
66
67
68
69
70
72
73
age
./ds001165/participants.tsv
""
0
age
./ds001228/participants.tsv
19
20
21
22
23
24
25
26
28
29
31
34
35
age
./ds001942/participants.tsv
23
24
25
26
27
29
30
age
./ds001517/participants.tsv
18
19
20
21
22
23
27
29
31
33
age
./ds001297/participants.tsv
19
20
21
22
23
24
25
26
27
28
30
32
age
./ds000238/participants.tsv
18
19
20
21
22
23
24
25
26
27
32
35
age
./ds000220/participants.tsv
""
18
19
20
21
23
25
28
31
32
34
35
36
39
41
50
52
age
./ds000235/participants.tsv
21
30
56
65
age
./ds001734/participants.tsv
18
19
20
21
22
23
24
25
26
27
28
30
31
32
33
34
35
37
age
./ds001306/participants.tsv
20.895890411
21.4520547945
21.5287671233
24.3698630137
24.8684931507
24.9808219178
25.7780821918
26.1753424658
26.6493150685
26.6904109589
27.3835616438
29.1123287671
29.6438356164
30.0849315068
31.9890410959
32.8767123288
33.2575342466
age
./ds001985/participants.tsv
20
21
22
23
24
25
27
29
age
./ds000214/participants.tsv
20
21
24
25
26
27
28
29
30
31
32
33
34
35
36
38
40
41
42
43
46
50
51
age
./ds000005/participants.tsv
19
20
21
22
24
25
27
28
age
./ds002717/participants.tsv
25
26
28
29
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
47
48
age
./ds000116/participants.tsv
20
21
23
25
26
27
30
32
33
34
35
40
age
./ds002185/participants.tsv
21
22
23
24
25
26
27
28
29
32
33
age
./ds001976/participants.tsv
20
21
22
23
24
25
27
29
age
./ds002345/participants.tsv
18
"18,18"
"18,18,18"
"18,18,18,18"
"18,19,19"
"18,19,19,21,21"
19
"19,19"
"19,19,19"
"19,19,19,19"
"19,19,22"
"19,20,20,20,20"
20
"20,20"
"20,20,20"
"20,20,20,20"
"20,20,20,21,21"
"20,20,21"
"20,20,22,22"
"20,21,21"
21
"21,21"
"21,21,21"
"21,21,21,21"
"21,22,22"
22
"22,22"
"22,22,22"
"22,22,22,22"
"22,23"
23
"23,23"
"23,23,23"
"23,23,25"
24
"24,23,23"
"24,24"
"24,24,24,24"
"24,24,24,24,25"
"24,26,27,27"
25
"25,25"
"25,25,25,25"
26
"26,26"
"26,26,26"
"26,26,26,26"
"26,27,27,27,27"
27
"27,27"
"27,28,28"
28
"28,28,28"
"28,28,28,28"
"28,28,28,31,31"
29
"29,29"
"30,30"
31
"31,30,30,32,32,32,32"
"31,31,31"
"31,31,33"
"32,32"
"32,33,33,33"
"33,34,34"
"34,35,35"
"35,35,35,35"
"38,38,38,38"
41
45
"47,47"
"50,50,50,50"
"53,53,53,53"
age
n/a
"n/a,20,20"
"n/a,n/a"
./ds001439/participants.tsv
018Y
020Y
021Y
022Y
023Y
024Y
025Y
027Y
030Y
032Y
035Y
age
./ds000219/participants.tsv
19
20
21
22
23
25
26
27
age
./ds001553/participants.tsv
""
25
28
30
age
./ds000221/participants.tsv
./ds001450/participants.tsv
""
26
28
age
./ds001883/participants.tsv
23
24
25
26
27
28
30
33
36
38
39
40
55
age
./ds000210/participants.tsv
18
19
20
21
22
23
24
25
26
28
31
age
./ds001868/participants.tsv
38
age
./ds002687/participants.tsv
20.40
21.59
21.95
22.50
24.50
24.81
24.99
25.36
25.46
26.11
26.17
26.33
26.52
26.73
27.14
27.44
27.51
28.24
28.40
28.41
28.48
28.96
29.47
30.14
age
./ds000249/participants.tsv
20
21
23
24
25
26
28
29
30
37
45
age
./ds002000/participants.tsv
age
NaN
./ds001345/participants.tsv
22
24.35
24.51
26.59
27.29
28.21
28.38
29.57
29.91
30.48
30.55
34.84
age
./ds000140/participants.tsv
19
20
21
22
23
24
25
26
27
29
31
32
33
34
48
55
age
./ds001596/participants.tsv
74
age
./ds001128/participants.tsv
18
19
20
21
22
24
25
age
./ds002393/participants.tsv
39
age
./ds002411/participants.tsv
20
21
22
23
24
age
./ds000254/participants.tsv
20
23
24
25
27
31
33
38
40
50
age
./ds002750/participants.tsv
""
0
age
./ds001748/participants.tsv
10
11
12
14
15
16
21
22
23
24
26
27
28
30
31
32
34
age
./ds001460/participants.tsv
28
age
./ds002691/participants.tsv
23
36
39
41
43
46
51
52
53
56
60
61
64
66
age
./ds002366/participants.tsv
""
56.03
59.04
61.07
63.02
65.00
66.10
66.92
67.01
69.00
69.02
69.98
71.06
71.99
72.99
73.00
73.02
73.04
73.98
74.95
74.99
75.05
76.98
76.99
78.02
78.05
78.06
78.97
79.07
79.99
81.05
82.02
83.05
83.09
age
./ds001919/participants.tsv
-
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
50
52
age
./ds002338/participants.tsv
18
23
25
26
28
30
31
32
34
36
39
41
42
44
46
47
50
66
age
./ds001430/participants.tsv
18
19
20
21
22
23
24
26
27
29
30
33
age
./ds001354/participants.tsv
36.27
38
48.1
56.67
57.76
58.4
60.63
60.69
62.11
62.31
62.58
63.44
64.89
64.94
66.63
67.44
68.91
69.17
69.94
70.02
70.24
70.45
72.83
73.33
73.43
74.28
76.77
77.65
age
./ds000011/participants.tsv
19
20
21
26
29
30
34
35
37
age
./ds002322/participants.tsv
18
19
20
21
22
26
age
./ds000006/participants.tsv
19
20
21
22
23
24
26
35
age
./ds001386/participants.tsv
18
19
20
21
22
23
24
25
26
27
28
30
31
32
34
35
36
39
40
42
44
45
49
55
57
59
60
69
74
age
./ds001399/participants.tsv
0
age
./ds002725/participants.tsv
20
21
22
23
24
25
26
27
28
29
age
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment