Sometimes, it feels good playing with real life data and getting insights from them.

The data used for this analysis was extracted from Nairaland using Webscraping (HTMLSession and Bs4)

The cleaning of the data was done using python Pandas.

The visualization part was done using Tableau.

And these questions are to be answered!

Number of topics scraped =1344 Topics (From today, 24th September)

Which topic got the Highest views? And what time of the day it was posted?

Which Topic also got the  lowest views?

Can we get the Top 10 Topic with highest views from the 1344 topics posted in the last few days or weeks

Section with most topics?

Who posted most topic? And the who were the top ten posters.

When were these Topics posted? what time of the day?
Etc.

Here, we go!

Politics section always on number one and why? Election Period or a kind of online campaign

Bigot filled political section.

Top 10 posters.

BB Naijaaaaaa.....BBNaija Live Updates is the most viewed topic..wow. with over one million views.. so people actually follow this program!!! No doubt

Nice one.

Can we get numbers of bigots on Nairaland and the top nairaland bigot amongst those dataset

These sections got the lowest topics on the front page, less than 10% of the total topic (1344) and Programming section got None.

INTROVERT:
Bigot filled political section.

Felixitie:
BB Naijaaaaaa.....BBNaija Live Updates is the most viewed topic..wow. with over one million views.. so people actually follow this program!!! No doubt

No, o. Leave them to assume the upcoming election killed interest in the show.

Hmmm. Nairaland is an entertainment / leisure forum.

Programming, technology, career, etc are guest sections.

Felixitie:
Sometimes, it feels good playing with real life data and getting insights from them.

The data used for this analysis was extracted from Nairaland using Webscraping (HTMLSession and Bs4)

The cleaning of the data was done using python Pandas.

The visualization part was done using Tableau.

And these questions are to be answered!

Number of topics scraped =1344 Topics (From today, 24th September)

Which topic got the Highest views? And what time of the day it was posted?

Which Topic also got the  lowest views?

Can we get the Top 10 Topic with highest views from the 1344 topics posted in the last few days or weeks

Section with most topics?

Who posted most topic? And the who were the top ten posters.

When were these Topics posted? what time of the day?
Etc.

Here, we go!

This is beautiful OP

This is an interesting analysis.

Well done!

What were the hours of the day those topics were posted? Data no dey lie ! Posters should focus more at posting btw the hour of 1-7pm for more coverage.

These sections got the lowest topics on the front page, less than 10% of the total topic (1344) and Programming section got None.

Thanks boss!!

qtguru:


This is beautiful OP

RepoMan007:
Hmmm. Nairaland is an entertainment / leisure forum.

Programming, technology, career, etc are guest sections.

You are right sir, but why more than half of the topics on front page are about politics? guess most members are political fanatics

Great job there…. So what’s the advantage of Tableau over matplotlib in .py?

Umarfarouksalau:
Great job there…. So what’s the advantage of Tableau over matplotlib in .py?

Interactivity and flexibility,especially when you have to create and design a dashboard without hard coding., and imagine if your data is coming from a database in real time!

I find it more comfortable and consistent having to call sql from jupyter, cleaning and visualizing in same notebook. Really works well for me though.

beautiful insights op

Omor op drop u contact make credit some airtime this you analysis and presentation is clean and professional

Deasegun19:
beautiful insights op

Many thanks!

silento:
Omor op drop u contact make credit some airtime this you analysis and presentation is clean and professional

thanks man!

Nice one bro... These are the simple features that Nairaland supposed to add.

This is beautiful and well detailed.

folake4u:
This is beautiful and well detailed.

Thanks thanks

fnep2smooth:
Nice one bro... These are the simple features that Nairaland supposed to add.

Absolutely.. a lot of them . Thanks.

Felixitie,
Great job! Very insightful analysis. Especially the time of day to get the most views. Tableau is such a powerful tool for Dashboards. And the relative ease of getting these graphs makes it such a useful tool. Na bootleg version you dey use? Laid my hands on a 2019 portable version and I've been dragging my foot on learning it. With my second job finally coming to an end I may just dive into learning it for the rest of the year and leverage the knowledge in 2023. Do you do any automations? I've been learning Microsoft Power Automate and Unipath to automate the process of data scrapping. Do you use any of those?

Would also be nice if NL could share data of locations and devices that view threads.

airsaylongcome:
Felixitie,
Great job! Very insightful analysis. Especially the time of day to get the most views. Tableau is such a powerful tool for Dashboards. And the relative ease of getting these graphs makes it such a useful tool. Na bootleg version you dey use? Laid my hands on a 2019 portable version and I've been dragging my foot on learning it. With my second job finally coming to an end I may just dive into learning it for the rest of the year and leverage the knowledge in 2023. Do you do any automations? I've been learning Microsoft Power Automate and Unipath to automate the process of data scrapping. Do you use any of those?

Would also be nice if NL could share data of locations and devices that view threads.

Thanks for the comments boss man. Tbh I just started learning Tableau, though I have experience using Power BI. Right now, I don't have full flexibility of automating due to the limited functionality of the version I use, and I don't use MS Power Automate.. but you can schedule the scraper and refresh the dashboard.

Umarfarouksalau:
I find it more comfortable and consistent having to call sql from jupyter, cleaning and visualizing in same notebook. Really works well for me though.

Well, it is about getting results and comfortability. But most time, you need to have interactive and share-able dashboard to the management or colleagues at work, no be everybody understands jupyter or coding.