Welcome, Guest: Join Nairaland / LOGIN! / Trending / Recent / New
Stats: 2,483,457 members, 5,624,003 topics. Date: Thursday, 28 May 2020 at 04:34 PM

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

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

Looking For A Data Scientist To Help Me With These Questions / Data Scientist Only / Aspiring Data Scientist. (2) (3) (4)

(1) (2) (3) ... (35) (36) (37) (38) (Reply) (Go Down)

Re: Chronicle Of A Data Scientist/analyst by Abcruz(m): 9:32pm On May 22
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.

1 Like

Re: Chronicle Of A Data Scientist/analyst by Samzeal(m): 12:46am On May 23
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
Re: Chronicle Of A Data Scientist/analyst by lizdammy: 7:16am On May 23
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
Kaycee54321:


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

1 Like

Re: Chronicle Of A Data Scientist/analyst by Abcruz(m): 8:36am On May 23
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.
Re: Chronicle Of A Data Scientist/analyst by Blesser28(m): 8:44am On May 23
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
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

1 Like 1 Share

Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 3:11pm On May 23
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.
Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 3:13pm On May 23
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
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

Re: Chronicle Of A Data Scientist/analyst by yemyke001(m): 4:56pm On May 24
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 Graspad(f): 5:35pm On May 24
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
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

1 Like

Re: Chronicle Of A Data Scientist/analyst by Mrbllymer: 3:14pm On May 25
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: 3:56pm On May 25
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
Re: Chronicle Of A Data Scientist/analyst by mumayo: 5:36pm On May 25
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.
Re: Chronicle Of A Data Scientist/analyst by Toppytek(m): 6:32pm On May 25
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.

1 Like 1 Share

Re: Chronicle Of A Data Scientist/analyst by Abcruz(m): 6:44pm On May 25
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.
Re: Chronicle Of A Data Scientist/analyst by mumayo: 7:53pm On May 25
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.
Re: Chronicle Of A Data Scientist/analyst by mumayo: 7:54pm On May 25
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.
Re: Chronicle Of A Data Scientist/analyst by brashear: 8:51pm On May 25
Please how can I get rid of a column/columns containing both empty cells and cell with zeros at once with python/r?
Re: Chronicle Of A Data Scientist/analyst by yemyke001(m): 4:24am On May 26
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
Re: Chronicle Of A Data Scientist/analyst by Mrbllymer: 8:09am On May 26

2 Likes

Re: Chronicle Of A Data Scientist/analyst by brashear: 1:50pm On May 26
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
Re: Chronicle Of A Data Scientist/analyst by Boxers01(m): 11:38am
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

Re: Chronicle Of A Data Scientist/analyst by Yildiz: 11:41am
This may help someone

1 Like 1 Share

(1) (2) (3) ... (35) (36) (37) (38) (Reply)

Web Application Development Contest: Jajad Wins / Nigerians To Represent Africa At The Hacker Olympics / Game Development: Join The Team

Viewing this topic: dollyj1996(m)

(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 - 2020 Oluwaseun Osewa. All rights reserved. See How To Advertise. 351
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.