Skip to content

Instantly share code, notes, and snippets.

@rwblair
Created April 28, 2020 16:17
Show Gist options
  • Save rwblair/b00cf41d6693b65d67e3c8c1fe73608c to your computer and use it in GitHub Desktop.
Save rwblair/b00cf41d6693b65d67e3c8c1fe73608c to your computer and use it in GitHub Desktop.
for file in $(find . -maxdepth 2 -name participants.tsv -exec grep -lP "\tsex" {} \;); do echo $file && csvcut -t -c sex $file | sort | uniq; done > sex_by_ds.txt
./ds001544/participants.tsv
m
sex
./ds000001/participants.tsv
F
M
"M,"
sex
./ds000244/participants.tsv
F
M
sex
./ds002724/participants.tsv
F
M
sex
./ds002080/participants.tsv
F
M
sex
./ds001344/participants.tsv
F
M
sex
./ds000168/participants.tsv
F
M
sex
./ds000229/participants.tsv
F
M
sex
./ds002572/participants.tsv
F
sex
./ds002242/participants.tsv
19
20
21
22
23
24
25
26
27
28
sex
./ds000253/participants.tsv
F
sex
./ds001740/participants.tsv
F
M
sex
./ds000234/participants.tsv
F
M
sex
./ds001454/participants.tsv
F
M
sex
./ds001771/participants.tsv
F
M
sex
./ds001603/participants.tsv
F
M
sex
./ds002711/participants.tsv
F
M
sex
./ds001547/participants.tsv
""
M
sex
W
./ds002712/participants.tsv
f
m
sex
./ds001232/participants.tsv
F
M
sex
./ds002732/participants.tsv
M
sex
W
./ds001338/participants.tsv
F
M
sex
./ds001608/participants.tsv
f
m
sex
./ds000122/participants.tsv
F
M
sex
./ds001761/participants.tsv
m
sex
./ds002245/participants.tsv
F
"F,F"
"F,F,F"
"F,F,F,F"
"F,F,F,F,F"
"F,F,F,F,F,F,F"
M
"M,M"
"M,M,M"
"M,M,M,M"
sex
./ds002152/participants.tsv
F
M
sex
./ds000108/participants.tsv
F
M
sex
./ds002702/participants.tsv
""
f
m
sex
./ds001233/participants.tsv
F
M
sex
./ds001499/participants.tsv
F
M
sex
./ds001510/participants.tsv
18
19
20
21
22
23
24
25
26
27
28
29
32
33
34
sex
./ds001505/participants.tsv
m
sex
./ds002721/participants.tsv
F
M
sex
./ds002550/participants.tsv
F
M
sex
./ds001461/participants.tsv
F
M
sex
./ds002033/participants.tsv
F
M
sex
./ds002336/participants.tsv
F
M
sex
./ds002655/participants.tsv
18
19
20
21
22
23
24
25
26
29
31
sex
./ds000009/participants.tsv
F
M
sex
./ds001722/participants.tsv
F
M
sex
./ds001502/participants.tsv
F
sex
./ds002720/participants.tsv
F
M
sex
./ds001555/participants.tsv
F
M
sex
./ds000247/participants.tsv
Female
Male
n/a
sex
./ds001746/participants.tsv
F
M
sex
./ds001750/participants.tsv
F
M
sex
./ds001895/participants.tsv
F
sex
./ds000232/participants.tsv
F
M
sex
./ds000218/participants.tsv
M
sex
./ds001241/participants.tsv
F
M
sex
./ds001652/participants.tsv
F
M
sex
./ds001511/participants.tsv
F
M
sex
./ds001110/participants.tsv
F
M
sex
./ds000120/participants.tsv
F
M
sex
./ds000246/participants.tsv
""
Male
n/a
sex
./ds001927/participants.tsv
F
M
sex
./ds002270/participants.tsv
F
M
sex
./ds002543/participants.tsv
f
m
sex
./ds000171/participants.tsv
F
M
sex
./ds001021/participants.tsv
FEMALE
sex
./ds001545/participants.tsv
F
M
sex
./ds002276/participants.tsv
F
sex
./ds001569/participants.tsv
""
female
male
sex
./ds002722/participants.tsv
F
M
sex
./ds001670/participants.tsv
F
M
sex
./ds001645/participants.tsv
F
sex
./ds001525/participants.tsv
F
M
sex
./ds001882/participants.tsv
f
m
sex
./ds001908/participants.tsv
F
sex
./ds002250/participants.tsv
F
M
sex
./ds001131/participants.tsv
F
M
sex
./ds000110/participants.tsv
F
M
sex
./ds002723/participants.tsv
F
M
sex
./ds000008/participants.tsv
F
M
sex
./ds001554/participants.tsv
F
M
sex
./ds001928/participants.tsv
F
sex
./ds000003/participants.tsv
F
M
sex
./ds000148/participants.tsv
F
M
sex
./ds000233/participants.tsv
f
m
sex
./ds001419/participants.tsv
M
sex
./ds001242/participants.tsv
F
M
sex
./ds001408/participants.tsv
f
m
sex
./ds002110/participants.tsv
M
sex
./ds001650/participants.tsv
F
M
sex
./ds000117/participants.tsv
F
M
n/a
sex
./ds000121/participants.tsv
10.4422
11.7262
12.7009
13.1034
13.4483
14.2697
15.9535
16.1588
16.6489
17.1417
17.8535
18.4285
18.5407
19.217
19.5866
20.2574
20.5859
21.347
21.8152
22.2396
22.4394
22.5079
22.642
25.9165
26.6174
27.0938
68.3888
9.796
sex
./ds000236/participants.tsv
F
M
sex
./ds001618/participants.tsv
F
M
sex
./ds001631/participants.tsv
F
M
sex
./ds002034/participants.tsv
""
F
M
sex
./ds000231/participants.tsv
F
M
sex
./ds000157/participants.tsv
F
sex
./ds002011/participants.tsv
F
M
sex
./ds000170/participants.tsv
female
male
sex
./ds001417/participants.tsv
F
M
sex
./ds001890/participants.tsv
M
sex
./ds000119/participants.tsv
10.0178
10.0452
10.2505
10.6995
10.9405
11.0637
11.2279
11.3895
11.6359
11.655
11.9425
12.0794
12.1752
12.2628
12.4271
12.7009
12.7392
12.9774
13.0787
13.1417
13.2238
13.3771
13.9055
14.0014
14.6366
15.0637
15.1184
15.718
15.9507
16.4189
16.4983
16.6653
17.1088
17.2129
17.3799
17.4784
17.5031
17.6235
17.8836
17.9055
18.2697
18.3244
18.3792
18.4586
18.538
18.5544
19.1102
19.3265
19.6769
19.7947
20.0958
20.1588
20.1725
20.1916
20.3121
20.3203
20.3477
20.5229
21.9521
22.6557
22.9213
22.9651
25.4675
25.5715
26.2341
26.5325
26.7598
8.1396
8.4517
8.9938
9.4565
9.5496
sex
./ds001971/participants.tsv
F
M
sex
./ds002653/participants.tsv
female
male
sex
./ds000256/participants.tsv
F
M
sex
./ds000138/participants.tsv
F
M
sex
./ds001493/participants.tsv
M
sex
./ds002683/participants.tsv
F
M
sex
./ds001353/participants.tsv
F
M
sex
./ds002522/participants.tsv
f
m
sex
./ds002221/participants.tsv
""
F
M
sex
./ds002748/participants.tsv
f
m
sex
./ds001840/participants.tsv
f
m
sex
./ds002278/participants.tsv
F
sex
./ds002749/participants.tsv
f
m
sex
./ds001168/participants.tsv
F
M
sex
./ds002236/participants.tsv
1
2
sex
./ds002041/participants.tsv
F
M
sex
./ds001566/participants.tsv
f
sex
./ds001894/participants.tsv
1
2
sex
./ds000017/participants.tsv
F
M
n/a
sex
./ds002363/participants.tsv
F
M
sex
./ds002330/participants.tsv
female
male
Other
sex
./ds001531/participants.tsv
F
M
sex
./ds001229/participants.tsv
F
M
sex
./ds001486/participants.tsv
1
2
sex
./ds002334/participants.tsv
F
sex
./ds002685/participants.tsv
F
M
sex
./ds000002/participants.tsv
F
M
sex
./ds001934/participants.tsv
""
F
M
sex
./ds000217/participants.tsv
F
M
sex
./ds000222/participants.tsv
female
male
sex
./ds001165/participants.tsv
""
NA
sex
./ds001228/participants.tsv
F
M
sex
./ds001942/participants.tsv
F
M
sex
./ds001517/participants.tsv
F
M
sex
./ds001297/participants.tsv
F
M
sex
./ds000238/participants.tsv
F
M
sex
./ds000220/participants.tsv
""
F
M
sex
./ds000235/participants.tsv
F
M
sex
./ds001985/participants.tsv
f
m
sex
./ds000214/participants.tsv
F
M
sex
./ds000005/participants.tsv
F
M
sex
./ds002717/participants.tsv
F
sex
./ds000116/participants.tsv
F
M
sex
./ds002185/participants.tsv
F
sex
./ds001976/participants.tsv
f
m
sex
./ds002345/participants.tsv
F
"F,F"
"F,F,F"
"F,F,F,F"
"F,F,F,F,F"
"F,F,F,F,F,F,F"
M
"M,M"
"M,M,M"
"M,M,M,M"
sex
./ds001439/participants.tsv
F
M
sex
./ds000219/participants.tsv
M
sex
./ds001553/participants.tsv
""
F
sex
./ds002547/participants.tsv
F
M
sex
./ds001450/participants.tsv
""
F
sex
./ds001883/participants.tsv
f
m
sex
./ds001868/participants.tsv
m
sex
./ds002687/participants.tsv
1
2
sex
./ds002000/participants.tsv
n/a
sex
./ds001345/participants.tsv
F
M
sex
./ds000140/participants.tsv
F
M
sex
./ds001596/participants.tsv
F
sex
./ds001128/participants.tsv
F
M
sex
./ds002393/participants.tsv
m
sex
./ds002411/participants.tsv
F
M
sex
./ds000254/participants.tsv
F
M
sex
./ds002750/participants.tsv
""
NA
sex
./ds001748/participants.tsv
F
M
sex
./ds001460/participants.tsv
M
sex
./ds002366/participants.tsv
""
Female
Male
sex
./ds001919/participants.tsv
-
F
M
sex
./ds002338/participants.tsv
F
M
sex
./ds001430/participants.tsv
F
M
sex
./ds000011/participants.tsv
F
M
sex
./ds002322/participants.tsv
F
M
sex
./ds000006/participants.tsv
F
M
sex
./ds001386/participants.tsv
F
M
sex
./ds001399/participants.tsv
f
m
sex
./ds002725/participants.tsv
F
M
sex
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment