Uma editora está constantemente em busca de maneiras de entender melhor as preferências de seus leitores. Ao utilizar dados de avaliações de livros disponíveis publicamente, uma editora pode tomar decisões mais informadas sobre quais livros destacar, quais autores promover, e quais gêneros têm maior probabilidade de sucesso. Este projeto visa realizar uma análise exploratória de um conjunto de dados de avaliações de livros, o que ajudará a identificar tendências de popularidade e qualidade com base na opinião dos leitores.
Este estudo utiliza dois conjuntos de dados disponíveis publicamente: um com avaliações de livros retiradas da Amazon e outro com informações detalhadas sobre os livros extraídas da Google Books API. A análise incluirá limpeza de dados, tratamento de valores ausentes e a criação de novas variáveis que possibilitem insights mais profundos.
A abordagem proposta inclui a exploração das avaliações de livros, considerando aspectos como a utilidade das resenhas, as notas atribuídas e as características dos autores e editoras. Com isso, espera-se identificar padrões de popularidade, qualidade e envolvimento dos usuários, que possam servir de insumo para decisões editoriais estratégicas.
Esta análise permitirá à editora compreender melhor o que os leitores valorizam nas resenhas, quais autores e editoras estão gerando mais engajamento, e quais características dos livros (gênero, preço, etc.) podem estar correlacionadas com notas mais altas. Esses insights poderão ser usados para otimizar estratégias de marketing, aprimorar a curadoria de títulos e melhorar a interação com os leitores.
A análise foi realizada utilizando os seguintes pacotes:
library(dplyr) # Manipulação de dados
library(tidyr) # Funções de separação e tratamento de dados
library(stringr) # Manipulação de strings
library(knitr) # Formatação de tabelas
library(ggplot2) # Visualizações gráficas
Os dados utilizados neste projeto foram obtidos da plataforma Kaggle, mais especificamente do dataset Amazon Books Reviews. Este dataset contém avaliações e metadados de livros da Amazon, coletados entre maio de 1996 e julho de 2014. Ele é parte de um dataset maior de avaliações de produtos da Amazon, totalizando 142,8 milhões de avaliações.
O dataset original é composto por dois arquivos:
Ratings.csv: Contém avaliações de aproximadamente 3 milhões de usuários para 212.404 livros únicos. Ele possui as seguintes colunas:
| Coluna | Descrição |
|---|---|
| id | ID do livro |
| Title | Título do livro |
| Price | Preço do livro |
| User_id | ID do usuário que avaliou o livro |
| profileName | Nome do usuário que avaliou o livro |
| review/helpfulness | Avaliação de utilidade da review (ex: 2/3) |
| review/score | Nota do livro (0 a 5) |
| review/time | Data da avaliação (timestamp Unix) |
| review/summary | Resumo da avaliação |
| review/text | Texto completo da avaliação |
Books.csv: Contém informações adicionais sobre os livros, incluindo título, autores, editora, e categorias.
Para garantir que os dados estivessem prontos para análise, foi necessário realizar as seguintes etapas de limpeza:
O conjunto de dados limpo contém as colunas de interesse, organizadas e prontas para a análise exploratória. Abaixo está uma amostra dos primeiros registros limpos:
| Title | Helpfulness Numerator | Helpfulness Denominator | Score | Text |
|---|---|---|---|---|
| Its Only Art If Its Well Hung! | 7 | 7 | 4 | This is only for Julie Strain fans. It’s a collection of her photos – about 80 pages worth with a nice section of paintings by Olivia.If you’re looking for heavy literary content, this isn’t the place to find it – there’s only about 2 pages with text and everything else is photos.Bottom line: if you only want one book, the Six Foot One … is probably a better choice, however, if you like Julie like I like Julie, you won’t go wrong on this one either. |
| Dr. Seuss: American Icon | 10 | 10 | 5 | I don’t care much for Dr. Seuss but after reading Philip Nel’s book I changed my mind–that’s a good testimonial to the power of Rel’s writing and thinking. Rel plays Dr. Seuss the ultimate compliment of treating him as a serious poet as well as one of the 20th century’s most interesting visual artists, and after reading his book I decided that a trip to the Mandeville Collections of the library at University of California in San Diego was in order, so I could visit some of the incredible Seuss/Geisel holdings they have there.There’s almost too much to take in, for, like William Butler Yeats, Seuss led a career that constantly shifted and metamoprhized itself to meet new historical and political cirsumstances, so he seems to have been both a leftist and a conservative at different junctures of his career, both in politics and in art. As Nel shows us, he was once a cartoonist for the fabled PM magazine and, like Andy Warhol, he served his time slaving in the ad business too. All was in the service of amusing and broadening the minds of US children. Nel doesn’t hesitate to administer a sound spanking to the Seuss industry that, since his death, has seen fit to license all kinds of awful products including the recent CAT IN THE HAT film with Mike Myers. Oh, what a cat-astrophe!The book is great and I can especially recommend the work of the picture editor who has given us a bounty of good illustrations. |
| Dr. Seuss: American Icon | 10 | 11 | 5 | If people become the books they read and if “the child is father to the man,” then Dr. Seuss (Theodor Seuss Geisel) is the most influential author, poet, and artist of modern times. For me, a daddy to a large family who learned to read with Dr. Seuss and who has memorized too many of the books via repeated readings to young children, Prof. Nel’s brilliant ‘American Icon’ is a long awaited treat. At last a serious treatment of this remarkable genius that is both an engaging read and filled with remarkable insights! I especially enjoyed (and learned more than I care to admit from) Prof. Nel’s discussions of the Disneyfication of Seuss - which Nel links to failings in American copyright law, “the other sides of Dr. Seuss” - all of which sides were new to me, and the political genesis of his secular morality in the WWII cartoon work he did at PM magazine. The chapters on Geisel’s poetry and artwork and the link Nel makes between Seuss and the historical avant guarde alone make this book a “must buy” for parents and serious readers, not to mention public libraries. Readers of Nel’s other books will find the same engaging writing style that makes the book a fun read while imparting a mountain of information and important ideas. This is simply the best and most comprehensive book yet written on the work of Seuss Geisel and what will certainly be the standard for many years to come. Thank you, Prof. Nel, wherever you are, from a reader who grew up with the good doctor and who is growing up with him again years later. Your book, written from your encyclopeadic knowledge of children’s literature and the media of this genre - from scanning verse to cubist painting! - explains the power, limits, and popularity of the Seuss phenomenon. |
| Dr. Seuss: American Icon | 7 | 7 | 4 | Theodore Seuss Geisel (1904-1991), aka "Dr. Seuss," was one of the most influential writers and artists of the 20th century.In 1959, Rudolf Flesch wrote, "A hundred years from now, children and their parents will still eagerly read the books of a fellow called Ted Geisel, popularly known as Dr. Seuss."Flesch was too conservative in his prediction. A century, and more, from today, Dr. Seuss will still be read when many authors on today’s bestseller lists will be forgotten.Published on the centenary of Geisel’s birth, Dr. Seuss: American Icon analyzes six key aspects of Seuss’s career: poetry, politics, art, biography, marketing, and influence.In six insightful chapters, Philip Nel, Assistant Professor of English at Kansas State University, discusses "U.S. Laureate of Nonsense," "Dr. Seuss vs. Adolf Hitler," "The Doc in the Smock," "The 5,000 Fingers of Dr. S.," "The Disneyfication of Dr. Seuss," and "The Cat in the Hat for President."Nel gives short shrift to Geisel’s childhood and family background–and, indeed, to biography in general–preferring to focus on Seuss’s writing and art, from his first book, And to Think That I Saw It on Mulberry Street (1937) to his last book, Oh, the Places You’ll Go! (1990).Dr. Seuss’s breakthrough year was 1957, when he published the two books with which he is most often identified: The Cat in the Hat and How the Grinch Stole Christmas!Other classic works in the Seussian canon are: Horton Hears a Who! ("A person’s a person, no matter how small"), Yertle the Turtle (modeled on the rise of Adolf Hitler), Green Eggs and Ham (Seuss’s bestselling book), The Sneeches (a criticism of anti-Semitism), The Lorax (a protest against corporate abuse of the environment), and The Butter Battle Book (a critique of Reagan’s enthusiasm for the nuclear arms trace).His favorite work, among the books he authored, was The Cat in the Hat, for it, more than any other, taught children to read.While many of his books have a clear and powerful moral, Seuss had a horror of heavy-handed preaching. He sought to teach and ignite the imagination, but was a lifelong opponent of smug, self-righteous bourgeois moralism."Seuss was a contrarian," writes Nel, "who enjoyed challenging people to reconsider their assumptions. [He had a] rebellious imagination and a dispositional distaste for rules and regulations." His work was a "rational insanity" that exhibited "joyous anarchy" and a "lifelong thrill in misbehaving."A better subtitle for Nel’s work would have been American Icon and Iconoclast.Nel tells of Seuss’s early years as an advertising artist and as a agitprop cartoonist. The book, however, is not a biography; it is a serious study in the genres of literary and art criticism.For readers who want more biographical information, Nel recommends Dr. Seuss and Mr. Geisel, by Judith Morgan and Neil Morgan (1995), which he describes as "the definitive biography and the single best secondary source on Seuss. Any discussion of Seuss’s life and work must begin with this book."Dr. Seuss: American Icon includes 103 pages of notes, index, and the most comprehensive annotated Seuss bibliography ever assembled. One learns a lot from this book; the author’s lucid style makes it not only an enlightening work but a fun read.Philip Nel is the author of J. K. Rowling’s Harry Potter Novels: A Reader’s Guide (2001) and The Avant-Garde and American Postmodernity (2002).Roy E. Perry of Nolensville, Tennessee, is an advertising copywriter at a Nashville publishing house. |
| Dr. Seuss: American Icon | 3 | 3 | 4 | Philip Nel - Dr. Seuss: American IconThis is basically an academic overview of Seuss poetry, art, cartoons, and the problems with the commercialization of the Seuss name and works after his death. It is not, to any real extent, a biography. Those seeking such should move on.As an academic book it leans on the dry side. It assumes the reader has a fairly good knowledge of Children’s Literature and 20th Century cartoons (not the animated kind). Not a book to begin your Dr. Seuss experience with. But if you have read them to your children and are interested about the writing style (there is a good chapter about his poetry) or his art style (not as good a chapter, but still interesting).What interested me the most was the deconstruction of the recent rush to “cash in” on Seuss by Hollywood and advertisers. I think that Nel wants to come down against it, but based on Seuss’ background (he started out drawing Flit ads) and the projects he approved during his lifetime; it is a tough argument to make. In the end though Nel does point out that maybe the movies and tie- ins did not have to be so… crass?The book is well researched; lots of neat tidbits are to be gleamed. Early cartoons by Seuss for PM magazine were occasionally (by today’s standards) shockingly racist. It makes him a little more human and puts his latter works like the Lorax in a new light.Those in Education may enjoy this background. Fans of Seuss will enjoy the exhaustive bibliography of Seuss’s many, many works. Also good list of other works about the man. |
| Dr. Seuss: American Icon | 2 | 2 | 4 | “Dr. Seuss: American Icon” by Philip Nel is a thoughtful deconstruction of the life and work of Theodore Geisel (aka Dr. Seuss). In this thoughtful book, Mr. Nel deepens our appreciation for Seuss as a distinctively American poet, artist and educator. The author demonstrates Seuss’ wide ranging influence and argues for his rightful place among the most important cultural figures of the 20th century.An English professor at Kansas State University, Mr. Nel uses his historic knowledge to discuss how Seuss’ text belongs to a tradition of great nonsense writers. Mr. Nel states that Seuss’ carefully-constructed absurdist tales encourage children to challenge the status quo by gently skewering the grown-up world; elsewhere, he uses charts to show how Seuss effectively used meter and rhyme to complement his intentionally ridiculous plots and create masterful stories that have stood up well to the test of time.Mr. Nel recounts Seuss’ early career as advertising illustrator and political cartoonist to help us better understand the influences that shaped his classic children’s work. As an artist, Mr. Nel suggests that the term “energetic cartoon surrealism” appropriately describes Seuss’ creative synthesis of cubism, art nouveau, surrealism and other styles. While Seuss’ influence can be detected in modern rap music, children’s books, political cartoons and more, Mr. Nel contends that Seuss would not have been happy about the manner in which his works have been posthumously marketed, opining that the “Disneyification” or simplification of Seuss’ stories for marketable purposes “threatens to make ‘Seuss’ synomynous with the ambiguous power of global capitalism”. Such commercialism would appear to collide with Seuss’ desire to develop critical thinking among young people and to help us all imagine a better world.I highly recommend this book for everyone interested in gaining greater insight and perspective into one of America’s greatest creative talents. |
| Dr. Seuss: American Icon | 3 | 4 | 5 | Theodor Seuss Giesel was best known as ‘Dr. Seuss’, one of the most influential and enduringly popular children’s authors of the 20th century. Giesel created not only his famous imaginative picturebooks, but a unique art and poetry, and even a place for himself in politics. Philip Nel argues that these added activities make Dr. Seuss one of the most influential people in America - certainly the most influential poet - and Dr. Seuss: American Icon provides the reader an memorably excellent survey of Dr. Seuss’ many achievements. |
| Dr. Seuss: American Icon | 0 | 0 | 5 | When I recieved this book as a gift for Christmas my first impression went along these line: “Oh great some professor who probably wrote alot of mumbo-jumbo that I don’t want to know about Dr. Suess and I know it won’t be an enjoyable read.”Thanks goodness I read it nonetheless.To my pleasure, Nel hardly writes in the airy academia style with which I expected him to. In fact, he’s writes so far from it, with a smart and precise style, I am tempted to revise how I feel about professor-writers. However, in accordance with his academia roots, Nel has a 100 page annotated bibliogarphy that goes along with his work, a nice shrine to prove his homework was well done.As far the actual book goes it is an excellent piece work. “Dr. Seuss: American Icon” looks at the man behind Dr. Suess not as a straight-forward biography, but rather it focuses on different areas of Dr. Suess (i.e. poet, poetry of, artist, artistic style, adult, activist, etc.) and interjects those discussions with biogrphical anecdotes. A very effective attention keeping method.If you’re interested in learning more about the work and the man behind the work of Dr. Suess, this is the book that speaks to both and even more. Highly recommended! |
| Dr. Seuss: American Icon | 0 | 0 | 5 | Trams (or any public transport) are not usually the best place to read and absorb scholarly texts. But this one has accompanied me on my daily commute, and I have been absorbed in it. It is well written and comprehensive, and tells the tale of a modern author, with plenty of “Fancy that” and “Well, well” moments. Highly recommended for stationary reading, too. |
| Dr. Seuss: American Icon | 3 | 5 | 4 | As far as I am aware, this is the first book-length study of the work of Dr. Seuss, and Philip Nel has done an excellent job. If the word ‘study’ makes you nervous, rest assured: this is not a jargon-filled, pretentious analysis. It is, instead, a nicely written work that views Seuss from several different angles: as a poet, a visual artist, a cartoonist, and so on. Nel writes intelligently on how Seuss fits into the canon of nonsense poets, and provides good background on the roots of Seuss’s visual style. Some of the WW2/political cartoon material I had read about before, but Nel covers it thoroughly. The most fascinating chapter to me deals with the marketing of Seuss, particularly since his death. Nel holds forth strongly on the abominable ‘Grinch’ movie (and I trust he feels the same way about the ‘Cat in the Hat’ film too), and gets into a very interesting discussion of the possible motivations behind the ever-expanding empire of Dr. Seuss Enterprises. (And no, I don’t believe it is purely about the profits!)Two small quibbles prevent me from awarding five stars. Firstly, I would have liked the book to be a little longer. The in-depth bibliography is interesting in itself and will be a goldmine to future researchers, but I’m sure Nel could have found a few more things to say - perhaps about Seuss’s gender politics. Secondly, the dust jacket on my copy was a little loose. |
| Title | Authors | Publisher | Categories | Ratings Count |
|---|---|---|---|---|
| Its Only Art If Its Well Hung! | Julie Strain | Comics & Graphic Novels | 0 | |
| Dr. Seuss: American Icon | Philip Nel | A&C Black | Biography & Autobiography | 0 |
| Wonderful Worship in Smaller Churches | David R. Ray | Religion | 0 | |
| Whispers of the Wicked Saints | Veronica Haddon | iUniverse | Fiction | 0 |
| Nation Dance: Religion, Identity and Cultural Difference in the Caribbean | Edward Long | 0 | ||
| The Church of Christ: A Biblical Ecclesiology for Today | Everett Ferguson | Wm. B. Eerdmans Publishing | Religion | 5 |
| The Overbury affair (Avon) | Miriam Allen De Ford | 0 | ||
| A Walk in the Woods: a Play in Two Acts | Lee Blessing | 3 | ||
| Saint Hyacinth of Poland | Mary Fabyan Windeatt | Tan Books & Pub | Biography & Autobiography | 0 |
| Rising Sons and Daughters: Life Among Japan’s New Young | Steven Wardell | Plympton PressIntl | Social Science | 0 |
Nesta seção, será feita a análise dos dados dos livros, focando em três aspectos principais: popularidade por autor e editora, análise por categoria e a relação entre preço e número de avaliações. Também será explorada a utilidade dos comentários dos usuários.
Para entender quais autores e editoras têm mais avaliações e qual é a média das notas que recebem, as seguintes análises podem ser feitas:
Observação: Para um gráfico menos poluído, apenas os tops 10 foram mostrados.
Neste passo, foi analisado como diferentes categorias de livros se comparam em termos de número de avaliações e média das notas.
Foi explorado como o preço dos livros se relaciona com o número de avaliações recebidas.
## [1] "Correlação entre preço e quantidade de avaliações: -0.01"
Foram investigados também quais comentários dos usuários são considerados mais úteis com base na proporção de utilidade.
| title | helpfulness_ratio | comment |
|---|---|---|
| You Can Have Your Cheese and Eat It Too!: A Complete Guide for Closing the Gap Between Where You Are and Where You Want to Be | 2 | There are over 15 credible book endorsers for this new "Cheese" book which takes the hunt for your cheese to a new level. A must read for anyone interested in self-improvement. It is also a humorous read for mental health professionals and business managers alike. |
| Dr. Seuss: American Icon | 1 | I don’t care much for Dr. Seuss but after reading Philip Nel’s book I changed my mind–that’s a good testimonial to the power of Rel’s writing and thinking. Rel plays Dr. Seuss the ultimate compliment of treating him as a serious poet as well as one of the 20th century’s most interesting visual artists, and after reading his book I decided that a trip to the Mandeville Collections of the library at University of California in San Diego was in order, so I could visit some of the incredible Seuss/Geisel holdings they have there.There’s almost too much to take in, for, like William Butler Yeats, Seuss led a career that constantly shifted and metamoprhized itself to meet new historical and political cirsumstances, so he seems to have been both a leftist and a conservative at different junctures of his career, both in politics and in art. As Nel shows us, he was once a cartoonist for the fabled PM magazine and, like Andy Warhol, he served his time slaving in the ad business too. All was in the service of amusing and broadening the minds of US children. Nel doesn’t hesitate to administer a sound spanking to the Seuss industry that, since his death, has seen fit to license all kinds of awful products including the recent CAT IN THE HAT film with Mike Myers. Oh, what a cat-astrophe!The book is great and I can especially recommend the work of the picture editor who has given us a bounty of good illustrations. |
| Its Only Art If Its Well Hung! | 1 | This is only for Julie Strain fans. It’s a collection of her photos – about 80 pages worth with a nice section of paintings by Olivia.If you’re looking for heavy literary content, this isn’t the place to find it – there’s only about 2 pages with text and everything else is photos.Bottom line: if you only want one book, the Six Foot One … is probably a better choice, however, if you like Julie like I like Julie, you won’t go wrong on this one either. |
| Whispers of the Wicked Saints | 1 | Normally I’m not much into romance stories but I absolutely loved this book. This book had the right kind of suspense that made it impossible to put down. Kept me wondering what would happen right up until the end. Loved it! I am looking for anything else this author puts out. |
| Wonderful Worship in Smaller Churches | 1 | Many small churches feel like they can not have great worship because they lack the resources that larger churches take for granted.Ray’s list of “thou shalts” is worth the price of the book.The description of various “personalities” in the small church is both humorous, and so true.This book gives encouragement as well as practical advice. |
A análise revelou vários insights importantes:
Popularidade por Autor e Editora: Alguns autores e editoras destacam-se pela quantidade de avaliações que recebem. Para editoras, investir em novos livros e edições de autores em destaque pode ser uma estratégia eficaz. Outro ponto importante seria estudar as estratégias de marketing e de produção das editoras em destaque.
Categorias de Livros: Determinadas categorias são mais populares e recebem mais avaliações. Explorar mais dessas categorias também pode ser benéfico.
Relação Preço e Avaliações: Livros mais baratos tendem a receber mais avaliações, indicando que o preço é um fator significativo no número de avaliações que um livro recebe. Procurar mais informações sobre livros nessa faixa de preço e o que faz com que eles consigam ser vendidos à esse valor, podem ajudar a popularizar os livros da editora.
Utilidade dos Comentários: Comentários úteis ajudam a entender melhor a recepção dos livros pelos leitores. Analisá-los ajuda a saber o que faz com que o leitor goste do livro, e isso é muito importante para decidir e guiar futuras edições e estratégias de marketing.
Estas análises oferecem uma base sólida para decisões estratégicas, ajudando a entender a dinâmica entre preço, popularidade e feedback dos usuários.
Embora a análise forneça uma visão abrangente dos dados disponíveis, há algumas limitações que devem ser consideradas, e há várias maneiras de melhorar e expandir a análise. Aqui estão algumas limitações e sugestões para aprimorar a análise: