NewStats: 3,260,867 , 8,172,852 topics. Date: Tuesday, 27 May 2025 at 10:15 PM 5kg17

6z3e3g

Chronicle Of A Data Scientist/analyst - Programming (19) - Nairaland 1k6j6o

Chronicle Of A Data Scientist/analyst (383863 Views)

(4)

Go Down)

eddy1759: 1:32pm On Mar 31, 2020
Please can you recommend any book or video to learn excel for someone without prior knowledge to it

1 Like

Chukwudaalu(m): 1:51pm On Mar 31, 2020
Ejiod:

Where is the error coming from and how’s your data like?.. can you make use of seaborn?
I'm trying to compare the number of confirmed cases in the US, and Nigeria. The data is in 2D array. The error is with the dates, trying to figure it out. Seaborn? I'm currently learning it on datacamp. I don't mind if you could put me through with seaborn. I appreciate your efforts.
BoleAndFish: 2:01pm On Mar 31, 2020
Chukwudaalu:
My battery lasted up to 4hrs then, before I spoilt it. Now, it works with light grin
How did you spoil it? So that I'll take caution too.

Apologies sir, Ejiod.

1 Like

Chukwudaalu(m): 2:32pm On Mar 31, 2020
BoleAndFish:
How did you spoil it? So that I'll take caution too.

Apologies sir, Ejiod.
Always putting it on sleep mode to charge then. Please don't let us derail from the topic. You can send a private message for further enquiries.

1 Like 1 Share

ibromodzi: 3:37pm On Mar 31, 2020
Chukwudaalu:
I've been working on the data I ed through the link you posted. I had to extract, and rearrange the needed data on Excel, then load the data using Pandas on python. But I'm currently stuck on visualizing the data with a chart using matplotlib. Been getting errors since, not giving up though. I successfully did the analysis on Excel. But I am currently working on analyzing it using matplotlib too.
I'm actually working on some other programming projects outside Data Science, reason for the delay. Thanks bro.

You could have used pandas for cleaning the data, it does it like magic... Matplotlib sucks for visualization, I used plotly for that, the only problem I'm having is saving my figures since it doesn't work like matplot and seaborn...

If you want to see my solution, I can drop the ipynb file in your mail.

1 Like

Ejiod(m): 5:02pm On Mar 31, 2020
DAY 1: GET DATA

Task one was to pull the data directly online rather than ing.
Some using jupyter notebook I already have it on the ipynb which you can always rerun.Also the excel file of the data. The data is dirty which needs to be clean


To get online data use this,

from bs4 import BeautifulSoup
import requests
import pandas as pd
s = requests.Session()
s.headers = {'-agent': 'Corona'}
page = s.get('https://www.worldometers.info/coronavirus/')
data = pd.read_html(page.text)[0]
data.to_excel('Corona.xlsx')


Will continue tomorrow.

22 Likes 7 Shares

gargoylern: 5:07pm On Mar 31, 2020
Chukwudaalu:
I'm trying to compare the number of confirmed cases in the US, and Nigeria. The data is in 2D array. The error is with the dates, trying to figure it out. Seaborn? I'm currently learning it on datacamp. I don't mind if you could put me through with seaborn. I appreciate your efforts.
post your error message here. Someone can tell you a solution.
Chukwudaalu(m): 8:39pm On Mar 31, 2020
gargoylern:

post your error message here. Someone can tell you a solution.
I still want to try all possible solutions before bringing it out. I will sure inform the house if error persists. I so much appreciate.
Chukwudaalu(m): 8:40pm On Mar 31, 2020
ibromodzi:


You could have used pandas for cleaning the data, it does it like magic... Matplotlib sucks for visualization, I used plotly for that, the only problem I'm having is saving my figures since it doesn't work like matplot and seaborn...

If you want to see my solution, I can drop the ipynb file in your mail.
I wouldn't mind bro. I've sent you a private message.
wisdomremz(m): 12:12am On Apr 01, 2020
Kaycee54321:


Wow. 4GIG RAM isn't enough for them?


I use HP notebook 15 4gig Ram and power BI works just fine... I ed mine from the Microsoft store... its is about 360mb+

2 Likes

wisdomremz(m): 12:14am On Apr 01, 2020
damtan:
Who knows where I can data to use for tableau practice??
Or if anyone can a set of data to

do u have any data wrangling skill with any of the programming languages such as Python Or R?

2 Likes 1 Share

