News Analysis System using Python, Pandas, Numpy, Matplotlib , SQLite Streamlit |
Note : plz use HEADPHONE for better experience
📰 News Analysis Dashboard
This project is developed using Python, SQLite, Pandas, Plotly , and Streamlit .
The objective of this project is to analyze BBC news articles, perform category-based analysis, generate article ratings, execute SQL queries, and provide an interactive dashboard for searching and visualizing news data.
✨ Features
✔ Data Cleaning and Preprocessing
✔ Exploratory Data Analysis (EDA)
✔ SQLite Database Integration
✔ SQL Query Analysis
✔ News Rating System (1–5 Stars)
✔ Keyword Search
✔ Category Search
✔ Rating Search
✔ Interactive Dashboard
✔ Download Filtered Results
📊 Dashboard Metrics
• Total Articles
• Total Categories
• Average Article Length
• 5-Star Articles
📈 Visualizations
• Category Share
• Category Distribution
• Rating Distribution
• 5-Star Articles by Category
• Average Word Count
• Min / Avg / Max Word Count
🛠 Technologies Used
Python
Pandas
NumPy
SQLite
Plotly
Streamlit
Matplotlib
📂 GitHub Repository
https://github.com/rathorenikhil678-source...
👨💻 Developed By
Nikhil Rathore
#Python #Streamlit #SQLite #Plotly #DataAnalytics #NewsAnalysis #Dashboard #BBCNews #PythonProject #FinalYearProject
На этой странице сайта вы можете посмотреть видео онлайн News Analysis System using Python, Pandas, Numpy, Matplotlib , SQLite Streamlit | длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь nikhil 17 Июнь 2026, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 15 раз и оно понравилось 2 зрителям. Приятного просмотра!
