I would like to download a csv file from a bank website and plot each of the 400 expenditure columns in graphs in r shiny. The user should be able to select which of the 400 columns they wish to see on a plot and these plots should have the Date (the first column in the dataframe) on the x axis and the expenditure data on the y axis.
I have an r code to download the csv to a directory, unzip this file, open in r, and put the data into a dataframe.
I have the basic code for an r shiny app, obtained from here : https://rstudio.github.io/shinydashboard/get_started.html
My question is where can I put this r code I have to dowload the file into a dataframe, into the r shiny code?
does it go into the ui<-fluidpage section? or into the server<-function(input, output) section?