Marveaux:

Good day sir, I've noticed you stress 'SQL' a lot in some of your posts,I just wanted to know, can't basic sql knowledge be augmented with a sound knowledge in pandas?
PS:forgive my naivety

Reason is that most businesses and corporate organisation store their data on database and they look for who will pull that data up.
Pandas is great but thats descriptive data analysis which many software these days can do.The advantage you have with pandas is data wrangling.

Truth be told guys. There are more offers for Data Analyst in Nigeria and in the world generally than Data Scientist . Real life business world is beyond importing data or running model and evaluating such model.
Like I said most businesses need insights to their problems. Very well. It’s very important you understand and implement simple or complex supervised learning most especially Regression models and also the KNN model when it comes to clustering. It gives you that edge. To my point. It’s easier to see offer as an analyst than data scientist because this field is still at infant stage in Nigeria.However these skills sets you above your fellow;
1. SQL: When I mean sql it’s not that SELECT * most peeps are doing. I’m talking advanced sql
2. Excel: in-fact deep in it
3. Tableau and power BI: Not drag and drop. You using Calculated fields and DAX syntax
4.Python or R
5.Pandas if you are on python
6. Machine learning. Please don’t stress yourself on deep learning. Just take that time and learn SQL well well.

Some may not know that both powerBI and Tableau can implement machine learning model.

Finally you all can try using pycaret. It makes your machine learning much simpler with just few lines of code.
In all learn all that’s linked to data. It’s very helpful.

Shout out to everyone for their contribution on this thread.. Thumbs up. To all experts, intermediate and enthusiasts. Thanks for your inputs..
Been awhile...Hope you all are having a good time..

Hey guys, some that can’t get Udemy it seems https://www.freetutorialsus.com is now live. My advice just go and download as you like.

Using it on a daily basis

Biko take MacBook Pro

nrexzy:
Nothing beats an alienware

For Windows?

Toppytek:


You forgot to add Dart before Flutter.

You right! ..
Sure thinking he already knew it

Savagethe21st:
boss what do u have to say about android developers... Do u thinks its lucrative here in nigeria?

Yes please.
Try Learning Flutter

1zynnvn:
yooo, im i the only one that noticed that computer sales advert,2mb RAM, 82mb HD .

Me too

Salem17:

If u don't mind me asking sir,why won't u date an undergraduate ?

1. You are always trying to come down to her level since you are way ahead of her
2. Poor communication as you two are of different times/age
3. They mostly feel entitled and if not convert you to assistant daddy
4. 90% of them are damn immature.

4 things in relationship I can’t do:
1. Date an undergraduate
2. Date someone not smart
3. Date someone who knows no shit about computer.
4. Date broke gal

Caxmir:


Your username says it all "CYNOSURE".

He's obviously not interested in ur quantum physics and teleportation induced sci-fi series.

have you asked him what he really likes to discuss?

As everything shouldn't be about you, you , you...... he might be a foodie, perfume freak, Bible eater, spice analyst, meat biologist but no!! you won't talk about those, forcing your opinions and topics down his keypad, making a young elder brother unhappy.


If he's not giving you the vibe u want better leave him in peace than pieces. He deserves to be happy not suffocated with meaningless rants.

As if she’s asked about her view on special relativity or time dilation she will know. Some gals sha

See them .
Feeling entitled as if it’s birth right

Kaycee54321:


Big man. Is it safe for one to rather use Rapid Miner for predictions rather than learning Sk-learn library in Python?

Just like people use Tableau/Power-Bi instead of the Matplotlib Library?

Modified: I'm asking anybody who can help with an answer too.

Please learn and implement with python so you get the underlying principles behind ML. Once you are firm just do RapidMiner or Even Orange3.

Zabiboy:


I'll say you should have an idea about both..
Most organisations dont really specify which software or library to use,.The main point is that your presentation should be simple and easy to understand..
We all learn Tableau, PowerBi , excel, matplotlib, seaborn not like we need all for one project but each of them have their own strengths and weaknesses moving forward...
In matplotlib, you can annotate( use pointers) which is not in Tableau/powerbi...but in tableau, you can get future forcast etc

So basically, the point is have an idea of all..whichever suits a project you are working on, you use it..
GL

Seems you are yet to understand the power of Tableau and PowerBI.
Tableau being the king of Data visualization was and is so powerful that SalesForce acquired it for $15.7Billion. Only place matplotlib comes ahead is animation chart of which Tableau just released this year and they are already building ontop of it.

Even Excel can annotate not talk of Tableau or PowerBI or Google Data studio or Qlik

nwele2017:

Boss, you didn't do justice to the third question on excel. Please I will like you to answer this question properly, what exactly do I need excel for in data analysis when Pandas can virtually do anything excel can do and even more?
I know excel to some extent, at least I am very good at advance Excel skills like: vlookup, pivotable, pivot chart and many more, but the thing is, I don't see any use for all these stuffs since I can do all of them with Pandas,
Please, I will really like you to answer this question.

