cochtrane:

How do you mean?
The file format is csv. You just import it into whatever package you are using.

mcemmy0z:
Send me a pm

Olamyyde:

Sir I've been trying to send you pms, but i don't see any reply

mcemmy0z:

I replied all my mails.. drop ur mail if you won't mind

Olamyyde:

.

mcemmy0z:

Check your mail

Samzeal:

Ook

Zabiboy:


1) kaggle . com...there are millions of dataset there...or if you are still learning, i advice you check out w3resource . com, bcz they drop solution to the exercises in case you are stuck somewhere..
2) We all love MySql bro....but only after you'v mastered it...I dont think you can move excel file into MySql...i tried that when i was learning back then but it didn't work...What you can do is to duplicate the excel file and change the extension to .sql and try importing the file....If it doesnt work, i suggest yoi google it.....This is one of the major advantage Pandas have over MySql..
GL

cochtrane:

How do you mean?
The file format is csv. You just import it into whatever package you are using.

teewhydope:


please how did you scrape the data from NL using powerBI. I'm more interested in how you went about getting the sections the topics came from and the author. did you also implement it with python script

teewhydope:


please how did you scrape the data from NL using powerBI. I'm more interested in how you went about getting the sections the topics came from and the author. did you also implement it with python script

cochtrane:

I used beautiful soup. I'm working on congregating the code I used. I'll share it on my github when done.

Zabiboy:


1) kaggle . com...there are millions of dataset there...or if you are still learning, i advice you check out w3resource . com, bcz they drop solution to the exercises in case you are stuck somewhere..
2) We all love MySql bro....but only after you'v mastered it...I dont think you can move excel file into MySql...i tried that when i was learning back then but it didn't work...What you can do is to duplicate the excel file and change the extension to .sql and try importing the file....If it doesnt work, i suggest yoi google it.....This is one of the major advantage Pandas have over MySql..
GL

mcemmy0z:

You can import any text/file, either CSV or execl file to Microsoft SQL.. and have you heard about visual studio shell for importing files into SQL server?

mcemmy0z:
Check your mail

Ejiod:

Data science we speak libraries not framework(As in web development with django ur flask)... For data science there are many libraries. Mostly I use pandas,researchpy,plotly,scipy and statsmodel.
For predictive. That's much

Toppytek:


Smart babe.. hahaha

Who get money to pay for courses?

My phone has 256GB internal memory, it’s serves as my external HDD and 2nd monitor while coding.

mcemmy0z:

You can import any text/file, either CSV or execl file to Microsoft SQL.. and have you heard about visual studio shell for importing files into SQL server?

Electricboy:
what is your phone brand?

yemyke001:



Create a table in MYSQL, bearing the name of the columns in the excel file. Then right click on the table created (icon on your left) and import the csv/xlsx file to MYSQL. This should work. Although i do this with POSTGRESQL

Zabiboy:


1) kaggle . com...there are millions of dataset there...or if you are still learning, i advice you check out w3resource . com, bcz they drop solution to the exercises in case you are stuck somewhere..
2) We all love MySql bro....but only after you'v mastered it...I dont think you can move excel file into MySql...i tried that when i was learning back then but it didn't work...What you can do is to duplicate the excel file and change the extension to .sql and try importing the file....If it doesnt work, i suggest yoi google it.....This is one of the major advantage Pandas have over MySql..
GL

noob03saibot:

Brotherly! It's possible. I just did it. I followed what yemyke001 explained. Try it too bro, it works. Thanks all the same for everything. Appreciate

mcemmy0z:

I replied all my mails.. drop ur mail if you won't mind

KunSegzy100:
hello guys, i have my first assessment (aptitude test followed by interview) for data analyst role scheduled for tomorrow, kindly give me tips to aid preparation.

KunSegzy100:
hello guys, i have my first assessment (aptitude test followed by interview) for data analyst role scheduled for tomorrow, kindly give me tips to aid preparation.

KunSegzy100:
hello guys, i have my first assessment (aptitude test followed by interview) for data analyst role scheduled for tomorrow, kindly give me tips to aid preparation.

mcemmy0z:

Pm me

mcemmy0z:

Be ready to work on their data. Is one thing of knowing how to do all those data trick, plotting chat, or graph, prediction, but explaining them is the main work there, ground yourself well on how to tell a story with your data. Know how to explain a relationship between data, correlation. And you will be asked to show your previous works. If part of their requirements required you to know SQL, Google on self join, there is this one common question they use to ask, manger to employee relations. If you are going to work on python, make sure you store your code somewhere, if u are using Jupiter just create a new page or folder and store most of your code for data preprocessing and machine learning on it.. perhaventure if you will be giving any data just copy the data into the folder where you stored your code and fire on with Jupiter.
I will also advice you to use power Bi for your Visualization, tableau will be good cause of it's dashboard and story telling page, it will catch the audience than using seaborn or matplotlib.
Don't just do anything without knowing how to explain them. I can assure you that you will forget all your code.. store them well. They might ask u to present your work with power point. Be ready to defend every u will do.
Master that power Bi well, for now is really treading in Nigeria, lost a job opportunity last two months cause I was yet to mastered it then, they were looking for a professional in PowerBI and I was new to that app then.

noob03saibot:


Thank you, it worked. "I don dey feel like one mysql god now". In between, how cool is the job, database administrator? Do you know anything about it?