158
edits
Changes
Jump to navigation
Jump to search
no edit summary
<onlyinclude>
[[Augi Liebster]] [[Work Logs]]
2018-07-16: Spent the day matching portcos with IPOs and MAs. Then cleaned the data using an excel file. Almost finished IPOs. Made a mistake in filtering MAs but will go back and finish cleaning both MAs and IPOs by tomorrow. Slightly confused about cleaning the MA table since I do not see a way other than equivalence of state to determine whether a company is matched to
itself or a company with a similar name. Either will accept same state as a indicator or will wait for Ed's response.
2018-07-13: Worked to standardize the company names using the matcher. Also uploaded the rest of the data that I could into the db.
2018-07-12: Spent the day struggling the MA pull. Dylan figured out that data will pull when pulled in text not columnar form. Tomorrow will try to learn RegEx so that I can manage this file. Still stuck on USLongDescription as I have tried different ways of normalization and nothing has worked.
