News Analysis System using Python, Pandas, Numpy, Matplotlib , SQLite Streamlit |

Published: 17 June 2026
on channel: nikhil
15
2

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


On this page of the site you can watch the video online News Analysis System using Python, Pandas, Numpy, Matplotlib , SQLite Streamlit | with a duration of hours minute second in good quality, which was uploaded by the user nikhil 17 June 2026, share the link with friends and acquaintances, this video has already been watched 15 times on youtube and it was liked by 2 viewers. Enjoy your viewing!