69
384 511

Take Your RStudio Hotkeys With You: Intro to Text Expanders

4:41

Break-even analysis in Excel for eBay and e-commerce

8:35

Automated Daily Weather Collection from Weather.gov in R

13:41

Data Entry with R’s Text Editor

5:48

Pivoting on Text in R (vs. Excel)

7:13

Pivoting on Text in Excel: Awards by Player PivotTable

7:51

Building FREE Online Surveys with.... Excel!

A common frustration in the analog world was how to disperse, collect and analyze a survey. Today, services like Qualtrics, SurveyMonkey and Google Forms make the process cheap and fast.
While each of these tools provide great features for data collection and analysis, those of us living in the real world know that Excel remains the queen of data analysis. Fortunately for us realists, Microsoft has cut out the middle-man and created Excel surveys.
Read the full post at georgejmount.com/building-surveys-in-excel-online/.

Відео

Take Your RStudio Hotkeys With You: Intro to Text Expanders

4:41

Take Your RStudio Hotkeys With You: Intro to Text Expanders

Переглядів 1105 років тому

View the original post at georgejmount.com/take-your-rstudio-hotkeys-online-with-a-text-expander/. In this video I use Phrase Express (www.phraseexpress.com) to bring two common R keyboard shortcuts online.

Break-even analysis in Excel for eBay and e-commerce

8:35

Break-even analysis in Excel for eBay and e-commerce

Переглядів 8555 років тому

Download the exercise file at georgejmount.com/ecommercebreakeven/. I’ve been a dilettante in eBay sales since college and, wanting to add a little more rigor to what I sell and how to price it, looked to the spreadsheet for guidance. If you’ve ever sold online before, you know the cost of shipping is literally a “make-or-break” input in profitability. Consumers more or less expect free shippin...

Automated Daily Weather Collection from Weather.gov in R

13:41

Automated Daily Weather Collection from Weather.gov in R

Переглядів 5666 років тому

Find the code and follow along at georgejmount.com/r24hourweather/. In this video we will write an R script to collect data from the last 24 hours for a given location at Weather.gov. We will then set up the Windows Task Scheduler to execute this script daily for us, returning a csv file each day named after that date.

5:48

Data Entry with R’s Text Editor

Переглядів 2,5 тис.6 років тому

Code and example at georgejmount.com/rdataentry/ R has a built-in spreadsheet-like text editor for data entry. Learn how to work it in this video.

7:13

Pivoting on Text in R (vs. Excel)

Переглядів 2366 років тому

Code and resources at georgejmount.com/pivoting-on-text-in-r/. This video replicates in R what we covered in a previous lesson how to pivot on text in Excel (georgejmount.com/pivottextrexcel/). Rather than summarizing our data by a numerical statistic like a sum or an average, we instead create our own measure by concatenating items together with a comma and a space.

Pivoting on Text in Excel: Awards by Player PivotTable

7:51

Pivoting on Text in Excel: Awards by Player PivotTable

Переглядів 2196 років тому

Download the exercise file at georgejmount.com/pivottextrexcel/. Our goal is to create a Pivot-Table like report that creates a comma-separated list of players who won any given award in a given year. We will filter and merge information from these two tables using Get & Transform, then use Excel’s Data Model to pivot on text. This is an added functionality over base PivotTables which do not al...

R Explained for Excel Users: The read_excel Function

6:54

R Explained for Excel Users: The read_excel Function

Переглядів 2,2 тис.6 років тому

Download the exercise file at www.microsoft.com/en-us/microsoft-365/blog/wp-content/uploads/2015/08/Sample-Workbook-for-Statistical-Charts.xlsx. In this video we will use the readxl package's read_excel function to read in an Excel workbook. Additional arguments to the function allow us to read in custom ranges off any worksheet in the workbook. Documentation at readxl.tidyverse.org.

R Explained for Excel Users: What is a Vector?

4:31

R Explained for Excel Users: What is a Vector?

Переглядів 3806 років тому

Follow along with the code at gist.github.com/summerofgeorge/ced0e6d488fe51092964b954dd9088f6. Similar to the cell in Excel, vectors are foundational to working with data in R. In this video I reproduce some common Excel operations in R using vectors, and explain some of the basics of this data structure.

Minimally Reproducible Data Frames in R: dput, dget, dump and source

5:37

Minimally Reproducible Data Frames in R: dput, dget, dump and source

Переглядів 9066 років тому

Follow along at georgejmount.com/dputdget/. While there are many great resources to get help in R, sometimes you just need a second opinion. Here is where the many Internet help boards come in handy, most notably Stack Overflow. Start posting on Stack Overflow and you will soon learn the importance of the minimum reproducible example (MRE). Without one, you will likely even be refused “service....

For that Rare Occasion: Plotting Pie Charts in R

4:07

For that Rare Occasion: Plotting Pie Charts in R

Переглядів 946 років тому

Follow along with the code at gist.github.com/summerofgeorge/c7ecaa2df28a30bf42daf48a7490a701 For that rare event when a pie chart is a good choice, R has you covered. Meme credit shawnmlevin.com/blog/2016/2/29/kill-the-pie-chart

A Tour of the RStudio Integrated Development Environment

13:33

A Tour of the RStudio Integrated Development Environment

Переглядів 7106 років тому

Welcome to a tour of the RStudio integrated development environment. Our destination is an understanding of its various panes and tabs and what makes it so "integrated" after all. Enroll in my free mini-course "5 Things Excel Users Should Know About R" at georgejmount.thinkific.com/courses/rexplainedpreview. Follow along with the R script at gist.github.com/summerofgeorge/7d5d528c8248396c43c0c6...

6:58

5 Ways to Get Help in R

Переглядів 3926 років тому

This accompanies my post at georgejmount.com/5-ways-to-get-help-in-r/ 1. ?: Search R documentation for a specific term. 2. ?? Search R help files for a word or phrase. 3. RSiteSearch(): Search search.r-project.org 4. findFn: Search search.r-project.org for functions 5. RSeek.Org: Like Google, but for R.

Calculating Games Behind: “Max If” in R and Excel

10:07

Calculating Games Behind: “Max If” in R and Excel

Переглядів 4226 років тому

Download all source data, scripts and files at georgejmount.com/maxifrexcel/. In this post we will calculate how many games behind in the standings each team was at the end of the season for its division since 2010. This will require finding a “max if” value (What is the highest number of games won for any team in each division and year?). We will do this in both R and Excel.