Update on importing RateBeer data

Just wanted to drop a quick update on importing data from RateBeer...

• Looks like I have everything I need to explore working with the data/samples of exported user ratings that to some crossover users.
• At first glance, this could significantly increase the size of our beer database (especially from breweries outside of the United States).
• Next steps: is to write some scripts to play around with matching and inserting missing data, and double check to see if there's anything else I need before it's too late.

More to follow...

In the meantime, feel free to spread the word to those who might be interested.

Kipps!

Related:

• Welcome RateBeerians!
• RateBeer will cease operations as of February 1, 2025
• How to Move Your Beer Ratings from RateBeer to BeerAdvocate

 

Yeah, it's a lot of data to sort through.

 

No updates at this time other than: the scale of the project is massive, I'm one person, and I have higher priority projects that demand my attention.

 

If you mean converting to our five attributes (look, smell, taste, feel, and overall), it should be a relatively easy conversion, but the way RateBeer weighted attributes wasn't what I'd call standard for the industry. Anyway, I haven't mapped this out yet, but here's the info you'd need to make it happen.

Points that RateBeer allocated for each attribute:

Look (Appearance): 5
Smell (Aroma): 10
Taste (Flavor): 10
Feel (Palate): 5
Overall: 20

Here at BeerAdvocate we use a 1-5 point scale for each, but then apply weights to each attribute before calculating the final rating for flexibility and ease of use.

From: How to Review a Beer

Look: 6% (3)
Smell: 24% (12)
Taste: 40% (20)
Feel: 10% (5)
Overall: 20% (10)

Ours works out to be basically what the Beer Judge Certification Program (BJCP) and American Hombrewers Association (AHA) use on their beer score sheets (points noted above within the parentheses) for competitions.