petux(m): 12:21am On Apr 01, 2020
mcemmy0z:
If you reside around songo Ota I have these available
*Udemy - Beginner to Pro in Excel Financial Modeling and Valuation
*Udemy - SQL - MySQL for Data Analytics and Business Intelligence
*Tableau 10 A-Z Hands-On Tableau Training For Data Science!
*Tableau Hands-on Learn Data Visualization with Tableau
*Udemy - Power BI A-Z Hands-On Power BI Training For Data Science
*Udemy - Machine Learning A-Z™ Hands-On Python & R In Data Science
*Udemy - Python for Financial Analysis and Algorithmic Trading

Bro I stay in Sango, and I need them badly... Please how should I you?? Will you drop your number or should I PM you??

5 Likes

mcemmy0z: 12:42am On Apr 01, 2020
petux:


Bro I stay in Sango, and I need them badly... Please how should I you?? Will you drop your number or should I PM you??
Kaycee54321(m): 1:11am On Apr 01, 2020
Ejiod:
DAY 1: GET DATA

Task one was to pull the data directly online rather than ing.
Some using jupyter notebook I already have it on the ipynb which you can always rerun.Also the excel file of the data. The data is dirty which needs to be clean


To get online data use this,

from bs4 import BeautifulSoup
import requests
import pandas as pd
s = requests.Session()
s.headers = {'-agent': 'Corona'}
page = s.get('https://www.worldometers.info/coronavirus/')
data = pd.read_html(page.text)[0]
data.to_excel('Corona.xlsx')


Will continue tomorrow.

Every Data tells a story. Here's mine. From the excel file here, I was able to create a simple dashboard in Excel using pivot charts and pivot tables.

Covid-19 started in China. Right now though, they have the highest number of recovered cases in the World and they're currently not even in the top ten countries list with current active cases....Let me not type much. Let the dashboard speak for itself.

15 Likes

Kaycee54321(m): 1:13am On Apr 01, 2020
wisdomremz:



I use HP notebook 15 4gig Ram and power BI works just fine... I ed mine from the Microsoft store... its is about 360mb+


Let me try again. I just hope it works. Thanks.

1 Like

OgogoroDegree: 3:46am On Apr 01, 2020
mcemmy0z:
If you reside around songo Ota I have these available
*Udemy - Beginner to Pro in Excel Financial Modeling and Valuation
*Udemy - SQL - MySQL for Data Analytics and Business Intelligence
*Tableau 10 A-Z Hands-On Tableau Training For Data Science!
*Tableau Hands-on Learn Data Visualization with Tableau
*Udemy - Power BI A-Z Hands-On Power BI Training For Data Science
*Udemy - Machine Learning A-Z™ Hands-On Python & R In Data Science
*Udemy - Python for Financial Analysis and Algorithmic Trading

1 Like

damtan(m): 9:58am On Apr 01, 2020
wisdomremz:


do u have any data wrangling skill with any of the programming languages such as Python Or R?
Still learning with Python
ibromodzi: 10:05am On Apr 01, 2020
Chukwudaalu:
I wouldn't mind bro. I've sent you a private message.

Oops.... Email not active, check the updated one
wisdomremz(m): 11:27am On Apr 01, 2020
damtan:
Still learning with Python

can u use python visualization library lyk matplotlib, seaborn, plotly?

1 Like

damtan(m): 12:09pm On Apr 01, 2020
wisdomremz:



can u use python visualization library lyk matplotlib, seaborn, plotly?
I'm actually working with matplotlib

1 Like

trigar12(m): 12:54pm On Apr 01, 2020
Hello enthusiasts,

Can anyone please point me to a good YouTube video that major on:

1. Data science with the use of jupyter notebook please.

2. Data analysis with the use of Microsoft excel.

I need am anything please....

1 Like

damtan(m): 1:34pm On Apr 01, 2020
No skill is actually a waste sha. Some years ago, out of boredom, I started using Mavis Beacon typing tutor to whirl away time anytime I had nothing doing. I became so good and very fast with typing without looking at the keyboard overtime.
Learning to use Python for data analysis would have been more difficult for me if my typing skill was whack. I'm glad I learnt to type smiley

16 Likes

Toppytek(m): 5:01pm On Apr 01, 2020
trigar12:
Hello enthusiasts,

Can anyone please point me to a good YouTube video that major on:

1. Data science with the use of jupyter notebook please.

2. Data analysis with the use of Microsoft excel.

I need am anything please....

For Data Science you can start with this

https://www.youtube.com/watch?v=vmEHCJofslg



