Stats: 3,191,040 members, 7,942,760 topics. Date: Saturday, 07 September 2024 at 04:23 PM |
Nairaland Forum / Science/Technology / Programming / Chronicle Of A Data Scientist/analyst (349237 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) ... (45) (46) (47) (48) (49) (50) (51) ... (147) (Reply) (Go Down)
Re: Chronicle Of A Data Scientist/analyst by DrinkWater10: 9:46pm On Jun 12, 2020 |
BoleAndFish: |
Re: Chronicle Of A Data Scientist/analyst by DrinkWater10: 1:41am On Jun 13, 2020 |
Should I learn python with PyCharm or Anaconda or Jupiter |
Re: Chronicle Of A Data Scientist/analyst by Zabiboy: 11:04am On Jun 13, 2020 |
DrinkWater10: Anyone is cool But I THINK Jupyter is better and flexible... I havnt used pycharm tho GL ![]() |
Re: Chronicle Of A Data Scientist/analyst by Oospi(m): 2:16pm On Jun 13, 2020 |
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? |
Re: Chronicle Of A Data Scientist/analyst by Zabiboy: 2:57pm On Jun 13, 2020 |
Oospi: %matplotlib inline Try this after importing matplotlib |
Re: Chronicle Of A Data Scientist/analyst by yemyke001(m): 4:36pm On Jun 13, 2020 |
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 |
Re: Chronicle Of A Data Scientist/analyst by yemyke001(m): 4:37pm On Jun 13, 2020 |
Any one with a clue should please help out. |
Re: Chronicle Of A Data Scientist/analyst by Toppytek(m): 9:18pm On Jun 13, 2020 |
yemyke001: Create a database in SQL, and create 2 tables... I stand to be corrected tho. |
Re: Chronicle Of A Data Scientist/analyst by Jay3999: 9:48pm On Jun 13, 2020 |
Please I need help installing my sql(Microsoft) on my system 2017 |
Re: Chronicle Of A Data Scientist/analyst by Zabiboy: 9:54pm On Jun 13, 2020 |
yemyke001: 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 ![]() |
Re: Chronicle Of A Data Scientist/analyst by Zabiboy: 9:55pm On Jun 13, 2020 |
Jay3999:32 or 64 bit? Where exactly do u need help? |
Re: Chronicle Of A Data Scientist/analyst by yemyke001(m): 7:52am On Jun 14, 2020 |
Toppytek: Thanks for the response. I did that. But I was told to return result on the one that gives the best result. The csv files are similar |
Re: Chronicle Of A Data Scientist/analyst by yemyke001(m): 7:53am On Jun 14, 2020 |
Zabiboy: 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 |
Re: Chronicle Of A Data Scientist/analyst by mcemmy0z: 8:25am On Jun 14, 2020 |
yemyke001: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. |
Re: Chronicle Of A Data Scientist/analyst by yemyke001(m): 9:17am On Jun 14, 2020 |
mcemmy0z: Thank you so much mcemmy0z. Please how do I convert to standard format after importing. BTW I use postgresql |
Re: Chronicle Of A Data Scientist/analyst by yemyke001(m): 9:28am On Jun 14, 2020 |
yemyke001: Moreso I believe this is more of database administration, I applied as a data analyst, or am I getting something wrong? |
Re: Chronicle Of A Data Scientist/analyst by mcemmy0z: 9:41am On Jun 14, 2020 |
yemyke001: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. 1 Like |
Re: Chronicle Of A Data Scientist/analyst by yemyke001(m): 10:32am On Jun 14, 2020 |
mcemmy0z: Thanks for being explicit bro. Really appreciate 1 Like |
Re: Chronicle Of A Data Scientist/analyst by Nobody: 11:37am On Jun 14, 2020 |
please can I get a latest version of excel without paying the fee? |
Re: Chronicle Of A Data Scientist/analyst by kunleiky(m): 11:39am On Jun 14, 2020 |
I don't know if you ever observed, when you install MYSQL, an add-in called MYSQL FOR EXCEL is automagically 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. 1 Like |
Re: Chronicle Of A Data Scientist/analyst by kunleiky(m): 12:20pm On Jun 14, 2020 |
cochtrane: 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? |
Re: Chronicle Of A Data Scientist/analyst by Toppytek(m): 12:21pm On Jun 14, 2020 |
kunleiky: I’ve seen that option before but I haven’t used it before. |
Re: Chronicle Of A Data Scientist/analyst by kunleiky(m): 1:19pm On Jun 14, 2020 |
Toppytek: 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. |
Re: Chronicle Of A Data Scientist/analyst by cochtrane(m): 2:03pm On Jun 14, 2020 |
kunleiky:Yes, it's possible to just assess the raw file directly using this link |
Re: Chronicle Of A Data Scientist/analyst by kunleiky(m): 2:06pm On Jun 14, 2020 |
Re: Chronicle Of A Data Scientist/analyst by tintedniggz(m): 8:26pm On Jun 14, 2020 |
Ejiod:Biochemistry lol, I studied that as well. Just started my data science journey, you're doing a fantastic job with this thread. |
Re: Chronicle Of A Data Scientist/analyst by Toppytek(m): 9:16pm On Jun 14, 2020 |
kunleiky: Wow, I’ll give it a try. |
Re: Chronicle Of A Data Scientist/analyst by Twirelex: 11:41pm On Jun 14, 2020 |
cochtrane:Cool... tidymodels + textrecipe would have saved you a lot of stress though... I like it when I see R programmers |
Re: Chronicle Of A Data Scientist/analyst by Dsholla: 6:05am On Jun 15, 2020 |
someone pls help me, I just finished mysql tutorials videos now, what's the next phase to continue with |
Re: Chronicle Of A Data Scientist/analyst by Toppytek(m): 7:14am On Jun 15, 2020 |
Dsholla: Excel |
Re: Chronicle Of A Data Scientist/analyst by mbhs139(m): 10:15am On Jun 15, 2020 |
https://www.udemy.com/course/the-complete-sql-masterclass-for-data-analytics/?ranMID=39197&ranEAID=tHnUyAHsRvI&ranSiteID=tHnUyAHsRvI-V0ttZdKLIzBntjLab26RWQ&utm_source=aff-campaign&utm_medium=udemyads&LSNPUBID=tHnUyAHsRvI&couponCode=JUNESEC2020 https://www.udemy.com/course/hardcore-java-with-android-and-sql-applications/?ranMID=39197&ranEAID=tHnUyAHsRvI&ranSiteID=tHnUyAHsRvI-wvxMLdRUWTf_Re4aZggymw&utm_source=aff-campaign&utm_medium=udemyads&LSNPUBID=tHnUyAHsRvI&couponCode=BB9EF7D0CCE709641469 Free courses on udemy.com on Java and SQL 1 Like 1 Share |
Re: Chronicle Of A Data Scientist/analyst by Savagethe21st(m): 4:21pm On Jun 15, 2020 |
Ejiod:boss what do u have to say about android developers... Do u thinks its lucrative here in nigeria? |
(1) (2) (3) ... (45) (46) (47) (48) (49) (50) (51) ... (147) (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. 45 |