Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,147,759 members, 7,798,540 topics. Date: Tuesday, 16 April 2024 at 05:16 AM

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

Nairaland Forum / Science/Technology / Programming / Chronicle Of A Data Scientist/analyst (328596 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) ... (35) (36) (37) (38) (39) (40) (41) ... (146) (Reply) (Go Down)

Re: Chronicle Of A Data Scientist/analyst by Abcruz(m): 9:32pm On May 22, 2020
dollyj1996:
thanks. which is to start with

Start with excel then learn python and it's libraries (numpy, pandas, matplotlib), thereafter learn SQL and move over to powerBI for data visualization.

5 Likes 1 Share

Re: Chronicle Of A Data Scientist/analyst by Samzeal(m): 12:46am On May 23, 2020
Abcruz:


Start with excel then learn python and it's libraries (numpy, pandas, matplotlib), thereafter learn SQL and move over to powerBI for data visualization.

To what extent can someone say he/she as learnt excel well because have been learning excel for a well now but I don't know if I have done justice to it well

1 Like

Re: Chronicle Of A Data Scientist/analyst by lizdammy: 7:16am On May 23, 2020
Ejiod:
Apologies all for this long wait..
Traffic here in Lagos can be mental sapping.
Like I said on the headline,I will be detailed on my journey...
Just to clear all doubt..I didn't study computer science or any computer related field..

TRANSITION PERIOD: After graduating from the university with my BSc Biochemistry...I felt I'm a big boy, I can apply to any firm and start earning big.... Damn, I was wrong...took real stress and effort to even get a teaching job paying less than 20k.....Then it was then I realized what I studied wasn't relevant to Nigeria...It was actually frustrating...I felt I could be better of.. Fast forward I went for MSc thinking I could get a lecturing job but even graduating with a Phd grade of 4.3 I was offered a job of under 50k....
It was then I knew I had to switch for good...
Mind you I always had a knack for computer but never did want to go into it..
Wow!

Will continue tomorrow..need to rest guys.
Re: Chronicle Of A Data Scientist/analyst by lizdammy: 7:17am On May 23, 2020
Kaycee54321:


For SQL, I use Mike's video from codecademy on YouTube.I sent you a PM. Would appreciate if you could reply.
Great

2 Likes

Re: Chronicle Of A Data Scientist/analyst by Abcruz(m): 8:36am On May 23, 2020
Samzeal:


To what extent can someone say he/she as learnt excel well because have been learning excel for a well now but I don't know if I have done justice to it well

If your familiar with it, try your hands on analyzing data with excel you can make use of the covid-19 dataset that was posted few pages back.

1 Like

Re: Chronicle Of A Data Scientist/analyst by Blesser28(m): 8:44am On May 23, 2020
lymelyte:
click on the link beneath
bro can u repost the link again haveb een tryna caal u buh that u digit aint connentng
Re: Chronicle Of A Data Scientist/analyst by Klechman(m): 12:08pm On May 23, 2020
noob03saibot:
brotherly! Nothing happened after I typed them in
Have you found solution to it, I had same issues too. This what I did, first make
Sure you downloaded the MySQL installer the offline package about 400mb not the web package. Secondly uninstall any sql and download the 400mb own, thirdly while downloading make sure your internet connection is on throughout the installation and follow the instructions. Try this out first

2 Likes 1 Share

Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 3:11pm On May 23, 2020
Klechman:

Have you found solution to it, I had same issues too. This what I did, first make
Sure you downloaded the MySQL installer the offline package about 400mb not the web package. Secondly uninstall any sql and download the 400mb own, thirdly while downloading make sure your internet connection is on throughout the installation and follow the instructions. Try this out first
dude! Thanks for this. I have been battling with it all morning, Finally had a little break through not to long ago. Firstly, It was the web version I downloaded. I uninstalled every f*cking my sql on my system, except for the raw file I downloaded on my system. Then I had to re install and rerun everything again, I made sure that my internet connection was frigging strong. Because I noticed that the first time I did it that came with that error, my data bundle exhausted, so I had to resub and then continue. This time around I wasn't taking chances o. Subed mtn 1,5 gig and ran the stuff. It went well, only that this time it was the my sql server that was now posing a problem, it came back with reconfigure. Had to do battle for almost 3hrs thanks to Google and YouTube and a huge deal of luck. Even had to go to control panel and admin tools to start changing things. can't even explain what I did. The new head ache now is, updating the start menu link coming back failed during configuration in the installer. Biko I have left it, because I noticed that the mysql editor is working fine at least for now I can log in with a password I created and get busy. And that's what I need. jeeeeeeeeez! Sorry for my bad language and long post. This stuff really messed with me. A huge thanks to you, might eventually try out what you suggested later.

