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
Sur cette page du site, vous pouvez voir la vidéo en ligne News Analysis System using Python, Pandas, Numpy, Matplotlib , SQLite Streamlit | durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur nikhil 17 juin 2026, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 15 fois et il a aimé 2 téléspectateurs. Bon visionnage!