For Data Analysis with Excel, search for “Excelisfun” on YouTube, go through the playlists.

13 Likes 4 Shares

Toppytek(m): 5:04pm On Apr 01, 2020
damtan:
No skill is actually a waste sha. Some years ago, out of boredom, I started using Mavis Beacon typing tutor to whirl away time anytime I had nothing doing. I became so good and very fast with typing without looking at the keyboard overtime.
Learning to use Python for data analysis would have been more difficult for me if my typing skill was whack. I'm glad I learnt to type smiley

Till today am still angry with my whack typing skill, more reason I want a system with an integrated keyboard backlight.
trigar12(m): 8:27pm On Apr 01, 2020
Toppytek:


For Data Science you can start with this

https://www.youtube.com/watch?v=vmEHCJofslg



For Data Analysis with Excel, search for “Excelisfun” on YouTube, go through the playlists.

Thank you bro
Oddy16: 10:12pm On Apr 01, 2020
Grandlord:
So many driven contributors. Cool.

Anyone on here taking up challenges on Kaggle?

I did Titanic and House Prices, but the one I can defend wella is Titanic. Doing it really exposed me to Data Wrangling and Feature Engineering. I looked up on different notebooks and ed videos from YouTube to help me with it.

4 Likes 1 Share

Oddy16: 10:28pm On Apr 01, 2020
trigar12:
Hello enthusiasts,

Can anyone please point me to a good YouTube video that major on:

1. Data science with the use of jupyter notebook please.

2. Data analysis with the use of Microsoft excel.

I need am anything please....

I'm trying to answer no 1 without complicating it for you. You can search Edureka's 9hrs video on Machine Learning, they did a good job there. If you can, please try Kaggle. You will see lots of Jupyter notebooks you can look at to guide you through. Google tutorials on the use of jupyter notebook, Dataquest did justice to that.........https://www.dataquest.io/blog/jupyter-notebook-tutorial/ When you feel you are ready to practice, pick up Titanic competition on Kaggle. There are so many notebooks that will guide you through.
NB: Kaggle can get overwhelming. You may feel lost being there, but continue anyway.

14 Likes 1 Share

Oddy16: 10:35pm On Apr 01, 2020
trigar12:
Hello enthusiasts,

Can anyone please point me to a good YouTube video that major on:

1. Data science with the use of jupyter notebook please.

2. Data analysis with the use of Microsoft excel.

I need am anything please....


The beginner friendly video I watched that introduced me to jupyter was Mosh's YouTube video on Python, the section where he discussed Machine learning.

5 Likes 2 Shares

engrjoe(m): 10:53pm On Apr 01, 2020
Hi guys please I need assistance on Data analysis. I am currently using youtube to learn SQL but I am not getting it well enough but I am very interested. Anyone around Ijaye, Kola, Alakuko, Tollgate or Sango area (Lagos) who can help me please.

Thanks you

1 Like

Oddy16: 11:23pm On Apr 01, 2020
engrjoe:
Hi guys please I need assistance on Data analysis. I am currently using youtube to learn SQL but I am not getting it well enough but I am very interested. Anyone around Ijaye, Kola, Alakuko, Tollgate or Sango area (Lagos) who can help me please.

Thanks you

Have you tried Mike Dane's (Giraffe Academy) video on MySQL?.... I learnt with it.


https://www.youtube.com/watch?v=HXV3zeQKqGY

21 Likes 7 Shares

trigar12(m): 11:32pm On Apr 01, 2020
Oddy16:



The beginner friendly video I watched that introduced me to jupyter was Mosh's YouTube video on Python, the section where he discussed Machine learning.

Yea I am at that section but he didn't really explain it deeply, I want a more detailed video that was why I asked, thank you

1 Like 1 Share

trigar12(m): 11:33pm On Apr 01, 2020
Oddy16:


I'm trying to answer no 1 without complicating it for you. You can search Edureka's 9hrs video on Machine Learning, they did a good job there. If you can, please try Kaggle. You will see lots of Jupyter notebooks you can look at to guide you through. Google tutorials on the use of jupyter notebook, Dataquest did justice to that.........https://www.dataquest.io/blog/jupyter-notebook-tutorial/ When you feel you are ready to practice, pick up Titanic competition on Kaggle. There are so many notebooks that will guide you through.
NB: Kaggle can get overwhelming. You may feel lost being there, but continue anyway.

Thank you, I will check it out

Reply)

I Want To Learn Programming. Which Language Should I Start With?

(Go Up)

Sections: How To . 49
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or s on Nairaland.