Hi Fellow Quants,
I am trying to build a data set that creates a Data Frame with the following columns:
SID, Symbol Name, Price, Volume, Market Cap, Super Sector Name, Super Sector Code, Sector Name, Sector Code, Industry Group, Industry Group Code, Industry Name, Industry Code
I took the sector & industry classifications based on the MorningStar classification on the fundamentals page and inserted them into a CSV that I am pulling using the local_csv function.
The challenge is that when i merged the 2 datasets and deduplicated on column names, I lost the column created by default for pipelines that shows SID & Symbol it looks like "Equity(24 [AAPL]) ".
Can someone look at my code and show me how my merge between the 2 data frames is removing this column. This or how to pull SID & Symbol name as a column would be greatly appreciated.