2 Likes

Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 3:13pm On May 23, 2020
Zabiboy:

After inputing them, click on check first...
Then Next
thanks bro, thanks for being there to respond, I really appreciate it man. Though it didn't work. Had to redo the whole steps again. Thanks
Re: Chronicle Of A Data Scientist/analyst by Zabiboy: 4:40pm On May 23, 2020
noob03saibot:
thanks bro, thanks for being there to respond, I really appreciate it man. Though it didn't work . Had to redo the whole steps again. Thanks


grin grin
No probs...grin
Re: Chronicle Of A Data Scientist/analyst by Iamsheye(m): 5:24am On May 24, 2020
Re: Chronicle Of A Data Scientist/analyst by yemyke001(m): 4:56pm On May 24, 2020
Graspad:

https://zindi.africa/competitions/data-science-nigeria-challenge-1-loan-default-prediction
You might have to login to the website to access it
I got a best-score of 82% for this competition, who else got something better biko
Re: Chronicle Of A Data Scientist/analyst by Nobody: 5:35pm On May 24, 2020
yemyke001:
I got a best-score of 82% for this competition, who else got something better biko
That's nice.

How were you able to merge the 3 files together.
Re: Chronicle Of A Data Scientist/analyst by yemyke001(m): 8:59pm On May 24, 2020
Graspad:

That's nice.

How were you able to merge the 3 files together.
Use pd.merge(data, how='inner', on=customerid) to merge the three datasets. Do same for test dataset
Re: Chronicle Of A Data Scientist/analyst by Mrbllymer: 1:41pm On May 25, 2020
whizqueen:


Oh really?! Thank you so much. I hope you learn from them.

I’m everywhere by the way wink

I also watch your YouTube videos, lemme try and paste some links to free udemy courses that can help everyone but it will expire after some days ...

https://www.udemy.com/course/machine-learning-with-r-studio/?couponCode=MAYTE2020

https://www.udemy.com/course/machine-learning-basics-building-regression-model-in-python/?couponCode=MAYTE2020

https://www.udemy.com/course/power-bi-sales-pipeline-analytics-visualization/?couponCode=0CDE99198140CB7176AB

https://www.udemy.com/course/python-for-beginners-learn-all-the-basics-of-python/?couponCode=FREEMAY3

https://www.udemy.com/course/machine-learning-time-series-forecasting-in-python/?couponCode=MAYTE2020

3 Likes 1 Share

Re: Chronicle Of A Data Scientist/analyst by Mrbllymer: 3:14pm On May 25, 2020
whizqueen:


Noted!

I will be back from time to time as I advance my learning smiley

Thank you so much
and for those who knows how to use torrents and have access to download large files with data, I can give you udemy tutorial torrent files containing courses you might like ... Lemme know if anyone is interested.
Re: Chronicle Of A Data Scientist/analyst by akus6060(m): 3:56pm On May 25, 2020
pls someone should help out, am having issue downloading most of these softwares like Tableau, Mysql and even Anaconda for python and dont know if its due to the fact that am using window 7 with 32bits and 2gig Ram

1 Like

Re: Chronicle Of A Data Scientist/analyst by mumayo: 5:36pm On May 25, 2020
Abcruz:


Start with excel then learn python and it's libraries (numpy, pandas, matplotlib), thereafter learn SQL and move over to powerBI for data visualization.
please can you suggest good materials to learn excel from. I'm also a beginner.

1 Like

Re: Chronicle Of A Data Scientist/analyst by Toppytek(m): 6:32pm On May 25, 2020
mumayo:
please can you suggest good materials to learn excel from. I'm also a beginner.

Go to YouTube and search “E-DAB”, you should see the playlist under “Excelisfun” channel.

4 Likes 1 Share

