What I am looking for is to identify companies that have taken (2) loans, one in both 2020 and 2021. I am further looking to sort the data by at least NAICS code (industry) (column AM) and State (column M)
I want to be able to visualize and sort the data by who was most impacted, and that will be determined by the amount of jobs lost / gained 2021 vs 2020. We can discuss further visualization (I need your guidance) but this is a minimum.
We know if they have taken (2) loans if they have the same company name in 2021 however if the company only shows up once, it is 2020 so they've taken (1) loan and are not of interest to us.
The total data set is under a million records.