Thanks for the upload. Great video. Hope it helps with my interview tomorrow!
@funnytime71432 ай бұрын
thank you
@ayushsrivastava99972 ай бұрын
It should be >= 10 million coz its atleast right?
@filmweaver20133 ай бұрын
Matlab, best of both worlds..!
@zacharygibbs23553 ай бұрын
Intro to statistical learning now has exercises in Python as well!
@HatTerry4 ай бұрын
Much Appreciated!
@Brentfindley4 ай бұрын
20 seconds in and my boy is cutting deep with that question 🫡
@ezhankhan10354 ай бұрын
Incredibly helpful video! Thanks Aaron :)
@scharlesworth935 ай бұрын
Dude you are cool definitely subscribe
@scharlesworth935 ай бұрын
R is a secret power, Python is cool but R levels you up
@user-zh4yw4kn1u5 ай бұрын
Thank you for your guidance God bless you brother ❤❤❤❤❤❤
@LA-sw1gv5 ай бұрын
Thanks for sharing this. It is really helpful in showing how to think logically and work through the question.
@julianwilson99196 ай бұрын
In 2023 (or 2024), learn Julia! It's come a long way in the last few years. R and Python are still great choices but they're far from the only options these days for data science.
@user-lc9uv6mm6n6 ай бұрын
cool video)
@thewhitedragon41846 ай бұрын
I know this video is old, but like when you mentioned jupyter notebooks for python, it's kinda baffling that you didn't mention the fact that R should be fully support in jupyter, since the idea with those is mixed code blocks. So you can have markdown blocks and python blocks and R blocks, Julia and even c blocks if you hack it enough. I watched this video because I'm already fairly proficient in python and was thinking should I learn R and when you mentioned both, Jupyter is the first thing that comes to mind
@prison98656 ай бұрын
I have been working with R for a year now and i been concluded, go with python. It does matter when it comes to technicality
@jabaltariq46066 ай бұрын
Name one (1) of the top 25 department of statistics in the world that use Python to analyze data? I'll wait. What do "you" (impersonal) now about data analysis that statisticians do not know? Python wastes a lot of time to do some simple data analysis tasks.
@aidanthompson50536 ай бұрын
18:16
@aidanthompson50536 ай бұрын
SQL is a coding language used to interact with relational databases MySQL is a software used to implement those relational databases
@aidanthompson50536 ай бұрын
SQL is an abstraction; a language - there’s no implementation involved, just coding syntax MySQL is a piece of software, a relational database management tool that allows you to: use a graphical interface to update schemas, to define data types to give users permissions or revoke them etc.
@aidanthompson50536 ай бұрын
There are 4 main types of joins: Inner, outer, left, right An inner join retrieves records that have matching values in both tables involved in the join An outer join retrieves records where there is a match in either the left or right table Left join retrieves records from the left table and the matched records from the right table Right join retrieves records from the right table and the matched records from the left table
@aidanthompson50536 ай бұрын
A join us a function in SQL that allows a user to combine 2 different tables based on a set of logic and the columns from those tables that the user defines
@aidanthompson50536 ай бұрын
A primary key is a unique, non-nullable identifier for each record in a table and it can be either 1 column or multiple columns. However, each table can only have one primary key.
@nifftbatuff6766 ай бұрын
Why in 2023 Python is still behind R for data analysis and visualization?
@markvilla77967 ай бұрын
is this really the interview question? or the assessment? I'm sorry don't have an idea but want to learn. Please no bad comment. Thank you so much.
@aishwaryapattnaik30827 ай бұрын
Why do you start something which you can't finish...its over 3 months now
@bhuvanmohinidevi1947 ай бұрын
That was so helpful! Thank you so much big brother!
@kc78188 ай бұрын
For the last problem, wouldn't it make sense to include "GROUP BY name" at the end of the query, since an actor could have appeared in multiple movies with Art Garfunkel, causing them to be listed multiple times? That didn't happen in this case, so the solution is correct either way, but if you take out the "AND name != 'Art Garfunkel'" at the end, his name shows up three times in the output, one for each movie he was in, so this would be a problem if an actor appeared in multiple movies with him.
@bouseuxlatache41408 ай бұрын
i started R almost 1,5 years and am enjoying the tool. however many colleagues only use Python and seem to be annoyed with the R code. this is due to the fact that my company is working with MS tools, and microsoft decided to go all in with Python. i feel the pressure to learn coming closer.
@gabiscarabel8 ай бұрын
Amazing video! Many thanks!
@brianatford66038 ай бұрын
I already know both languages, and this still feels like a roast.
@ashrafulalam4839 ай бұрын
Love the way how you start the video !😄
@lablondekalalizi95029 ай бұрын
Yooooh, I'm typing your questions in chatGPT and it giving me the same answers without event presenting it with tables. This is awesome
@kapur.betzy20239 ай бұрын
When is the next video coming out ? Its been more than 4 weeks and we already have started forgetting about the first part
@kavinsuresh546810 ай бұрын
For the interview question 2 ( 9:00 ) wouldn't it be >= instead of just > because the problem says 'at least' which is inclusive of the given number too.
@AaronMOliver10 ай бұрын
Good callout! That's correct, yeah. It just so happens in this case you get the correct results anyway, but there are a lot of times that wouldn't be the case, so good catch thanks!
@RohitSingh-pd7zr10 ай бұрын
Hey Aaron I just found your channel and have really enjoyed your last few videos. As a newbie, I have a lot of questions to ask and the overwhelming desire to learn everything is killing me. I'm trying to build a strong portfolio but don't know to how to start with it.
@jackma904911 ай бұрын
Thanks Aaron, really good and clear tutorial!
@sharminaktershifa495411 ай бұрын
Please also make plan for powerbi and tableau
@proxyands.b600311 ай бұрын
Loved it. very useful. highly recommended.
@EsinaViwn911 ай бұрын
learn python
@mikesmith-renorocket11 ай бұрын
If you are a business analyst, what is the better one to learn?
@VKjkd8 ай бұрын
I would say R. You can get going pretty fast. I love both languages. R changed my life in many ways. I would also develop advanced excel skills. You don’t need VBA, but formulas, pivot tables and formulas (building dashboards) are great. You really won’t go wrong starting with R in a business analytic setting.
@user-fi9rw4vx2b Жыл бұрын
There are three join types - INNER, OUTER and CROSS, not four. You missed the latter one. And you missed FULL OUTER join. Also LEFT, RIGHT and FULL joins are different kinds of OUTER join.
@dimitrioskioroglou4316 Жыл бұрын
When you listen that R has better visualization tools than Python... raise an eyebrow... when you listen that there is a separation between statistics, data science and machine learning... just run!
@nifftbatuff6766 ай бұрын
What Python visualizazion tool is better than R equivalent?
@dimitrioskioroglou43166 ай бұрын
@@nifftbatuff676 It's not whether Python has better tools or not for visualizations. You can create great visualizations with both languages. My point was that when people say that R has better visualizations, it means that they don't know Python well enough. So my advice... pick a language and learn it as good as you can.
@LW1Tok Жыл бұрын
Thank you so much. R it is for me for now.
@yashgala7556 Жыл бұрын
Great video, thanks!
@medourwassim7705 Жыл бұрын
Thank you for the video, however R is also used in the industry
@bassamahmed1254 Жыл бұрын
I agree with everything you stated except for the community thing. I instantly found help for R because it's more specialized and focused and it's followers are more dedicated.
@AaronMOliver Жыл бұрын
That's completely fair actually. The R community is very passionate, and highly focused.
@bouseuxlatache41408 ай бұрын
this is what actually brought me to R
@kabelloseskabel7029 Жыл бұрын
Choose python if you hate indexing starting by 1. It just hurts.