1. For quick analysis.
2. Referencing. I suggest you add XLOOKUP & XMATCH to your arsenals
3.Communicating with your lower team. You send the excel spreadsheet
4. Your boss may be interested in only the information based on the excel and not python
5. Quick charts.
6. Infact learn Google sheet as well.
7. Financial modeling for those on accounting
8. Conditional formatting
9. Split text column. Try go deep on data validations then you understand.
10. There are so many things you can do on Excel but not with pandas.

A typical person like me daily
1. Tableau
2. SQL
3. Excel
4. Google sheet
5. PowerPoint because you must present at least a month
6. Jupyter notebook
7. Rapid miner


Hope I answered your question.

donproject:


I don't mind if you can suggest where I can start off with excel, I prefer reading books to watching tutorial videos...don't know the method that pays off in the long run, just want you to advice me on that.

Then the site you mentioned earlier, freetutorial.us or so directed me to another site I guess, onehack.com or something like that.

I’m sure someone has mentioned Excel ebook here. Try searching the comments here. I’m an advocate for Video learning as it’s more practical than ebook. Try searching for “Excel for Beginners “ on YouTube.

donproject:


Been following your topic for a while now. I can reasonably call myself a data scientist but I must confess that you are making big waves. I've been in programming world generally for a while but I never heightened my game not until recently, thanks to Corona virus.

I've read your every single update and I know plus I've earnt most of the tools you've mentioned so far. I started off with web development packages and I can categorically say I'm a developer considerably.

I started learning data science early this year but was slow with it because I'm an engineering student at my final year, project and fighting to maintain my 4 pointer. But the recent pandemic affords me enough time, so all I do now is learning one thing or the other.

I raise my eyebrow whenever I see you mentioning and emphasising that one needs to know excel for free-following ML life, I do this because I'm yet to be convinced as to its importance. I will love it if you can stress out its indispensable value that makes it one of the tools one needs for data science (especially ML).

Then on web scrapping, I crawl sites with every tool suitable for it but scrapy. I know scrapy is an advanced module created for web scrapping, but I want to ask if it is so important to add to the tools used for web scrapping, I've scrapped a lot of sites without scrapy.

Finally [this is personal to me], like I've said that I've been around for a while, though I'm not in a rush to start earning before learning, I ride on with the faith that one day will be one day for me. But your stories here and many more I've read about young techies make me wonder if I'm doing things differently because I've been all alone in my programming world. You mentioned how you got a firm that hired you shortly after you start your programming journey, I must tell you this has greatly helped in your development. My question is, how did you manage to get those interviews and even the jobs in a very short period? May be it's due to the connections you've had or you are just in the right environment. Please I need you to answer this particular question even if you decline to answer others I've asked before. Thanks.

I will answer your questions:
For the 1st question: Still hold on to your Scrapy tool even if you are doing BeautifulSoup
For the 2nd: I can’t be specific though. 4-5years ago there was a spike in Tech jobs especially once you are good with JavaScript. Then NodeJs and Angular were cute. ReactJs came to light but wasn’t fully functional. Web development role was the fastest way to land a job then. I did a lot of individual projects before applying for web role. Even up till today I get some full stack dev role that I never applied which I always decline cos I’m into DATA.
Would I say it’s chance? Maybe or maybe not.
Your CV/Resume matters. Some don’t mention their portfolio on their CV and expect to be called. While my 1st role as developer I still took nights to learn Python and data stuffs with all seriousness. I’m certain once you are done schooling and by then you build your portfolio getting an offer won’t be an issue.
I was versatile. Even to the point I learnt Automated Software testing and my chances of being called was like 70%. See, one thing I advise is when you get to any position.. don’t ever feel comfortable cos success can sometimes be a bitch that makes you not to climb the tallest building.
For Number 3: Yes Excel is powerful and I bet some that call themselves data scientist can’t do simple or complex computation on excel.
So add Excel to your arsenal.

Georgry:
Please someone should advise me, I want to learn programming from scratch and I've ordered for a laptop but I don't know if this laptop can do the job as it looks like a low end system.

Dell latitude e5500
Hdd 320gb
Ram 4gb
Graphics card 518mb
Screen size is 15
Intel core 2 duo
No webcam... Please its urgent because I'm getting the system this morning...

Cc.
Graspad
Ejiod
Elunico

That’s why we have Google Colab.
Just google Google Colab and start your data science there.

Graspad:

I'm trying to do it offline.

As a developer try leveraging the use of STACKOVERFLOW..
Simply check the solution to your question here..
https://stackoverflow.com/questions/42165649/pandas-read-csv-filenotfounderror-file-b-xe2-x80-xaaetc-despite-correct-pat

