We're pleased to announce the newest video in our series showing how to get the most out of our websites. Today's video is all about the stat tables themselves. We've programmed several ways for the site to reorganize and add up stats on the tables for you, just by clicking a button or two. However, many users don't realize these hacks exist. Hopefully, this video will save you some time and also illustrate how to answer questions like "What was Bryce Harper's OPS over his last 10 games" Read the rest of this entry
We're excited to post the latest video in our How To series, showing you some secrets and hacks that will help to get the most out of the Sports-Reference family of sites. Today's video is all about sharing. While many users know how to find the data they're look for, fewer know the different ways of sharing it. From embedding tables on a website or blog, to posting them to Reddit, to downloading directly to your computer as a spreadsheet, this video will show you the different ways that you share all the info you find on our sites:
As you may have noticed, on our re-designed sites we recently disabled the feature allowing you to export our tables directly to Excel. This was because updated browsers were no longer supporting the function and it was becoming problematic to keep up. However, this doesn't mean that you can't still easily export our tables into spreadsheets. There's just an extra step or two, now.
First, look for the "Share & more" tab atop the table you'd like to export. If you don't see this tab, it means the particular table you're looking at isn't exportable. Otherwise, hover over it and options will drop down (see image). Select "Get table as CSV (for Excel)", which will convert the table to comma-separated values.
Once the table has been converted to CSV, copy and paste the entirety of the table (or whatever section of it you want) into Excel, as text. You will now have an unintelligible, single-column mess in your spreadsheet, but that's fine. The commas are there for a reason and Excel will help us easily convert those commas into nice, readable columns of data. This next step is sometimes variable depending on the version of Excel you're working with, but what you want to find is the "text to columns" function. In my Excel for Mac 2011, this can be found under the "Data" tab. If you can't find it on your version, a google search for "Excel text to columns" with your Excel version number should yield useful results.
Once you have located the "text to columns" function, you will choose a file type that best describes your data. You will want to choose "delimited" since the fields are separated by commas. Next, you will choose the delimiter. Check the box next to "comma." Once you make that selection, you can finish up with the text to columns wizard and you should then have a nicely formatted spreadsheet.
We realize this is not quite as quick or simple as the old export function, but unfortunately we can no longer support that function. Once you get the hang of this method, you'll see it's also quite simple.
Regular visitors to the site have likely noticed a small tweak we recently made to the layout of player pages. The change is the addition of a shortcut to our Player Comparison Finder tool. For instance, from Stephen Curry's page, someone might decide that they want to compare him to James Harden. This can now be done very simply by typing Harden's name into the "compare to" box shown in the image below:
This is the default comparison search, but you can easily edit it to just compare 2014-15 (or any other season(s)). Just click the red "Show/Hide Search Form" link on top of the stat tables to bring up the search form. From there, edit your search to compare "single seasons" in the yellow part of the search form. Then select 2014-15 for both players and click "get results." This will take you to this page, comparing two leading 2014-15 MVP candidates in a variety of statistical categories, from basic to advanced.
As an added bonus, if you go back to the search form, you'll notice there's room for up to 6 players in a comparison. You can go ahead and populate any players you'd like there. For instance, here's 6 leading 2014-15 MVP candidates compared:
We should note to longtime fans of this tool that it is still accessible from the main Play Index page, but we've added this search to player pages as an added convenience.
I got a couple of questions about this today, so I thought it would be valuable to highlight this feature in blog-post form.
Essentially, the question was regarding what kind of batting production a specific team has gotten from a given defensive position this season. For example, a user wanted the combined season stats for Yankees players this season, only while playing 3B.
Veteran B-R users will know that to get this information, you need to go to the team's main 2013 stats page, then mouse over the menu option marked "Batting ?", and choose "Splits". Scroll down until you find the table marked "Defensive Positions", and you'll get a list of every position along with the batting stats from players while they were in the game at that position:
One final note -- if you want to know where the team ranks among others at the position, you can go to league splits and find the same table -- clicking the position tooltip will give you a list of every team's production from that position, which you can then sort:
The Play Index is the name we use to refer to PFR's collection of top-notch research tools. Read below for more information on some of the applications we have made available to you, and also check out our blog posts about the Play Index. As always, if you have any suggestions or corrections please fill out our feedback form.
If you are composing your posts in supported blogging or bulletin board software, clicking the bookmarklet will take the text you have typed and wrap every active player's name with a link to their BBR page. We are happy to add more options if the software you use is not currently supported; just let us know.
If you are on a web page with player names in the text, select the text with your mouse and click the bookmarklet. After a few seconds, links to BBR pages for the player names that appear in the selected text will be automatically added.
Please see the linker page for full instructions and some areas to test the bookmarklet.
By itself this feature is pretty handy, but if you are a site owner you may want something in return for linking to Tim Duncan's or LaMarcus Aldridge's BBR page from your blog posts. We agree, so we have added a feature to return the link back to you.
Those stories are used to populate the "Player News" section just above the player's stats. If you are a blog owner or author, you can use our linker to automatically have your articles added to relevant player pages. If you tag your player names with links to our site — and we can find those links in your RSS feed — we will add a link to your article on the player's page. For example, this Hickory-High post is currently the first link in Tony Allen's newsfeed.
Please read this description of the service for complete details, including the information that we need from you before you can start to see your content linked from the BBR player pages.