Introduction to R Programming for Excel Users | R Programming Tutorial

[@Datasciencedojo]

Learn more about R programming with this playlist: kzbin.info/aero/PL8eNk_zTBST8j2BU5HYFQogdCjtrHyQAx

[@SassePhoto]

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]

Glad you liked it!

[@calvinchung3419]

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.

[@ThobelaniMfengwana-fn6xw]

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!

[@EricLaermans]

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

[@MrAlivallo]

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

[@Phoenixspin]

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

[@claudiamartinez-lopez1378]

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.

[@kellymahoney7363]

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

[@wesleym162]

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]

@Wesley - Glad you found the video useful! Dave

[@theboats2596]

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

[@harryporterdigitalservices-r4m]

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.

[@rawufadamu5362]

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

[@trananswers]

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

[@christiana20]

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

[@pascalejacquelinepetit5131]

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

[@mursyidhb]

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]

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

[@ElGtheTS]

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

[@RaqueebHassan]

Outstanding! Keep up the good work.

[@paulstokes766]

Very insightful as a first time visitor to R

[@emmanuel.kagembe.9016]

👍👍👍👍

[@attahfakeye9184]

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.

[@superfreiheit1]

Great video. Very informative and good snenario based learning.

[@SundaymSamakoh-vh3ng]

Nice 1

[@thalesromao2239]

Great

[@94madness]

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?

[@Ommbye]

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

[@Datasciencedojo]

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

[@Ommbye]

@@Datasciencedojo Okay I will by God will

[@swatiyadav2236]

Wow very awesome teaching skills

[@parthraval6052]

The video is so indulging...great method

[@vincenzo4259]

Thanks

[@DrReenaMurmuNielsen]

Excellent speaker & tutor. Thanks 🙏

[@Datasciencedojo]

Keep following us for more resources!

[@jangkrikaduan]

If you want to skip the excel part (which is quite dragging) you can directly go to 26:32

[@theempanadaisalie4525]

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

[@tegegnfentaw6962]

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

[@Aurossa]

“Automagically” 🥰

[@valigeorge9110]

Thanks a lot for this!

[@davidkiplangat2590]

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

[@Datasciencedojo]

Stay tuned with us for more tutorials, David.

[@kvs123100]

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

[@davidizquierdogomez]

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

[@cheonglily3992]

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

[@Datasciencedojo]

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

[@mayurwabhitkar2041]

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

[@MrAlivallo]

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

[@kuldeepkale9792]

Hello Dave , Excellent Video

[@lironavineri]

Thank you❣️

[@cheonglily3992]

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

[@marcello4258]

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

[@chiemezieezeani8004]

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

[@Datasciencedojo]

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

[@harikaku8896]

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

[@marioustxexcel6375]

Thank you for sharing.

[@amaruvidevanathan4203]

Very useful.

[@MrAlivallo]

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

[@MrAlivallo]

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.

[@Sahilm41]

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

[@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.

[@sjoukevanbenthem1218]

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

[@sjoukevanbenthem1218]

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

[@giuliko]

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?

[@bourezahkarim3172]

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

[@JP-td8gt]

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

[@theboats2596]

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

[@evedickson2496]

I'm sold :-)

[@boknows8263]

I am buying you as you are pretty

[@MrAlivallo]

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

[@tuanlong9238]

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

[@mkstragon]

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

[@a.peerally6677]

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

[@JennHayden]

thank you

[@Al-Ahdal]

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]

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

[@ospino1112]

XD triggered my anxiety

[@sahilaggarwal3130]

CSV files are not working when I open it in excel

[@MukeshRay]

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

[@MrAlivallo]

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

[@v9054]

Skip first 28 minutes, to go to R.

[@BachchaStayle]

#Mistakesright

[@kvs123100]

Is this still valid?

[@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]

@@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.

[@Phoenixspin]

Crying over those who died, including Jack.

[@hiddeholwerda4316]

starts at 15:13

[@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]

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

[@boknows8263]

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

[@RomuloMagalhaesAutoTOPO]

Great