Hello everyone,
I found a clinical trial CSV online that is updated monthly and I wanted to try to build a model around it. Although, the structure was a bit unfortunate because the Sponsors and Collaborators were merged. So, I went and split the Sponsors from Collaborators, assuming the the Sponsor would have the greatest stake in the clinical trial. (as shown).
That being said, I don't know how to go from a bunch of corporations, private businesses and at times, universities, to something that would be a ticker symbol.
I understand that I would have to filter what corresponds to an actual ticker and throw out the rest, but I don't know how to do that on this platform. Would someone be able to direct me down the right path?
