Welcome, Guest: Join Nairaland / LOGIN! / Trending / Recent / NewStats: 2,523,948 members, 5,774,543 topics. Date: Thursday, 06 August 2020 at 11:12 PM |
Nairaland Forum / Science/Technology / Programming / Chronicle Of A Data Scientist/analyst (65067 Views)
Looking For A Data Scientist To Help Me With These Questions / 5 Steps To Become A Data Scientist / Aspiring Data Scientist. (2) (3) (4)
(1) (2) (3) ... (58) (59) (60) (61) (62) (63) (Reply) (Go Down)
Re: Chronicle Of A Data Scientist/analyst by Samzeal(m): 3:39am On Jul 28 |
am having problem in installing mysql, saying mysql workbench requires the visual c++ 2019 redistributable package to be installed. please how can i go about this. |
Re: Chronicle Of A Data Scientist/analyst by wisemania(m): 3:57am On Jul 28 |
HewlettPackard: https://drive.google.com/uc?id=1riG_93vaoPUG81V7f9dq2E95LAnhcTkc&export=download https://www.freetutorialsus.com/sql-mysql-for-data-analytics-and-business-intelligence-udemy-course-free-download/ The first teaches design while the second teaches you manipulation Take your time. 1 Like 1 Share |
Re: Chronicle Of A Data Scientist/analyst by wisemania(m): 3:58am On Jul 28 |
Samzeal: https://www.freetutorialsus.com/sql-mysql-for-data-analytics-and-business-intelligence-udemy-course-free-download/ This tutorial shows you how to go about it. |
Re: Chronicle Of A Data Scientist/analyst by Dahyormine(m): 10:46am On Jul 28 |
Samzeal:PM |
Re: Chronicle Of A Data Scientist/analyst by Henry651(m): 10:49am On Jul 28 |
Dahyormine:This is odd I know but am new here and I don’t know how I can upload a story here . |
Re: Chronicle Of A Data Scientist/analyst by Dum20: 1:50pm On Jul 28 |
[quote author=KlausMichaelson post=92136556] Thats very good. Keep it up sir. Yes you can check out *CS DOJO* and *Keith Galli* on YouTube. Check for their Videos on Intro to Data Science and Visualization, pandas, pyplot, Matplotlib, etc. They will open your eyes. Modified I use my book to take down every step about just any of the tools I'm learning from any of the videos. I literally have a jotter where I took down every steps. I do this cos I'll still go through my jottinngs whenever I'm not on my system. So It requires patience.[/quote Bro thank you for this. I am really gaining some insights and understanding the use of Python in Data Science. I am going through the Keith Galli video on "Solving Real world data science tasks with Python". It looks cool. But i observed that what is being done using Pandas and Matplolib can be done comfortably with excel(Power Queries) To me Excel is less cumbersome than typing lines of code in Python So i want to ask ogas in the house why they say they prefer Python. Looking forward to the discussion 1 Like |
Re: Chronicle Of A Data Scientist/analyst by KlausMichaelson: 3:40pm On Jul 28 |
[quote author=Dum20 post=92198951][/quote] Good day Sir to answer your question below: **But i observed that what is being done using Pandas and Matplolib can be done comfortably with excel(Power Queries)** As an intermediate, I'll like to let you know why pandas is much more flexible than Excel. Here are my reasons (1). Using Pandas, you can easily create a new cell(or column) that could do a multiple computations(addition, Subtraction, formulae etc) using values from other cells(or columns) in just a single line of code. But Excel is limited to that as you can only do it for each cell in a new column one by one and this can very cumbersome. (2). Excel doesn't help give you a visualization of your preferred taste. That doesn't mean you can't design a plot( it's axis, Gradient line, ticks and the likes). But Pandas is more flexible using Matplotlib and pyplot, you can easily give your plot a good visualization of your choice.You can easily change marker colour, line size, line colour and the likes by just a simple line of code(even shorthand notation) There are other reasons why I think Pandas/Matplotlib/Pyplot is more flexible than Excel but those are the ones I can remember at the moment. Although I stand to be corrected cos I'm still a learner. Our Pros in the house can help too |
Re: Chronicle Of A Data Scientist/analyst by randomShek: 6:52pm On Jul 28 |
Hello guys I just got the MySQL tutorial by Mosh and also downloaded the one by Mike Dane (Giraffe Academy). Which video/ course would you recommend for advance SQL Or are those two videos enough? |
Re: Chronicle Of A Data Scientist/analyst by BelieverDE: 7:53pm On Jul 28 |
KlausMichaelson:I have been learning Excel for close to 4 months. Everything you described above can be done with Excel. If you load your data to the Data Model or convert the table to an Excel Table, you can perform calculations to a column. You can also design the graph to your preferences described above. 3 Likes |
Re: Chronicle Of A Data Scientist/analyst by Dahyormine(m): 8:03pm On Jul 28 |
Henry651:reply your email, I sent you a pm |
Re: Chronicle Of A Data Scientist/analyst by ibromodzi: 8:47pm On Jul 28 |
BelieverDE: Flexibility..... |
Re: Chronicle Of A Data Scientist/analyst by ibromodzi: 8:57pm On Jul 28 |
KlausMichaelson: Any reason why ANOVA is specifically mentioned?Do you even know when to use it in a statistical analysis? Are you not supposed to focus on all the concepts of descriptive and inferential analytics if your aim is academics? See, data analysis is more than just mastering the tools, the theoretical knowledge and application of statistics are equally important. |
Re: Chronicle Of A Data Scientist/analyst by KlausMichaelson: 9:25pm On Jul 28 |
ibromodzi: Honestly, the reason why I'm very concerned about the use of ANOVA is simply because our Lecturers are always talking about it. I can actually do the calculations by the use of the various formula to get the required values for the ANOVA table. That's fine but what if I have a very large data? The truth of the matter is that they wouldn't give me a straight forward answer as to the real life application of the ANOVA design neither will they tell me when to use it specifically whenever I ask them that question. They just beat around the bush. ANOVA actually stands for Analysis of Variance and to my understanding, it is used to analyze Data that comes with a number of replications for a given Sample. It helps determine an experiment's Standard error, and some other parameters which I can't remember. My school books are far away from me at the moment. Anyways, the truth of the matter is that you're right about the fact that one needs to be grounded in not only the Practical but the theoretical part of Data Analysis. Why I felt that ANOVA table could be gotten from any of these libraries or tools is simply because of a code I came across on pandas **df.describe( )**. It brings up a table showing some statistical analysis of any data you provide for it. Maybe there is no ANOVA design from any of the tools or libraries but there is absolutely no problem. I'll work towards my other targets. |
Re: Chronicle Of A Data Scientist/analyst by KlausMichaelson: 9:30pm On Jul 28 |
BelieverDE: Wow, I haven't gotten to that level then. Thanks for the insight. Do you mean you can do a computation on a new column that requires values from other columns at just a single input? And it will also give answers to every cell in the new column? At just one single input or formula?? |
Re: Chronicle Of A Data Scientist/analyst by ibromodzi: 9:49pm On Jul 28 |
KlausMichaelson: You don't need any lecturer to tell you the type of statistics to use, your data should point you towards that. You really need to learn more about inferential statistics. There are many statistical tests available and a lot of factors need to be considered before choosing the right one. As for pandas, I wonder if you know what being an intermediate implies. df.describe() does not give you ANOVA. You still have a lot of homework to do. |
Re: Chronicle Of A Data Scientist/analyst by KlausMichaelson: 9:55pm On Jul 28 |
ibromodzi: Lols Is I never said df.describe() gives ANOVA Sir. if it gives ANOVA why then should I still be bothered about ANOVA this or ANOVA that. What I said was that df.describe() brings up a sort of table showing some statistical analysis(Mean, Std, etc) of any data you provide for it and not ANOVA sir. Anyways thanks for your advice. 1 Like |
Re: Chronicle Of A Data Scientist/analyst by ibromodzi: 10:06pm On Jul 28 |
KlausMichaelson: As a matter of fact, df.describe() just gives you an idea of the data you are dealing with. Like a statistical summary. Although, there could be more than a way to carry out in-depth inferential analytics, scipy library in conjunction with researchpy and pandas should always give you what you want. Modified: Steps in determining what tests to use in a statistical analysis; 1. What type of variables are you dealing with? Numerical or categorical? 2. What type of analysis are you doing? a. comparison (mean,median,proportion); this is where you use t-tests, ANOVA, etc.. depending on the distribution of the data(parametric or not) b. Relationship between two variables (say gender and smartness); this is where you use correlation (Pearson or Spearman rank) c. Predicting one variable from another (say exposure to smoke predicts the risk of lung cancer); this is a Regression task 3. Number of groups involved (say the effect of Chloroquine in Covid 19 and non Covid 19 patients - 2 groups) 4. Distribution of your data (Normal or not); there are different ways to determine this. I believe you now understand the point I was talking from when I mentioned theoretical knowledge of statistics. 3 Likes |
Re: Chronicle Of A Data Scientist/analyst by KlausMichaelson: 10:18pm On Jul 28 |
ibromodzi: Thank you very much Sir. I really appreciate. 1 Like |
Re: Chronicle Of A Data Scientist/analyst by HewlettPackard: 12:35am On Jul 29 |
wisemania: thanks. the first link is requesting password to the files, any help? |
Re: Chronicle Of A Data Scientist/analyst by wisemania(m): 2:31am On Jul 29 |
HewlettPackard: Getfreetutorial.com |
Re: Chronicle Of A Data Scientist/analyst by Dum20: 6:23am On Jul 29 |
BelieverDE: Excel is very powerful and graphical at the same time, you are seeing results as you go. I know @Ejiod said he outshined does using Excel it will be great if we get his thoughts and other ogas on this. |
Re: Chronicle Of A Data Scientist/analyst by Dum20: 6:23am On Jul 29 |
ibromodzi:[/b] Thank you for this 1 Like |
Re: Chronicle Of A Data Scientist/analyst by KlausMichaelson: 6:45am On Jul 29 |
ibromodzi: Yes my Oga. Thank you for this. I really appreciate Sir. 1 Like |
Re: Chronicle Of A Data Scientist/analyst by BelieverDE: 8:32am On Jul 29 |
KlausMichaelson:Yes |
Re: Chronicle Of A Data Scientist/analyst by KlausMichaelson: 8:34am On Jul 29 |
BelieverDE: Wow I never knew. Thanks |
Re: Chronicle Of A Data Scientist/analyst by BelieverDE: 8:39am On Jul 29 |
ibromodzi: Thanks 1 Like |
Re: Chronicle Of A Data Scientist/analyst by HewlettPackard: 11:00am On Jul 29 |
wisemania:Thanks man. |
Re: Chronicle Of A Data Scientist/analyst by Samzeal(m): 7:02pm On Jul 29 |
wisemania: thank you |
Re: Chronicle Of A Data Scientist/analyst by AnalysisGuru: 6:58am On Jul 30 |
Good day guys, does anyone know where to download a well structured PHP and JavaScript video, or do you know any sound teacher by name on them either on YouTube or elsewhere? Thanks in advanve |
Re: Chronicle Of A Data Scientist/analyst by Dum20: 8:14pm On Jul 30 |
Na wa ooo. Where is everyone? It seems the ogas are enjoying Sallah break |
Re: Chronicle Of A Data Scientist/analyst by HewlettPackard: 10:30pm On Jul 30 |
Regards2U: Nice. Anyway of downloading the videos for offline use? Modified: got it, service avialiable on the app. |
Re: Chronicle Of A Data Scientist/analyst by Ejiod(m): 7:19am On Jul 31 |
Hey guys.... just finished reading Medium this morning and felt like sharing. There’s currently a new revolution by tech giants now regarding content learning. Please guys try visiting Grow with Google 3 Likes 1 Share |
(1) (2) (3) ... (58) (59) (60) (61) (62) (63) (Reply)
Atm Hacks "beware" / Larry Tesler Dies! Man Who Invented Copy And Paste Is Dead. / 10 Reasons Why .NET Is Better Than Java
Viewing this topic: Dips04
(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. 203 |