Skip to content

Instantly share code, notes, and snippets.

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)
@tdrei
tdrei / Merge_Excel_Workbooks
Created March 20, 2022 20:44 — forked from aschleg/Merge_Excel_Workbooks
Merge first worksheet in all Excel workbooks in a folder
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.