Скачать или смотреть Creating Amazing Google Maps With Sales and Transaction Data in RStudio

In this video I show you some really cool applications of mapping in R and RStudio. I use ggmap and a publicly available sales data file to create some really cool graphs based on sales and transaction data. I show you exactly how to bring that data in and then to display it so you can see one or two variables played out on the maps.

Get a free stock like Apple, Exxon Mobil, GM, Ford, Tesla or Facebook worth up to $500 just by signing up and joining Robinhood using my link: https://join.robinhood.com/davidm16707

For this example I read the data from an Excel worksheet and then we create two data frames. One data frame is for the original data set and the other is to pull int the Geo data (longitude and latitude). We then combine these togther, filter the data with dplyr to only include US data points.

After this we create two new columns for sales and transaction identifiers. Then I show you how to use nested elseif statements to further quantifier or better display our data. For sales we use three colors - red, blue and orange. And for transactions we use four different size differentiations.

Then we run and plot this data through ggmap and we get a really cool map that shows different size points based on transactions and different colors based on sales. Once you see this map and how easy it is to start seeing new insights on your data you will be sold. It is also very easy to modify and change this code for other data sets. Just make sure you have columns with country, state and city data.

If you don't that's fine you can go and bring it in and or jointed in from another table or data set. The end product is a Google map with sales and transaction data that can be zoomed in or out very easily. It's also very easy to switch between maps as I show you in the code in this video.

I hope you found this video on making amazing and insightful Google maps based on Excel worksheet data to be helpful and informational.

Please take a moment to subscribe to my channel and like this video so that you can see all of my other great videos I have coming out.

Also be sure and check out my channel is loaded with other great videos on everything from R, Rstudio, building reusable models, predictive analytics and so much more!

Thanks again for watching! God bless!