DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports Events Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Join us today at 1 PM EST: "3-Step Approach to Comprehensive Runtime Application Security"
Save your seat
  1. DZone
  2. Data Engineering
  3. Data
  4. Understanding the Book-Crossing Dataset: Visualizing Status Data

Understanding the Book-Crossing Dataset: Visualizing Status Data

Sadayuki Furuhashi user avatar by
Sadayuki Furuhashi
·
Sep. 16, 12 · Interview
Like (0)
Save
Tweet
Share
6.00K Views

Join the DZone community and get the full member experience.

Join For Free

when you look around amazon for book reviews, you notice that some users are consistently harsher than others. for example, some users never give five stars. this observation goes the other way around too. some users are so generous with stars that the worst they would ever give is three out of five even if the review itself is a litany of complaints. let’s call them harsh and generous, respectively.

and there is another group of users that we might conflate with harsh and generous: lazy. lazy users do not put much effort into rating books. they just pick an arbitrary rating because they have an extrinsic motivation (ex: getting something for free by cranking out reviews). if lazy users decide to always rate books at 5/10 or 10/10, they might appear harsh or generous although they are just lazy in reality.

defining harsh, generous and lazy

take a look at this graph:

based on this graph, let’s define harsh, generous and laxy as follows:

  • generous: always gives 9 or higher.
  • harsh: always gives 5 or lower.
  • lazy: always gives the same rating and has rated more than 5 times.

the “more than 5 times” condition for the lazy is intended to filter out infrequent reviewers (hence, the lazy is not so lazy after all — at least they submit a lot of reviews!)

query 1: counting harsh, generous and lazy

result     :
+-------------+-----+
| rating_type | cnt |
+-------------+-----+
| generous    | 137 |
| harsh       | 64  |
| lazy        | 137 |
+-------------+-----+

there are 105283 users that have rated at least one book, so, generous/harsh/lazy all account for ~0.1% of the users.

a closer look at the lazy

let’s look at the distribution of lazy users.

query 2: distribution of lazy users.

result     :
+-------------+-----+
| book_rating | cnt |
+-------------+-----+
| 5.0         | 53  |
| 6.0         | 1   |
| 7.0         | 3   |
| 8.0         | 8   |
| 9.0         | 4   |
| 10.0        | 68  |
+-------------+-----+

interestingly, lazy users prefer to give 5 (the middle rating in this 1-10 scale) or 10 (the maximum) to any other numbers.

notes on the harsh and the generous

to wrap up this entry, i will give a few remarks about the harsh and the generous. here is a question: which books are affected the most by the harsh and the generous?

query 3 & 4 answer this question. because the original definition of the harsh and the generous had very few samples, we relaxed the definitions to “those who rate 6 or lower” and “those who rate 8 or higher.” those hive queries are pretty hairy, but it goes to show how much analysis you can actually do just in hiveql . those queries list books that are 20 books most impacted by the generous and the harsh, respectively.

top 20 impacted by the generous

top 20 impacted by the harsh

what’s intriguing is that the two lists do not overlap at all. the lack of overlap suggests that the harsh and the generous might be attracted to different types of books. finding out which feature effectively separates the harsh from the generous can bring insights to both authors and publishers.

Book Data (computing)

Published at DZone with permission of Sadayuki Furuhashi, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • A Brief Overview of the Spring Cloud Framework
  • API Design Patterns Review
  • How Observability Is Redefining Developer Roles
  • What Is a Kubernetes CI/CD Pipeline?

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends: