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
En esta página del sitio puede ver el video en línea News Analysis System using Python, Pandas, Numpy, Matplotlib , SQLite Streamlit | de Duración hora minuto segunda en buena calidad , que subió el usuario nikhil 17 junio 2026, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 15 veces y le gustó 2 a los espectadores. Disfruta viendo!
