dataRetrieval VS cheatsheets

The tile map was made in R (see code) using ggplot2 and the geofacet packages. Data are from the USGS National Water Information System, accessed in R using dataRetrieval. See it on twitter

I’d look into using the R package data retrieval (https://github.com/USGS-R/dataRetrieval) for downloading data. You could download and write the data to a csv if you want excel to open it.

The gage and spatial data were processed in R using dataRetrieval, sf, sp, rgeos, and dplyr. The animation frames were created in R using standard base R graphics, then the frames were stitched together into a video using FFmpeg. Source code can be found on our gage conditions GitHub repository: https://github.com/USGS-VIZLAB/gage-conditions-gif.

If you're an R user, stringr + its cheatsheet gets you very close to remembering what to do without needing to look further!

For more information on how to use ggplot2 and create charts consult the ggplot2 official page or the ggplot2 cheat graphic.

I'd suggest you have a look at cheatsheets (or download them from GitHub) if you want to get to know your way around a package or set if functions, it saves you a lot of time.

You could use geom_hline and geom_vline, geom_abline, or geom_segment for this. (The ggplot cheat sheet is very useful for answering these kinds of questions, BTW.)

I can't say for sure because I don't know what your ultimate aim is for your visualization. Check out the cheat sheet for ggplot2 here.

Finally just do your analysis. You should also should give a try and see the cheat sheet for data importing on the tidyverse package.

That said, when I’m trying to come up with an interesting way to visualize data, I find the ggplot cheat sheet very helpful: https://github.com/rstudio/cheatsheets/raw/main/data-visualization-2.1.pdf

Here's a cheat sheet: https://github.com/rstudio/cheatsheets/blob/main/strings.pdf

The cheat sheet of the stringr package should give you good overview of string manipulation/ regex in R.

I would very highly recommend that rather than trying to get started by translating an existing graph, you check out some documentation about ggplot first. If nothing else, the ggplot cheat sheet from RStudio should help explain what the component parts of the code are, and that might help you figure out what you actually want to do.