Name: Daily Public Opinion On Israel-Palestine War
Creator: Kaggle
License: https://opendatacommons.org/licenses/by/1-0/index.html

About this Dataset

Daily Public Opinion On Israel-Palestine War

The Israel-Palestine conflict has been a highly discussed and sensitive topic in recent times.

This dataset contains comments from Reddit posts related to the current situation in Israel and Gaza.

By analyzing these comments, you can gain insights into the biases and affiliations of the commenters, as well as their support for different parties involved.

This dataset is updated daily, providing a comprehensive and up-to-date view of the sentiments expressed on Reddit regarding this conflict.

If you find this dataset valuable, don't forget to hit the upvote button! 😊💝

Interesting Task Ideas:

Perform sentiment analysis to determine the overall sentiment of the comments towards Israel and Palestine.
Identify the most biased subreddits and understand their stance on the conflict.
Analyze the comment scores to uncover trends and popular opinions.
Explore temporal patterns to understand how sentiments evolved over time.
Determine the most commonly used keywords and phrases in the comments.
Investigate the relationship between subreddit affiliations and the sentiments expressed.
Identify the most common emotions found in the comments.
Analyze the most popular posting hours to determine the location of the authors
Investigate the response of users to the sentiment of the comment by analyzing the scores for different comment sentiments

2023-11-19 Update

Since a few kagglers asked to add more data points to this dataset, i've created a new csv called "reddit_opinion_PSE_ISR.csv".

This csv has data about the comment, the author of the comment, and the post the comment was posted on.

This is a denormalized dataset. You can normalize the dataset by splitting posts, comments, and user data into 3 seperate tables/dataframes.
Old dataset csv can be found inside the legacy folder. Old csv won't be updated daily
On the new version, there are no duplicate comment ids, but there will be duplicate posts (post ids) since a post can have many comments, and authors (author names) since a single user can leave many comments.

Tables

Pse Isr Reddit Comments

@kaggle.asaniczka_reddit_on_israel_palestine_daily_updated.pse_isr_reddit_comments

130.09 MB
769,651 rows
5 columns

CREATE TABLE pse_isr_reddit_comments (
  "comment_id" VARCHAR,
  "score" BIGINT,
  "self_text" VARCHAR,
  "subreddit" VARCHAR,
  "created_time" TIMESTAMP
);