drop row if symbol or name is null

1 files changed, 2 insertions, 0 deletions

diff --git a/main.py b/main.py
index 6a30a1b..300691d 100644
--- a/main.py
+++ b/main.py
@@ -45,6 +45,8 @@ class CompanySelector:
             return
 
         self.df = pd.read_excel(file_path)
+        self.df = self.df[self.df['Company Name'].notna()]
+        self.df = self.df[self.df['Symbol'].notna()]
         self.show_companies()
 
     def show_companies(self):