This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import re | |
| import nltk | |
| from nltk.corpus import stopwords | |
| import pandas as pd | |
| stop_words = set(stopwords.words("english")) | |
| def get_first_title(title): | |
| # keep "co-founder, co-ceo, etc" | |
| title = re.sub(r"[Cc]o[\-\ ]","", title) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from xlwings import Workbook, Range | |
| import pandas as pd | |
| import os | |
| import re | |
| # Script to merge a folder containing Excel workbooks into a single workbook. | |
| # The folder should only contain Excel workbooks and must all either be in csv, xls or xlsx format | |
| # To run, open the command prompt and enter the command python Merge_Excel_Workbooks.py | |
| """"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""" |
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.