Get Email

Pandas_EmailColumn.py

from tqdm import tqdm
from time import sleep
import pandas as pd

mycsv = "C:\\Users\\rob\\Downloads\\contest-standings-17968412\\contest-standings-17968412.csv"
mycsv2 = "C:\\Users\\rob\\Downloads\\contest-standings-17968412\\testEmail.csv"


# items = range(1,100)
#
#
# for item in tqdm(items):
#     print(item)
#
# for i in tqdm(range(9)):
#     sleep(1)


df = pd.read_csv(mycsv)
email_column = ""
headers = list(df.columns.values)
emails = []
debug = False

# df1 = df[['EntryName']]
# print(df1)

for index, row in df.iterrows():
    for column in row:
        if 'Hightower' in str(column):
            if debug:
                print("Hightower sign Found!")
            emails.append(str(column))
    #     print(column, index, row)
    # print(index, row)


print(len(emails))