BoleAndFish:
What course were you trying to download?

Should I learn python with PyCharm or Anaconda or Jupiter

DrinkWater10:

Anyone is cool
But I THINK Jupyter is better and flexible...
I havnt used pycharm tho
GL

Oospi:
Good day all, newbie here....I was working on some data that involved choropleth maps but I just can't get the maps to display on Jupyter notebook. All I see is the colorbar, I only get to see the map when I go online...any pointers on how I can see the choropeth maps offline?

yemyke001:
Please @Ejiod and any other person vast in sql, please how do I test a query? I was given two excel files and was told to test the query on the environment. Please I need help on this

yemyke001:
Please @Ejiod and any other person vast in sql, please how do I test a query? I was given two excel files and was told to test the query on the environment. Please I need help on this

Could have helped...buh i cant really comprehend ur question...
Maybe u can make it clearer
Have you tried googling it tho...it could help
GL

Jay3999:
Please I need help installing my sql(Microsoft) on my system 2017

Toppytek:


Create a database in SQL, and create 2 tables... I stand to be corrected tho.

Zabiboy:


Could have helped...buh i cant really comprehend ur question...
Maybe u can make it clearer
Have you tried googling it tho...it could help
GL

yemyke001:


I was given two csv files that are similar, and I was told to test the query on the environment and return the one that gives the right result. Still confused till now. It was an interview question

mcemmy0z:

Those two files might look the same on your eye but they are different. Import the two of them into SQL,( MSQL will do better), try and query them u will realized that it will return error, so u will have to convert them to standard format that you will be able to query them easily. But from the question u were asked, one will surely work while you will have to convert the other one.. creating a new table for it will do or u use the normal conversation in the beginning when importing them.
So still go learn ETL process.

yemyke001:



Thank you so much mcemmy0z. Please how do I convert to standard format after importing. BTW I use postgresql

yemyke001:



Moreso I believe this is more of database administration, I applied as a data analyst, or am I getting something wrong?

mcemmy0z:

Not data base... U know when dealing with real data u have to be careful, a professional in SQL will tell never to import data directly.. you Know data analysis/ science is an art u can do many things to achieve same results.
Although I started with PostgrSQL then moved to mysql, I later realised I can be more flexible in Microsoft SQl than the rest. Although there are different ways to convert data, after importing them u can create a new table and copy the data into the new table. Have created a store procedures on my MSQl just to convert any data within 5 minutes.
I was using visual studio shell before but all the process has been added to the lastest Msql version, but using VSS for ETL is still cool cause within it u can do some data clearing, removing NaN values, or unnecessary column and doing some adjustments.

cochtrane:

Download it here

kunleiky:
I don't know if you ever observed, when you install MYSQL, an add-in called MYSQL FOR EXCEL is automagalically added to Excel. That add-in allows you to easily import data to and from MySQL using Excel. It's under the DATA tab of Excel. Check it out.

Toppytek:


I’ve seen that option before but I haven’t used it before.

kunleiky:


If I may ask cochtrane, is it possible to download from Github using a mobile device, or it's best done on a PC, cos I've been trying to download this dataset and it's only bringing the data raw,only allowing me to copy and paste, unfortunately not everything is copying.
Also is it possible to scrape it directly from Github?

cochtrane:

Yes, it's possible to just assess the raw file directly using this link

Ejiod:

I've always been good in maths. Infact did
further maths then in school and even got C5 in it.
It was sheer foolishness that lured me to biochemistry.

kunleiky:


It's really cool, very intuitive. You can create a new schema/table rght in there, and import your data into it, then commit. Voila, you have the data in MySQL.

cochtrane:
Finally. this won't be complete without mentioning the resultant "Confusion Matrix".
Managed to create a visualization for it. When visualized, we see that for most of the sections, the correct prediction was made. There were a few sections where probably not enough values to form a cell. These appear to be "Programming", "Pets", etc. Red cells mean zero. For example, there were no successful predictions for "Webmasters". Light cells mean successful predictions. Most of the cells along the diagonal are light, correlating with the fairly good accuracy obtained.
If this catches your interest, you can download the notebook here on my github and play around with it, if you want. The code is in R.

Dsholla:
someone pls help me, I just finished mysql tutorials videos now, what's the next phase to continue with

Ejiod:
Out of the 3,
One from from lekki asked me to analyze data as assessment of which I pythonize it,running pandas and Power BI on it.Had to utilize all my skills to solve the problem.This was a big edge I had over others.Some excel users will be calling theirselves data analyst but they are just far from it... before you knew it,in just a week I got a notification that "Can I resume the following week" with a net pay of 180k. Damn!... I was so so happy... first data analyst job and the best thing about it was that it was remote..No transport, just me in my house and I report to boss every Friday what I've been doing.
Had to share my story too to freetutorials.us because they were helpful with tons of tutorials I downloaded from them.
Fast forward..4 month into the job damn, I started expanding and experimenting my skills. I became more of a Business intelligence developer. Before a year, I've toured round 15 states in Nigeria all by flight....
I loved what I was doing then,but one thing about remote job is that sometimes it may make you lazy and extravagant sometimes. Its then you will be thinking of going to cinema to watch film or event centers......