Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,206,718 members, 7,996,561 topics. Date: Thursday, 07 November 2024 at 11:30 AM

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

Nairaland Forum / Science/Technology / Programming / Chronicle Of A Data Scientist/analyst (355857 Views)

Chronicle Of A Data/cloud Engineer / Net Salary For A Data Analyst Or Scientist Or Web Dev / Aspiring Data Scientist. (2) (3) (4)

(1) (2) (3) ... (16) (17) (18) (19) (20) (21) (22) ... (147) (Reply) (Go Down)

Re: Chronicle Of A Data Scientist/analyst by 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

Re: Chronicle Of A Data Scientist/analyst by 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.
Re: Chronicle Of A Data Scientist/analyst by 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

Re: Chronicle Of A Data Scientist/analyst by 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

Re: Chronicle Of A Data Scientist/analyst by ibromodzi: 3:37pm On Mar 31, 2020
Chukwudaalu:
I've been working on the data I downloaded 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

Re: Chronicle Of A Data Scientist/analyst by Ejiod(m): 5:02pm On Mar 31, 2020
DAY 1: GET DATA

Task one was to pull the data directly online rather than downloading.
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 = {'user-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

Re: Chronicle Of A Data Scientist/analyst by 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.
Re: Chronicle Of A Data Scientist/analyst by 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.
Re: Chronicle Of A Data Scientist/analyst by 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.
Re: Chronicle Of A Data Scientist/analyst by 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 downloaded mine from the Microsoft store... its is about 360mb+

2 Likes

Re: Chronicle Of A Data Scientist/analyst by wisdomremz(m): 12:14am On Apr 01, 2020
damtan:
Who knows where I can download data to use for tableau practice??
Or if anyone can upload a set of data to download

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

2 Likes 1 Share

Re: Chronicle Of A Data Scientist/analyst by 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 contact you?? Will you drop your number or should I PM you??

5 Likes

Re: Chronicle Of A Data Scientist/analyst by mcemmy0z: 12:42am On Apr 01, 2020
petux:


Bro I stay in Sango, and I need them badly... Please how should I contact you?? Will you drop your number or should I PM you??
Re: Chronicle Of A Data Scientist/analyst by Kaycee54321(m): 1:11am On Apr 01, 2020
Ejiod:
DAY 1: GET DATA

Task one was to pull the data directly online rather than downloading.
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 = {'user-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

Re: Chronicle Of A Data Scientist/analyst by Kaycee54321(m): 1:13am On Apr 01, 2020
wisdomremz:



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


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

1 Like

Re: Chronicle Of A Data Scientist/analyst by 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

Re: Chronicle Of A Data Scientist/analyst by 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
Re: Chronicle Of A Data Scientist/analyst by 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
Re: Chronicle Of A Data Scientist/analyst by 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

Re: Chronicle Of A Data Scientist/analyst by 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

Re: Chronicle Of A Data Scientist/analyst by 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 pass anything please....

1 Like

Re: Chronicle Of A Data Scientist/analyst by 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

15 Likes

Re: Chronicle Of A Data Scientist/analyst by 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 pass 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 3 Shares

Re: Chronicle Of A Data Scientist/analyst by 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.
Re: Chronicle Of A Data Scientist/analyst by 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
Re: Chronicle Of A Data Scientist/analyst by 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 downloaded videos from YouTube to help me with it.

4 Likes 1 Share

Re: Chronicle Of A Data Scientist/analyst by 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 pass 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.

12 Likes 1 Share

Re: Chronicle Of A Data Scientist/analyst by 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 pass 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

Re: Chronicle Of A Data Scientist/analyst by 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

Re: Chronicle Of A Data Scientist/analyst by 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

20 Likes 7 Shares

Re: Chronicle Of A Data Scientist/analyst by 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

Re: Chronicle Of A Data Scientist/analyst by 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

(1) (2) (3) ... (16) (17) (18) (19) (20) (21) (22) ... (147) (Reply)

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

Viewing this topic: 1 guest(s)

(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. 45
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.