Re: Chronicle Of A Data Scientist/analyst by Abcruz(m): 6:44pm On May 25, 2020
mumayo:
please can you suggest good materials to learn excel from. I'm also a beginner.

Go over to YouTube and search "excel for data analysis tutorials" download, learn and practice.

1 Like

Re: Chronicle Of A Data Scientist/analyst by mumayo: 7:53pm On May 25, 2020
Abcruz:


Go over to YouTube and search "excel for data analysis tutorials" download, learn and practice.
doing that already. was only asking for more specific YouTube's or website to follow. there are lots of info out there but not all is good enough for a beginner.

1 Like

Re: Chronicle Of A Data Scientist/analyst by mumayo: 7:54pm On May 25, 2020
Toppytek:


Go to YouTube and search “E-DAB”, you should see the playlist under “Excelisfun” channel.
thank you. already on excelisfun. is it enough? I'll checkout the e-dab. looks promising.

1 Like

Re: Chronicle Of A Data Scientist/analyst by brashear: 8:51pm On May 25, 2020
Please how can I get rid of a column/columns containing both empty cells and cell with zeros at once with python/r?

1 Like

Re: Chronicle Of A Data Scientist/analyst by yemyke001(m): 4:24am On May 26, 2020
brashear:
Please how can I get rid of a column/columns containing both empty cells and cell with zeros at once with python/r?

First replace the emptycells and zeros with nan values using replace function and np. Nan, then drop the nans using the dropna command in pandas

1 Like

Re: Chronicle Of A Data Scientist/analyst by Mrbllymer: 8:09am On May 26, 2020
Mrbllymer:


I also watch your YouTube videos, lemme try and paste some links to free udemy courses that can help everyone but it will expire after some days ...

https://www.udemy.com/course/machine-learning-with-r-studio/?couponCode=MAYTE2020

https://www.udemy.com/course/machine-learning-basics-building-regression-model-in-python/?couponCode=MAYTE2020

https://www.udemy.com/course/power-bi-sales-pipeline-analytics-visualization/?couponCode=0CDE99198140CB7176AB

https://www.udemy.com/course/python-for-beginners-learn-all-the-basics-of-python/?couponCode=FREEMAY3

https://www.udemy.com/course/machine-learning-time-series-forecasting-in-python/?couponCode=MAYTE2020
https://www.udemy.com/course/microsoft-power-bi-latest-2020-beginner-to-expert-modules/?couponCode=POWER901

3 Likes

Re: Chronicle Of A Data Scientist/analyst by brashear: 1:50pm On May 26, 2020
yemyke001:
First replace the emptycells and zeros with nan values using replace function and np. Nan, then drop the nans using the dropna command in pandas

Thanks sir

1 Like

Re: Chronicle Of A Data Scientist/analyst by Boxers01(m): 11:38am On May 28, 2020
Good morning guys I've got these Udemy courses, you might be interested in one.

1. Python for Data Science and Machine Learning Bootcamp by Jose Portilla.

2. Microsoft Excel - Advanced Excel Formulas and Functions by Chris Dutton & Maven Analytics.

3. Beginner to Pro in Excel: Financial Modelling and Valuation by 365 Careers.

4. Complete Python Bootcamp: Go from zero to hero in Python 3 by Jose Portilla.

5. SQL - MySQL for Data Analytics and Business Intelligence by 365 Careers.

They're not free though, I'm giving them out for 1k.

Check my signature for details on how to reach me

5 Likes 1 Share

Re: Chronicle Of A Data Scientist/analyst by Yildiz: 11:41am On May 28, 2020
This may help someone

2 Likes 1 Share

Re: Chronicle Of A Data Scientist/analyst by dauddy97(m): 8:56am On May 29, 2020
akus6060:
pls someone should help out, am having issue downloading most of these softwares like Tableau, Mysql and even Anaconda for python and dont know if its due to the fact that am using window 7 with 32bits and 2gig Ram
I can work you through the installation and even tutoring. Mind you, u will be responsible for my data/subscription. grin . If you are okay with that, quote me.

1 Like

Re: Chronicle Of A Data Scientist/analyst by Olamyyde(m): 2:20pm On May 29, 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
Are you still available sir? How do I contact you?

1 Like

(1) (2) (3) ... (35) (36) (37) (38) (39) (40) (41) ... (146) (Reply)

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

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