[1] all data frame:
   studid      name gender year midterm final
1    1138   William      M    3      82    84
2    1422     Chloe      F    1      72    75
3    2293   Michael      M    4      93    95
4    2483   Anthony      M    4      97    98
5    2568    Andrew      M    1      74    55
6    3320    Sophia      F    4      99    98
7    3484     Emily      F    3      91    98
8    3610 Alexander      M    2      78    79
9    3859    Joshua      M    1      19     0
10   4738   Natalie      F    2      85    79
11   5187 Elizabeth      F    3      90    91
12   6247  Isabella      F    1      89    88
13   6992    Daniel      M    3      82    93
14   7123     Jacob      M    1      75    73
15   7156  Samantha      F    2      82    80
16   8471    Olivia      F    3      89    87
[1] women data frame:
        name midterm final
2      Chloe      72    75
6     Sophia      99    98
7      Emily      91    98
10   Natalie      85    79
11 Elizabeth      90    91
12  Isabella      89    88
15  Samantha      82    80
16    Olivia      89    87