Jump to content
Talk Sox
  • Create Account

Talk Sox Tips & Tricks, Part One: Tables!


Red Sox Video

Talk Sox Tips & Tricks, Part One: Tables! With this series of blog entries, I'm going to try to cover some of the features of the new site in a few paragraphs. Using the old site, as I'm sure many of you are aware, tables were basically unusable. That has changed! I'll tackle B-Ref tables quickly in this post but you can do similar things with FanGraphs or other sites that use table data (which is how almost all stat sites display their content). First, pop on over to Rafael Dever''s B-Ref page: https://www.baseball-reference.com/players/d/deverra01.shtml

I'm going to grab his 2020-2021 season stats. Just above his stat table, you'll see Share & Export. Click and then select Modify, Share, & Export Table. Boom, you can then select what stats you want to display and which you want to remove. I've removed all seasons except the last two. I also removed team and league because "duh". Then click the big X in the top right of the yellow square and you have your filtered table. Grab that table by moving your cursor to the top left of the table (just to the left of Year in this case) and while holding down the button of your mouse/trackpad, drag toward the bottom right of the table. The table will begin to highlight in yellow as you select the cells. Grab them all and let go of the mouse/trackpad. Then copy what has been selected (control+c on Windows, command+c on macOS). Pop over to Brewer Fanatic, start typing a comment, and paste your content (control+v on Windows, command+v on macOS).

Standard Batting
Year Age Tm Lg G PA AB R H 2B 3B HR RBI SB CS BB SO BA OBP SLG OPS OPS+ TB GDP HBP SH SF IBB Pos Awards
2017 20 BOS AL 58 240 222 34 63 14 0 10 30 3 1 18 57 .284 .338 .482 .819 112 107 5 0 0 0 3 5/HD  
2018 21 BOS AL 121 490 450 59 108 24 0 21 66 5 2 38 121 .240 .298 .433 .731 94 195 9 0 0 2 6 *5/HD  
2019 22 BOS AL 156 702 647 129 201 54 4 32 115 8 8 48 119 .311 .361 .555 .916 132 359 8 4 1 2 7 *5/HD6 MVP-12
2020 23 BOS AL 57 248 232 32 61 16 1 11 43 0 0 13 67 .263 .310 .483 .793 107 112 8 3 0 0 0 *5/H  
2021 24 BOS AL 156 664 591 101 165 37 1 38 113 5 5 62 143 .279 .352 .538 .890 134 318 13 7 0 4 7 *5/D4H AS,MVP-11,SS
2022 25 BOS AL 141 614 555 84 164 42 1 27 88 3 1 50 114 .295 .358 .521 .879 141 289 14 6 0 3 11 *5/DH AS,MVP-14
2023 26 BOS AL 153 656 580 90 157 34 0 33 100 5 1 62 126 .271 .351 .500 .851 126 290 15 11 0 3 10 *5/DH6 MVP-18,SS
2024 27 BOS AL 111 488 426 80 127 33 5 27 77 2 0 55 115 .298 .377 .589 .966 161 251 10 2 0 5 13 *5/D AS
8 Yrs 953 4102 3703 609 1046 254 12 199 632 31 18 346 862 .282 .347 .519 .866 129 1921 82 33 1 19 57    
162 Game Avg. 162 697 629 104 178 43 2 34 107 5 3 59 147 .282 .347 .519 .866 129 327 14 6 0 3 10    
Provided by Baseball-Reference.com: View Original Table
Generated 8/20/2024.
 
Note: you can use this method for most websites and spreadsheet data so whatever table data you have available you need to copy and paste, this method will likely suit your needs.

0 Comments


Recommended Comments

There are no comments to display.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...