Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,153,238 members, 7,818,809 topics. Date: Monday, 06 May 2024 at 04:57 AM |
Nairaland Forum / Science/Technology / Programming / Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau (780 Views)
Any Demand For Good Users Of Power BI And Tableau In Nigeria / Notice the nairaland layout changes / Mysql And Tableau Programmers (2) (3) (4)
Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Felixitie(m): 9:47pm On Sep 24, 2022 |
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! 5 Likes 2 Shares |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Felixitie(m): 9:50pm On Sep 24, 2022 |
Politics section always on number one and why? Election Period or a kind of online campaign 2 Likes 1 Share
|
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by INTROVERT(f): 9:58pm On Sep 24, 2022 |
Bigot filled political section. 3 Likes |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Felixitie(m): 10:02pm On Sep 24, 2022 |
Top 10 posters. 1 Like
|
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Felixitie(m): 10:31pm On Sep 24, 2022 |
BB Naijaaaaaa.....BBNaija Live Updates is the most viewed topic..wow. with over one million views.. so people actually follow this program!!! No doubt 2 Likes
|
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by OgaTheTop2: 10:51pm On Sep 24, 2022 |
Nice one. Can we get numbers of bigots on Nairaland and the top nairaland bigot amongst those dataset 4 Likes |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Felixitie(m): 11:12pm On Sep 24, 2022 |
These sections got the lowest topics on the front page, less than 10% of the total topic (1344) and Programming section got None. 1 Like 1 Share |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Felixitie(m): 11:55pm On Sep 24, 2022 |
INTROVERT: |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by meobizy(f): 5:31am On Sep 25, 2022 |
Felixitie:No, o. Leave them to assume the upcoming election killed interest in the show. |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by RepoMan007: 8:29am On Sep 25, 2022 |
Hmmm. Nairaland is an entertainment / leisure forum. Programming, technology, career, etc are guest sections. |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by qtguru(m): 8:40am On Sep 25, 2022 |
Felixitie: This is beautiful OP 3 Likes |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Magnoliaa(f): 8:52am On Sep 25, 2022 |
This is an interesting analysis. Well done! 1 Like |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Felixitie(m): 11:39am On Sep 25, 2022 |
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.
|
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Felixitie(m): 11:42am On Sep 25, 2022 |
These sections got the lowest topics on the front page, less than 10% of the total topic (1344) and Programming section got None.
|
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Felixitie(m): 11:45am On Sep 25, 2022 |
Thanks boss!! qtguru: |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Felixitie(m): 11:48am On Sep 25, 2022 |
RepoMan007: You are right sir, but why more than half of the topics on front page are about politics? guess most members are political fanatics |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Umarfarouksalau: 12:00pm On Sep 25, 2022 |
Great job there…. So what’s the advantage of Tableau over matplotlib in .py? |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Felixitie(m): 12:11pm On Sep 25, 2022 |
Umarfarouksalau: 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! |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Umarfarouksalau: 12:21pm On Sep 25, 2022 |
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. 1 Like |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Deasegun19(m): 12:36pm On Sep 25, 2022 |
beautiful insights op 1 Like |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by silento(m): 12:50pm On Sep 25, 2022 |
Omor op drop u contact make credit some airtime this you analysis and presentation is clean and professional 1 Like |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Felixitie(m): 12:57pm On Sep 25, 2022 |
Deasegun19: Many thanks! 1 Like |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Felixitie(m): 12:58pm On Sep 25, 2022 |
silento: thanks man! |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by fnep2smooth(m): 1:44pm On Sep 25, 2022 |
Nice one bro... These are the simple features that Nairaland supposed to add. |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by folake4u(f): 2:29pm On Sep 25, 2022 |
This is beautiful and well detailed. 1 Like |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Felixitie(m): 4:57pm On Sep 25, 2022 |
folake4u: Thanks thanks 1 Like |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Felixitie(m): 4:58pm On Sep 25, 2022 |
fnep2smooth: Absolutely.. a lot of them . Thanks. |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by airsaylongcome: 5:47pm On Sep 25, 2022 |
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. 1 Like |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Felixitie(m): 6:28pm On Sep 25, 2022 |
airsaylongcome: 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. |
Re: Analysis Of The Nairaland's Front Page Topics, Using Python And Tableau by Felixitie(m): 7:03pm On Sep 26, 2022 |
Umarfarouksalau: 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. |
(1) (Reply)
Help Me To Finetune The Code / Help In Unlocking My System / How To Use Java.awt In Apple (using Safari As Browser)
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 40 |