Plotting Multiple Columns from a data frame into a scatterplot in R
Okay so I am trying to plot a scatterplot of test scores in various states over time. In the dataframe there are multiple columns that are not being used, and two column types that are being used. One column is state, and the data are 2 letter state abbreviations. Second column type is the scores; these columns are titled with the year. unnecessary columns are between necessary ones and the data goes all the way to 2023. additionally, there are two entries for each state, one english one math, I would only like to use the english scores. ex.