cochtrane:

We will use SQLite. But most of what will be learnt can be extended to MySQL and Postgres.
Shoot me a PM if interested. Hopefully we can get some more engagement going

Try using TablePlus

cochtrane:
As a budding data scientist who visits NL often, it's not surprising that you start to get more than interested in the some of the topics making front page and how frequent topics from individual sections reach the top. I have been looking into this for a while and thought it would be nice to do some investigation in this regard. For example, which section makes front page most often? How often do we see programming topics get to the front page? Who posts more often on the front page? Is it really lalasticlala, as is frequently supposed, or is it someone else? What exactly has been the relationship between lalasticalala and snakes over the past year? Some people think he loves to push snake topics to the frontpage more often than other topics. What else can we learn from the topics making frontpage? Like for example, are they mostly about Buhari or something else?

To this end, I scrapped the front page data and obtained more than 28,000 records. You can download this data set I obtained here on my github. If you are a data science enthusiast who also likes Nairaland, this may be good motivation to dig into a topic that interests you. You will find a metadata file in the sublink as well and can investigate what the attributes are about. You've got titles, links, sections and time that posts made front page. It's a year of data from 31st May 2019 till date. It turns out to get the whole frontpage information may need more than 230,000 records! That's huge, and probably not so wise to collect for a quick, lazy analysis. Except, of course, you have business motives

For me, I was interested in a few topics.
First, from which section did we get the most frontpage material over the past year? Apparently, it is "Politics". It trumps everything. "Celebrities" come a close second. Not surprising, right? What with the volume of Bobrisky posts and co. And then "Crime" comes third. Does this point to a high frequency of crime in Nigeria? I leave that question to you. "Programming"? Didn't even make bank one time!
The fact that politics make frontpage more often clearly shows that top on our discourse as Nigerians is probably politics, if Nairaland reflects a microcosm of the Nigerian environment, which I feel it does.

Who posts more often on the frontpage? Not lalasticlala like you might think. It's a person called dre11; at least over the last year. Maybe you know him, may you don't. Lalasticlala is not even in the top three.

One quirky thing I found, however, was that the time it takes for a post to get to frontpage has a heavily right-skewed distribution. Before plotting this, I lazily thought it might be normally distributed, cos...well, a lot of things are normally distributed and it shouldn't be unusual to have this normally distributed as well; few make front page early, few late, and most are in between. Right? On the contrary, the reality is skewed. I feel the heavy skewness probably points to deliberate human intervention. Most posts make front page early, not late. They are created and in little time pushed to the front page. Evidently in a deliberate fashion. Else the data should be normally distributed, don't you think? Anyways, that's what my data shows. Maybe, better insight could be derived though if one scraped randomly over the past several years in order to obtain a truly random sample.

And there were a few threads which made front page late. Very late! In the past year, we have had threads from 8 years ago make frontpage. Yes, 8 years ago! Thats's 2012. And then there are those that were initially posted 5 years ago before they made front page. Perhaps you can find more if you looked into the data set?

Anyways, getting your hands dirty with a data set is always a good way to learn data analysis. If you need help with navigating this, you can buzz me.

Awesome!!!!
Love this...

What do you expect from Northern peeps

Shellsploit:
Burna boy right now!

Pure savage

shiffynaani:
boss, do you suggest I learn html and css first or I go straight to python.

If data science please choose python
If web development take html & css b4 python

shiffynaani:
hello sir. I am really ready to start this my data science/analyst career but pls sir I got a couple of questions:

1) can you pls tell me where to start or refer me to a site where they will outline where I need to start to the very advance stage?

2) Can I freelance as a data analyst online and get reasonable income?

3) would you advise I study another course in school while I learn data science at my free time or I go to study it in school entirely?

Pls Sir, those are my questions for now. thanks

cc: Ejiod

For question 2 yes. Please signup on upwork to start.
For question 3 if you are not yet in school I advise you try any computer related field..

The only thing that identifies me as a Nigerian is that green passport. Aside that nothing. This country is bleeped up and will continue like that. My fellow Igbo brothers knows that. We know our country and it’s Never that forced country called Nigeria!

Stale news

Even Devil forbid

olaboy33:



Hello bro, please I just started my journey into Data Analysis. I read through your topics, I see you've helped a lot of people. Please put me through also as a beginner.

You mentioned torrent up there, I don't know what it is. I clicked on one of the link up there, it downloaded a torrent file on my mobile,.my. phone can't open it. Do I need to use a laptop to download it??

Thanks

See bros those courses are obsolete. You may need to check the other thread and see what enthusiasts are commenting on. My best take is you download from YouTube and start learning.
My key advice is start PYTHON PROGRAMMING
Then move to from side move to SQL

Toppytek:


Focus on your Forex jeje

My broda na real-time data science I de apply for trading.No gambling.