6 turn UI security inventory 23 parsingipynb into python script (#5)

* commit clean notebook

* initilizing investments cleaning script

* finishing up command line prompts, being processing data

* investment_cleaning.py script is implemented

* Investment Cleaning Script is Implemented

---------

Co-authored-by: kennykos <“gkosmacher01@gmail.com”>

1 files changed, 90 insertions, 0 deletions

diff --git a/scripts/constants.py b/scripts/constants.py
new file mode 100644
index 0000000..7af110e
--- /dev/null
+++ b/scripts/constants.py
@@ -0,0 +1,90 @@
+COMPANY_NAMES = {
+    "AMERICAN EXPRESS" : "AMERICAN EXPRESS CO",
+    'AIG GLOBAL' : "AMERICAN INTL GROUP  INC",
+    "ANHEUSER-BUSCH" : "ANHEUSER-BUSCH CO",
+    "APTIV" : "APTIV CO",
+    "ASTRAZENECA" : "ASTRAZENECA PLC",
+    "AUSTRALIA & NEW" : "AUSTRALIA & NEW ZEALAND BKG GR",
+    "BAE SYS" : "BAE SYS PLC",
+    "BANCO SANTANDER" : "BANCO SANTANDER SA",
+    "BANK MONTREAL" : "BANK OF MONTREAL",
+    "BANK OF MONTREAL" : "BANK OF MONTREAL",
+    "BK MONTREAL" : "BANK OF MONTREAL",
+    "BANK NOVA SCOTIA" : "BANK OF NOVA SCOTIA",
+    "BANK OF NOVA SCOTIA" : "BANK OF NOVA SCOTIA",
+    "BANK AMER" : "BANK OF AMERICA CO",
+    "BAXTER INT" : "BAXTER INTERNATIONAL INC",
+    "BAYER US FIN" : "BAYER US FINANCE LLC",
+    "BB&T" : "BB&T CO",
+    "BLACKSTONE" : "BLACKSTONE",
+    "BMW" : "BMW",
+    "BNP PARIBAS" : "BNP PARIBAS",
+    "BRIGHTHOUSE" : "BRIGHTHOUSE",
+    "BRISTOL MYERS SQUIBB" : "BRISTOL MYERS SQUIBB CO",
+    "BRISTOL-MYERS SQUIBB" : "BRISTOL MYERS SQUIBB CO",
+    "CANADIAN IMPERIAL BK" : "CANADIAN IMPERIAL BK CO",
+    "CAPITAL ONE" : "CAPITAL ONE FINL CO",
+    "CATERPILLAR FINL" : "CATERPILLAR FINL",
+    "CENTERPOINT ENERGY" : "CENTERPOINT ENERGY INC",
+    "CHEVRON U S A" : "CHEVRON  CO",
+    "CREDIT AGRICOLE" : "CREDIT AGRICOLE",
+    "CREDIT SUISSE" : "CREDIT SUISSE GROUP AG",
+    "CROWN CASTLE INTL" : "CROWN CASTLE INTL",
+    "DAIMLER" : "DAIMLER",
+    "DELTA AIR LINES" : "DELTA AIR LINES",
+    "DTE E" : "DTE ELEC",
+    "DUKE ENERGY" : "DUKE ENERGY CO",
+    "DOWDUPONT  INC" : "DUPONT DE NEMOURS  INC",
+    "ENTERGY" : "ENTERGY CO",
+    "EQUITABLE FINL LIFE" : "EQUITABLE FINL LIFE GLOBAL FDG",
+    "ESC CB LEHMAN BROS" : "ESC LEHMAN BROTH HLD  INC",
+    "FIFTH THIRD BANCORP" : "FIFTH THIRD BANCORP",
+    "FLORIDA P" : "FLORIDA POWER & LIGHT CO",
+    "GENERAL MTRS" : "GENERAL MOTORS",
+    "GENERAL MOTORS" : "GENERAL MOTORS",
+    "HEWLETT PACKARD" : "HEWLETT PACKARD ENTERPRISE CO",
+    "HP  INC" : "HEWLETT PACKARD ENTERPRISE CO",
+    "HUNTINGTON" : "HUNTINGTON NATL BK MD",
+    "JACKSON FINANCIAL  INC" : "JACKSON NATIONAL LIFE GL",
+    "JPM CHASE" : "JPMORGAN CHASE &  CO",
+    "KINDER MORGAN" : "KINDER MORGAN INC",
+    "LLOYDS BKG" : "LLOYDS BANKING GROUP PLC FORME",
+    "MACQUARIE" : "MACQUARIE BK LTD",
+    "MIZUHO" : "MIZUHO CO",
+    "MONDELEZ INT" : "MONDELEZ INTERNATIONAL INC",
+    "MORGAN STANLEY" : "MORGAN STANLEY",
+    "NATIONAL AUSTRALIA B" : "NATIONAL AUSTRALIA BANK",
+    "NATIONWIDE BLDG SOC" : "NATIONWIDE BLDG SOCIETY",
+    "NATIONAL BANK OF CANADA" : "NATIONAL BANK OF CANADA",
+    "NATL BK CDA" : "NATIONAL BANK OF CANADA",
+    "NATWEST M" : "NATWEST MARKETS PLC",
+    "NEXTERA ENERGY" : "NEXTERA ENERGY CAP",
+    "NORDEA BANK" : "NORDEA BANK",
+    "NORTHWESTERN" : "NORTHWESTERN MUT",
+    "NXP B V" : "NXP B V",
+    "PHILLIPS 66" : "PHILLIPS 66",
+    "PRINCIPAL LIFE GLOBAL" : "PRINCIPAL LIFE GLOBAL FDG",
+    "PROTECTIVE LIFE G" : "PROTECTIVE LIFE GLOBAL",
+    "PUBLIC SVC" : "PUBLIC SERVICE ELECTRIC & GAS",
+    "RABOBANK NEDERLAND" : "RABOBANK NEDERLAND",
+    "ROCHE H" : "ROCHE HOLDINGS INC",
+    "ROPER " : "ROPER TECHNOLOGIES  INC",
+    "ROYAL BANK OF CANADA" : "ROYAL BANK OF CANADA",
+    "ROYAL BK CDA" : "ROYAL BANK OF CANADA",
+    "SCHLUMBERGER" : "SCHLUMBERGER", 
+    "SIEMENS FINANCIERINGSMAA" : "SIEMENS FINANCIERINGSMAATSCHAP",
+    "SIMON PPTY GROUP" : "SIMON PPTY GROUP",
+    "STATE STR" : "STATE STREET CO",
+    "SUMITOMO MITSUI" : "SUMITOMO MITSUI BANKING",
+    "SWEDBANK AB" : "SWEDBANK AB",
+    "TORONTO DOMINION B" : "TORONTO DOMINION BANK",
+    "TOYOTA M" : "TOYOTA MOTOR",
+    "TRANS-CDA PIPELINES" : "TRANS-CDA PIPELINES",
+    "TRUIST " : "TRUIST BANK",
+    "TSMC " : "TSMC GLOBAL LTD",
+    "U S B" : "U S BANCORP",
+    "UBS " : "UBS AG LONDON",
+    "VENTAS REALTY" : "VENTAS REALTY LP",
+    "VOLKSWAGEN GROUP" : "VOLKSWAGEN GROUP",
+    "WESTPAC B" : "WESTPAC BANKING",
+}
\ No newline at end of file