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
Nesta página do site você pode assistir ao vídeo on-line News Analysis System using Python, Pandas, Numpy, Matplotlib , SQLite Streamlit | duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário nikhil 17 Junho 2026, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 15 vezes e gostou 2 espectadores. Boa visualização!
