Introduction to R Programming for Excel Users | R Programming Tutorial

Поделиться
HTML-код
  • Опубликовано: 26 ноя 2024

Комментарии • 93

  • @Datasciencedojo
    @Datasciencedojo  Год назад

    Learn more about R programming with this playlist: ruclips.net/p/PL8eNk_zTBST8j2BU5HYFQogdCjtrHyQAx

  • @SassePhoto
    @SassePhoto Год назад +2

    This is the best introduction to R I have ever seen - as most of us know Excel. Now with the advent of Chat GPT, coding is becoming faster and more efficient. No limits!

    • @Datasciencedojo
      @Datasciencedojo  Год назад

      Glad you liked it!

    • @calvinchung3419
      @calvinchung3419 5 месяцев назад

      So true with Chat GPT. Without it the learning curve to code would be much harder and steeper.
      I do agree this is one of the best video on intro to R.

  • @theboats2596
    @theboats2596 6 лет назад +3

    people don't seem to know but R is more powerful with respect to analytics than python. It is purely a statistical tool aimed at performing analytical experiments. People compare R to java and python but the fact is R is not for those purposes. R is purely a statistical language for dealing with data. Good presentation

  • @EricLaermans
    @EricLaermans 5 лет назад +8

    From this video I learned more in 5 minutes, then in many videos together on this subject.

  • @wesleym162
    @wesleym162 7 лет назад +5

    This is by far the most helpful resource to helping me learn R. I use Excel for my current job and this coming semester, we will be using Stata for my master's in economics. I picked up R to start working with a language before school begins and also because of my cousin who is a Data Scientist that highly recommended working with R. Thank you so much for the video and supplemental material!

    • @Datasciencedojo
      @Datasciencedojo  7 лет назад +1

      @Wesley - Glad you found the video useful!
      Dave

  • @MrAlivallo
    @MrAlivallo 5 лет назад +3

    I learned more in this video then any other video I watched about "R"; Excellent!

  • @mursyidhb
    @mursyidhb 3 года назад +3

    Amazing!!!
    I have tried several times to install and use R, but I found it difficulties to start. After this presentation, I will definitely use R. so your goal is achieved. I raise my hand in front of the computer to respond to question in 1:23:00

    • @Datasciencedojo
      @Datasciencedojo  3 года назад

      Glad to hear that, keep following us for more content!

  • @christiana20
    @christiana20 6 лет назад

    this guy is a legend... that video is excatly what i need, because i am a heavy excel user who is starting to learn R

  • @claudiamartinez-lopez1378
    @claudiamartinez-lopez1378 5 лет назад +3

    I learned a lot from this video. I think he is very nerdy and adorable, and also super knowledgeable. Looking forward to learning more about R.

  • @ThobelaniMfengwana-fn6xw
    @ThobelaniMfengwana-fn6xw 5 месяцев назад

    I just watched a this video , and I have to say, it was fantastic! The explanations were clear, concise, and incredibly easy to follow. The step-by-step approach made complex concepts feel approachable, and I feel much more confident in my R skills now. Thank you for making learning R so accessible and enjoyable!

  • @kellymahoney7363
    @kellymahoney7363 4 года назад +1

    If R was a company, Dave Langer would be their top salesman. I’m sold.

  • @Phoenixspin
    @Phoenixspin 4 года назад

    This is the first tutorial that I actually understood R even in the least bit.

  • @harryporterdigitalservices-r4m
    @harryporterdigitalservices-r4m 4 года назад +6

    Wow!
    This is one of the incredible presentation I have ever encountered!
    I felt too close to you though very far away.
    I felt like booking such like sessions with you lively!
    Kudos.

  • @ElGtheTS
    @ElGtheTS 7 лет назад +18

    Good quality stream. Loved how you overlaid the slides/video, and repeated the questions the audience had.

  • @trananswers
    @trananswers 5 лет назад +6

    Like this way of teaching, from familiar stuff to new materials. Learned a lot in this video than other 5 R tutorial videos put together

  • @rawufadamu5362
    @rawufadamu5362 2 года назад

    This video is tremendous. The teaching approach is incredibly clear.

  • @pascalejacquelinepetit5131
    @pascalejacquelinepetit5131 7 лет назад +2

    Many thanks for articulating so well how to transpose Excel to R. Great presentation.

  • @RaqueebHassan
    @RaqueebHassan 7 лет назад +8

    Outstanding! Keep up the good work.

  • @attahfakeye9184
    @attahfakeye9184 3 года назад +2

    Great tutorial. I enjoyed this a lot. I need to use R in predicting some soil properties that are difficult to analyze in the laboratory.

  • @swatiyadav2236
    @swatiyadav2236 4 года назад

    Wow very awesome teaching skills

  • @94madness
    @94madness 6 лет назад +3

    Hi I like your lecture, I was only wondering why you used the funtion of LetterNumber like B2 and not the function [@column]. In my opinion the table functions wil still work much better when you starting to filter youre columns?

  • @paulstokes766
    @paulstokes766 Год назад

    Very insightful as a first time visitor to R

  • @davidkiplangat2590
    @davidkiplangat2590 2 года назад

    hey, dav. this is so amazing. This tutorial is very informative and educative. Thanks alot.

    • @Datasciencedojo
      @Datasciencedojo  2 года назад

      Stay tuned with us for more tutorials, David.

  • @SundaymSamakoh-vh3ng
    @SundaymSamakoh-vh3ng Год назад +1

    Nice 1

  • @davidizquierdogomez
    @davidizquierdogomez 5 лет назад +3

    Thank you for the video....I have a question: is there any fast way to transform the output of an excel pivot table (data with column headers) into an R data frame (column headers into a whole column next to each value of the variable)? I mean how can we easily transform the head column in a pivot table into a column all the way next to the variable in an R data frame?
    Thank you very much and again, greit video ;D

  • @superfreiheit1
    @superfreiheit1 Год назад

    Great video. Very informative and good snenario based learning.

  • @parthraval6052
    @parthraval6052 4 года назад

    The video is so indulging...great method

  • @Ommbye
    @Ommbye 2 года назад +1

    Oh this a very wonderful video thank you so so much for it.

    • @Datasciencedojo
      @Datasciencedojo  2 года назад

      Glad you liked it. Keep following us for more tutorials.

    • @Ommbye
      @Ommbye 2 года назад

      @@Datasciencedojo Okay I will by God will

  • @DrReenaMurmuNielsen
    @DrReenaMurmuNielsen 3 года назад

    Excellent speaker & tutor. Thanks 🙏

  • @theempanadaisalie4525
    @theempanadaisalie4525 2 года назад

    The Repository link is pointing to a different Github folder. Thank you for the video!

  • @chiemezieezeani8004
    @chiemezieezeani8004 3 года назад +1

    Please where do I download the course tool/material "r_programming_excel_users/titanic.R" . I only have that of csv

    • @Datasciencedojo
      @Datasciencedojo  3 года назад

      Hi, please forward your query on our site chatbot or email us: datasciencedojo.com/

  • @kuldeepkale9792
    @kuldeepkale9792 4 года назад

    Hello Dave , Excellent Video

  • @mkstragon
    @mkstragon 7 лет назад +2

    I'm still rooting for JavaScript!! I dream of the day where machine learning in JavaScript is viable.

  • @MrAlivallo
    @MrAlivallo 5 лет назад

    Is there a better IDE, GUI? Example CodeBlocks, Jyuptr, Toad SQL, or something that gives the appeal of powerBI?

  • @harikaku8896
    @harikaku8896 7 лет назад

    Hi DavidThanks for the wonderful presentation,I am trying to find the 12 Video series you posted but it seems they no longer exists. Have they been deleted. I was viewing Part II for installing ggplots. But was unable do so. Please advise

  • @cheonglily3992
    @cheonglily3992 3 года назад

    Hi Dave, I like to know the quote for this instance: male, surived, highest fare paid. how to go about it.

  • @valigeorge9110
    @valigeorge9110 6 лет назад +1

    Thanks a lot for this!

  • @kvs123100
    @kvs123100 3 года назад

    I'm yet to watch the video! But I subscribed because I felt +ve vibes!

  • @Aurossa
    @Aurossa 4 года назад +1

    “Automagically” 🥰

  • @MrAlivallo
    @MrAlivallo 5 лет назад

    You can use 'R' inside of PowerBI, any videos on that ? Any reason to use "R" over PowerBI? Except Export in PowerBI is limited to 37K rows. Purposely limited, and you can use "R" to bypass this limitation in PowerBI.

  • @a.peerally6677
    @a.peerally6677 6 лет назад +5

    increase video speed to x1.5 . You will thank me later.

  • @tegegnfentaw6962
    @tegegnfentaw6962 2 года назад

    Thanks, your very nice and excited presentation .I earn a lot.

  • @Sahilm41
    @Sahilm41 Год назад

    R, SAS and python which is better in 2023 for pharma healthcare and medical sector!?

    • @Datasciencedojo
      @Datasciencedojo  Год назад

      Hello Abu, it depends on the specific needs and requirements of the organization and the project.
      R is commonly used for statistical analysis and data visualization in the healthcare and medical sectors. It has a large community and numerous packages for working with healthcare data.
      SAS is a proprietary software that offers a range of advanced statistical and data management tools and is widely used in the healthcare industry. It is known for its stability and security.
      Python is a versatile programming language that has gained popularity in recent years due to its simplicity and ease of use. It has numerous libraries and frameworks for data analysis and machine learning, making it a popular choice for healthcare and medical projects.
      Ultimately, the choice of the tool depends on the skillset of the team and the requirements of the project. Each of these tools has its own strengths and weaknesses, and organizations may choose to use a combination of these tools to achieve their goals.

  • @TanishaMehta-c5d
    @TanishaMehta-c5d Месяц назад

    Can we do R programming in excel only

  • @MrAlivallo
    @MrAlivallo 5 лет назад

    How to join table Columns from different sources in "R"? Or layman's term fuzzy lookup, or vlookup.?

  • @JP-td8gt
    @JP-td8gt 6 лет назад

    Bravo! Great presentation. Is RStudio the best option to use? And what R packages are the best to use?

    • @theboats2596
      @theboats2596 6 лет назад

      try the tidyverse package. it is by far one of the best. with respect to visualization, use the ggplot2

  • @giuliko
    @giuliko 6 лет назад

    Outstanding Dave, congratulations. I'm an telecommunications engineer and currently I work with Data Science. But 95% of the time I use VBA along with SQL Server and Access. Fortunately I can do good stuff using VBA/Excel and thinking out of the box and it's really fast. But as long as I do not master any other language to work with data science, I feel that I'm still missing something. I didn't know that R was biuld from the scratch to be a data science language and that make me consider to learn it. I'm gonna watch your other videos on this channel. Do you have any other R courses available?

  • @lironavineri
    @lironavineri 5 лет назад +2

    Thank you❣️

  • @Al-Ahdal
    @Al-Ahdal 5 лет назад +1

    Please see column "M", your formula is pointing B2, whereas you are on B3, therefore wrong label is being generated. For example see line # 42 in excel, the value is 0 in row B42, column 2, and the label generated in column "M", row M42 is "Survived". Shouldn't it be "Died". The cell referencing is incorrect.

    • @Al-Ahdal
      @Al-Ahdal 5 лет назад

      Someone in the audience pointed that, and it was corrected.

    • @ospino1112
      @ospino1112 3 года назад

      XD triggered my anxiety

  • @mayurwabhitkar2041
    @mayurwabhitkar2041 2 года назад

    my console is not showing no. of male observations
    i.e 577

  • @marioustxexcel6375
    @marioustxexcel6375 6 лет назад

    Thank you for sharing.

  • @RomuloMagalhaesAutoTOPO
    @RomuloMagalhaesAutoTOPO 5 лет назад

    Great

  • @amaruvidevanathan4203
    @amaruvidevanathan4203 5 лет назад

    Very useful.

  • @MrAlivallo
    @MrAlivallo 5 лет назад +1

    how about a comparison to "R", with Python, Tabelau, PowerBI ?

    • @tuanlong9238
      @tuanlong9238 4 года назад

      Good question. I think R is a statistical language build for STATISTICAL analysis, you can do anything with statistics by using R (explore, transform, visualization and analyze data). Python is a PROGRAMMING language and really powerful in data science; people using Python for programming the software, application, game, machine learning (advance for traditional statistic). Tableau and PowerBI are the same software because they're excellent for data VISUALIZATION, but this software have limited data analysis. You can choose R or Python for analyzing, and Tableau or PowerBI for visualization depends on what your background and what exactly you want to do with your data

  • @bourezahkarim3172
    @bourezahkarim3172 2 года назад

    Is there really something yo can do in R that you can't do in Excel?

  • @evedickson2496
    @evedickson2496 4 года назад

    I'm sold :-)

    • @boknows8263
      @boknows8263 3 года назад

      I am buying you as you are pretty

  • @cheonglily3992
    @cheonglily3992 3 года назад +1

    Hi, your lesson is very interesting and I really learnt alot.

    • @Datasciencedojo
      @Datasciencedojo  3 года назад

      Thank you for the positive feedback. Keep following us on RUclips for more content.

  • @v9054
    @v9054 4 года назад +1

    Skip first 28 minutes, to go to R.

  • @emmanuel.kagembe.9016
    @emmanuel.kagembe.9016 Год назад +1

    👍👍👍👍

  • @sjoukevanbenthem1218
    @sjoukevanbenthem1218 2 года назад

    Strange, when I follow the talk with the same data, at 00:44:33 I get Chr in stead of Factor

    • @sjoukevanbenthem1218
      @sjoukevanbenthem1218 2 года назад

      I managed to remedy this by setting the colClasses in the read.csv statement

  • @sahilaggarwal3130
    @sahilaggarwal3130 7 лет назад

    CSV files are not working when I open it in excel

    • @MukeshRay
      @MukeshRay 6 лет назад

      yes, it does not give you the proper csv file. copy and paste the url of that page here and you can easily download all the contents. minhaskamal.github.io/DownGit/#/home

  • @vincenzo4259
    @vincenzo4259 2 года назад

    Thanks

  • @marcello4258
    @marcello4258 Год назад

    The exascale guy at the end just wanted to show he knows a fancy buzzword 😂

  • @MrAlivallo
    @MrAlivallo 5 лет назад

    Yeah but I can Mouse Click. Is There a GUI front end for "R" ? Everyone likes Excel and PowerBI, but syntax is not popular.

  • @Phoenixspin
    @Phoenixspin 4 года назад

    Crying over those who died, including Jack.

  • @BachchaStayle
    @BachchaStayle 4 года назад

    #Mistakesright

  • @kvs123100
    @kvs123100 2 года назад

    Is this still valid?

    • @Datasciencedojo
      @Datasciencedojo  Год назад

      Hello Kunal, yes, definitely! This course will help Excel users to add or integrate R and RStudio into their existing data analysis toolkit. Let us know how it helps you.

    • @kvs123100
      @kvs123100 Год назад

      @@Datasciencedojo Sure! I am from finance Background! I use a lot of Alteryx in one of the biggest organizations. But I wonder about those companies who can't afford Alteryx. I am planning a way to do stuff in R or Python without having the need to buy Alteryx.

  • @hiddeholwerda4316
    @hiddeholwerda4316 4 года назад

    starts at 15:13

  • @jpenneymrcoin6851
    @jpenneymrcoin6851 Год назад

    he's so microsoft trained to state perfectly obvious things as if they're revelations of the universe. clones. dumpy clones in cheap khakis and ugly tennis shirts.

  • @1252PFC
    @1252PFC 4 года назад

    Appreciate the video, but geez his tone is boring and he talks down to u as if u stupid.

    • @boknows8263
      @boknows8263 3 года назад

      he might be smarter than a lot of us. smart people need to show some pride.

  • @thalesromao2239
    @thalesromao2239 2 года назад

    Great