dataRetrieval | R package is designed to obtain USGS | Data Visualization library

I am trying to download data from the USGS website using the dataRetrieval package of R.

For that purpose, I have generated a function called getstreamflow in R that works fine when I ran for example.

I am trying to pull out all United States Geological Survey (USGS) sites that have daily mean water temperature for a given date range using the USGS package dataRetrieval. I can do this with a for loop that iterates through each US state/territory abbreviation but the loop stops running once it comes across a location that does not have any sites. How can I make the loop skip locations that do no have sites available?

This is the for loop that works but stops when it comes across a state/territory that does not have a site.

I'm trying to change the formatting of multiple data frames that are in a list. I was previously using pipes when formatting single data frames, but I don't know if this is still the most efficient way for reiterating the process. Using pipes I don't know how to get the script to call the columns names in the data frames and not the names of the data frames in the list. I've included all of the script that I have so far and the script I'm trying to make work.

My current script:

I'm fairly new to R and have been struggling with simplifying some code using a for loop. I am attempting to pull water quality data from an online database using the package dataRetrieval. I currently have duplicated the code for each site and changed the site number and output name, but have been trying to simplify this by putting the script in a for loop and am having trouble with creating the separate data tables with unique identifiers.

Original Code that creates a data table for each site. The only variables that changes are the siteNumbers and the data table name "x"_dataTable

I have a script called DataRetrieval.py. This script connects to an internal database, retrieves data and writes that data to an Excel file. This script imports the following:

a) a utils.py helper module that contains several functions

b) a DataRetrieval.cfg configuration file (which contains all of the login information and SQL queries that the DataRetrieval.py script needs)

The DataRetrieval.py script takes the following 3 command line arguments:

I´m creating a small Node.js application for some monitoring stuff. The following operation has to be made with this app:

A job scheduler (using node-schedule module) is retrieving data from a web service within a time period and inserting the content into an array (for further processing). After finishing the job a promise should resolve the complete array in order to use it in my main program.

Here is my coding so far. With this coding the promise gets resolved before finishing the job and the array is empty. Can you give me any hints how to solve this?

I ran into an issue where mutate() in dplyr returns results in the wrong order. My call to mutate uses data from an existing column as input, but the results are returned arranged as if the data was sorted before the mutate.

My specific issue uses the dataRetrieval package to get USGS/NWIS data from the web. In this example, I am retrieving the site names based on the site ID. In the `dataRetreival package, site ID is a numerical code stored as a character.

I would like to search a large list by name in the ui and use the value in the server function. Both the names and values are character vectors. I can't get it to pass the correct input (site_no as a character) to the server function. Here is an example:

This is my first shiny app. I would like for the user to be able to update the number of facet columns and the dimensions of downloaded plot. readNWISuv, the function to download data can take a long time if multiple years are queried. Currently, the app downloads the data each time the user wants to change the plot format or plot dimensions. Not sure if I need to use reactiveValues, but I would assume that I want the data to be downloaded and manipulated outside of renderPlot. Thanks!