Exploratory Data Analysis of the Generated Horoscopes
We conducted exploratory data analysis on the generated horoscopes for the year 2025 by the Gemma LLM.
In total we have 4,380 generated horoscopes for the entire 2025 year (365 days x 12 zodiac signs). Every horoscope has a sentiment category and one of six topic categories. We also calculated basic statistics for word count for every horoscope. The average horoscope text contains 60 words, with a standart diviation of 16 and a range of 93 (minimum 6 words, maximum 99 words).
There is no significant difference in word count statistics across different signs, with the exception of Gemini sign, which has the smallest horoscope with only 9 words:
Don't be afraid to ask for help when needed!
The longest horoscope generated belongs to Leo sign and has 99 words:
There's nothing wrong with a good dose of pampering once in a while, but it doesn't hurt to get up off your duff and go out for the day. You need some fresh air and an opportunity to shake things up a bit - if you stay cooped up at home all weekend long, you run the risk of getting bored with everything around you. It's not like there are no good options available in your neck of the woods. Even better, go for something totally new and different than what you usually do on days like this one!
It seems like several horoscopes in one. Bingo!
Sentiment Analysis
The sentiment analysis of horoscope texts reveals the following overall distribution: Neutral: 70.84%, Positive: 19.50%, Negative: 9.66% This indicates that the majority of the horoscope texts are neutral in tone, with a smaller emphasis on positivity and a minimal amount of negativity.
The distribution of sentiment varies slightly across zodiac signs:
| Zodiac Sign | Negative (%) | Neutral (%) | Positive (%) |
|---|---|---|---|
| Aquarius | 10.14 | 69.32 | 20.55 |
| Aries | 6.58 | 74.52 | 18.90 |
| Cancer | 7.67 | 74.25 | 18.08 |
| Capricorn | 8.77 | 67.95 | 23.29 |
| Gemini | 11.51 | 71.51 | 16.99 |
| Leo | 10.41 | 69.32 | 20.27 |
| Libra | 11.51 | 70.14 | 18.36 |
| Pisces | 8.22 | 73.42 | 18.36 |
| Sagittarius | 9.04 | 72.60 | 18.36 |
| Scorpio | 10.96 | 68.22 | 20.82 |
| Taurus | 7.40 | 73.15 | 19.45 |
| Virgo | 13.70 | 65.75 | 20.55 |
General Observations:
- The high proportion of neutral sentiment (70.84%) suggests that horoscopes aim to maintain broad applicability. Neutral tones allow for flexible interpretation, ensuring the advice resonates with a wide audience without being overly prescriptive or polarizing. This also aligns with the goal of horoscopes to provide guidance without inducing strong emotional reactions, which might alienate readers.
- The higher proportion of positive sentiment (19.50%) compared to negative sentiment (9.66%) reflects the genre's motivational and uplifting nature. Horoscopes are designed to inspire hope and optimism, encouraging readers to look forward to the future.
- Capricorn's horoscopes have the highest positive sentiment (23.29%), potentially reflecting their archetype as hardworking and goal-oriented. Positive reinforcement may align with their need for motivation and acknowledgment of their efforts.
- Virgo's horoscopes show the highest negative sentiment (13.70%), which could resonate with their analytical and detail-oriented personality. A cautious tone might appeal to their preference for planning and preparing for potential challenges.
- The high neutral sentiment for Aries (74.52%) and Cancer (74.25%) suggests a focus on delivering balanced, adaptable advice. This could align with Aries' need for directness and Cancer's emotional sensitivity, ensuring the tone remains approachable.
- Differences in sentiment distribution may reflect the personality traits commonly associated with each sign. For example: Aquarius and Scorpio's relatively higher positive sentiment might cater to their independent and transformative natures. Gemini and Libra's higher negative sentiment could address their tendencies for indecision or overthinking.
The sentiment distribution across months reveals seasonal patterns:
| Month | Negative (%) | Neutral (%) | Positive (%) |
|---|---|---|---|
| January | 10.22 | 70.43 | 19.35 |
| February | 9.82 | 67.56 | 22.62 |
| March | 10.22 | 69.62 | 20.16 |
| April | 11.39 | 70.28 | 18.33 |
| May | 9.41 | 72.04 | 18.55 |
| June | 9.17 | 71.39 | 19.44 |
| July | 8.60 | 74.73 | 16.67 |
| August | 8.60 | 72.58 | 18.82 |
| September | 9.44 | 69.44 | 21.11 |
| October | 7.53 | 72.85 | 19.62 |
| November | 13.61 | 68.06 | 18.33 |
| December | 8.06 | 70.70 | 21.24 |
General Observations:
- February and December exhibit the highest positive sentiment (22.62% and 21.24%), aligning with cultural and seasonal factors: February may reflect themes of renewal and love (Valentine's Day). December might emphasize celebration, gratitude, and new beginnings (holiday season and year-end reflections).
- The highest negative sentiment in November (13.61%) could correspond to themes of introspection or challenges often associated with autumn. It might also reflect a transitional period as the year approaches its end.
- July's high neutral sentiment (74.73%) might reflect a focus on balance and steadiness during midsummer, when people are more likely to seek routine and stability.
Theories and Insights:
- The variations in sentiment across months may be influenced by cultural, seasonal, and psychological factors: Positive sentiment during festive or transitional periods (e.g., New Year, Valentine's Day). Negative sentiment during months associated with introspection or challenges (e.g., late autumn).
- Sentiment distribution may be tailored to align with the traits of each zodiac sign, enhancing relatability. For example: Optimistic tones for signs like Capricorn and Sagittarius, known for their ambition and adventurous spirit. Cautionary tones for Virgo and Libra, resonating with their analytical and reflective tendencies.
- The overall balance between neutral, positive, and negative sentiment ensures that horoscopes remain engaging and relatable while minimizing the risk of alienating readers. The occasional negative sentiment may serve as a "reality check", enhancing credibility.
Category Classification
The sentiment analysis revealed the following distribution of categories across the dataset: Love and Relationships: 32%, General Life Advice or Timing: 25%, Work and Career: 23%, Health and Emotional Well-Being: 11%, Finances: 5%, Creativity and Innovation: 4%
General Observations:
- The dominance of the "Love and Relationships" category (32%) reflects its universal appeal and relevance to readers, as relationships are a central aspect of human life. This category's prevalence may also align with the traditional role of horoscopes in providing guidance on interpersonal dynamics and emotional connections.
- The significant presence of "General Life Advice or Timing" (25%) and "Work and Career" (23%) suggests that horoscopes aim to offer practical and actionable advice for navigating everyday life, work, and decision-making.
- Categories like "Finances" (5%) and "Creativity and Innovation" (4%) appear less frequently, possibly because these topics are either more niche or less traditionally associated with horoscopes.
The distribution of categories varies by zodiac sign, as shown in the table below (values represent percentages):
| Zodiac Sign | Creativity & Innovation (%) | Finances (%) | General Life Advice or Timing (%) | Health & Emotional Well-Being (%) | Love & Relationships (%) | Work & Career (%) |
|---|---|---|---|---|---|---|
| Aquarius | 5.00 | 5.00 | 27.00 | 10.00 | 32.00 | 21.00 |
| Aries | 4.00 | 4.00 | 26.00 | 12.00 | 32.00 | 21.00 |
| Cancer | 4.00 | 6.00 | 24.00 | 11.00 | 34.00 | 22.00 |
| Capricorn | 5.00 | 3.00 | 28.00 | 13.00 | 25.00 | 26.00 |
| Gemini | 6.00 | 6.00 | 26.00 | 10.00 | 28.00 | 23.00 |
| Leo | 4.00 | 4.00 | 21.00 | 9.00 | 41.00 | 22.00 |
| Libra | 3.00 | 4.00 | 21.00 | 7.00 | 42.00 | 22.00 |
| Pisces | 4.00 | 5.00 | 24.00 | 12.00 | 32.00 | 22.00 |
| Sagittarius | 6.00 | 4.00 | 25.00 | 11.00 | 30.00 | 23.00 |
| Scorpio | 4.00 | 4.00 | 26.00 | 10.00 | 35.00 | 21.00 |
| Taurus | 2.00 | 5.00 | 27.00 | 13.00 | 28.00 | 24.00 |
| Virgo | 4.00 | 5.00 | 25.00 | 11.00 | 30.00 | 25.00 |
General Observations:
- Leo (41%) and Libra (42%) show the highest focus on "Love and Relationships", aligning with their archetypes as socially oriented and relationship-focused signs. This emphasis may cater to their desire for connection and harmony.
- Capricorn and Virgo exhibit the highest proportions for "Work and Career" (26% and 25%, respectively), consistent with their reputation as diligent, goal-oriented signs. These horoscopes likely emphasize career growth and professional success.
- Cancer and Scorpio show a notable balance between categories, with "Love and Relationships" leading but also a significant presence of "General Life Advice or Timing" and "Health and Emotional Well-Being". This balance reflects their emotionally intuitive and transformative natures.
- Gemini and Sagittarius have higher-than-average proportions for "Creativity and Innovation" (6%) and "Finances" (6%), possibly catering to their curious, adaptable, and adventurous characteristics.
The distribution of categories also shows seasonal trends. The table below highlights the percentage of each category by month:
| Month | Creativity and Innovation(%) | Finances (%) | General Life Advice or Timing (%) | Health and Emotional Well-Being (%) | Love and Relationships (%) | Work and Career (%) |
|---|---|---|---|---|---|---|
| January | 5 | 4 | 30 | 9 | 27 | 25 |
| February | 6 | 4 | 26 | 11 | 27 | 26 |
| March | 5 | 4 | 23 | 10 | 32 | 26 |
| April | 5 | 6 | 24 | 15 | 28 | 23 |
| May | 3 | 4 | 25 | 12 | 32 | 23 |
| June | 4 | 6 | 23 | 8 | 38 | 22 |
| July | 2 | 5 | 30 | 9 | 30 | 24 |
| August | 6 | 4 | 25 | 11 | 33 | 21 |
| September | 4 | 4 | 20 | 12 | 38 | 21 |
| October | 5 | 4 | 23 | 11 | 36 | 21 |
| November | 4 | 6 | 24 | 13 | 35 | 19 |
| December | 3 | 3 | 26 | 9 | 33 | 24 |
General Observations:
- The peak of "Love and Relationships" in June and September (38%) may be tied to seasonal and cultural factors: June aligns with the start of summer, a time associated with social gatherings and romance. September may reflect themes of renewal and connection as people transition into autumn.
- The high proportion of "General Life Advice or Timing" in January (30%) aligns with the start of the year, when readers seek guidance for resolutions, planning, and goal-setting.
- The higher emphasis on "Health and Emotional Well-Being" in April (15%) and November (13%) may correspond to: April - themes of rejuvenation and renewal during spring; November - increased introspection and preparation for winter, often associated with health concerns and emotional reflection.
- February and December show a balanced distribution of categories, with notable emphasis on "Work and Career" (26% and 24%, respectively). This may reflect periods of professional planning (e.g., post-holiday momentum in February and year-end reviews in December).
Theories and Insights:
- The distribution of categories likely reflects cultural and seasonal patterns, such as: Romance and connection in summer months. Professional focus during transitional periods (start and end of the year). Health-related themes during spring and late autumn.
- The variation in category emphasis may cater to the perceived needs of readers based on the time of year or their zodiac sign's traits. Signs like Capricorn and Virgo, known for their practical nature, may receive more career-focused advice Romantic themes are emphasized for socially oriented signs like Leo and Libra.
- Horoscopes may strategically balance categories to maintain reader engagement. By varying the focus across months and signs, they ensure relevance and broad appeal.