i have the csv with the above structure
Stores Financial 2010 2011
Above its year is a numeric values and goes on for 10 stores and 10 years.
I want to print the store with the best profit.
So basically, for each store to sum the incomes and the expenses, find the total difference and then print the store name with the best profit.
I can do a group_by(stores) and use x [ , purrr::map_lgl(x, is.numeric)] and then summurise_all() but i dont know how to do for each store.