![]() |
|
Tutorial Pythin Script to Extract Email Data from Linkedin 2023 Database - Printable Version +- Sinisterly (https://sinister.li) +-- Forum: Coding (https://sinister.li/Forum-Coding) +--- Forum: Python (https://sinister.li/Forum-Python) +--- Thread: Tutorial Pythin Script to Extract Email Data from Linkedin 2023 Database (/Thread-Tutorial-Pythin-Script-to-Extract-Email-Data-from-Linkedin-2023-Database) |
Pythin Script to Extract Email Data from Linkedin 2023 Database - anonymousgyps - 12-30-2023 Handy Script Just Replace [US|United States] to desired country to extract specific country Emails Code: import re
from tkinter import Tk, filedialog
def extract_info(row):
# Define the regex pattern for email
email_pattern = r'\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,}\b'
# Define the regex pattern for US or United States
country_pattern = r'\b(?:US|United States)\b'
# Find emails in the row
emails = re.findall(email_pattern, row)
# Check if any email matches the country pattern
for email in emails:
if re.search(country_pattern, row):
# Extract name (assuming it's before the email) and country from the row
name_match = re.search(r'([A-Za-z]+ [A-Za-z]+)', row)
name = name_match.group(1) if name_match else None
country = re.search(country_pattern, row).group() if re.search(country_pattern, row) else None
return email, name, country
return None, None, None
def process_file(input_file_path, output_file_path):
try:
with open(input_file_path, 'r') as input_file, open(output_file_path, 'w') as output_file:
for line in input_file:
email, name, country = extract_info(line)
if email:
output_file.write(f"Email: {email}, Name: {name}, Country: {country}\n")
print(f"Extraction completed. Results saved to {output_file_path}")
except Exception as e:
print(f"Error processing file: {e}")
def browse_files():
Tk().withdraw() # We don't want a full GUI, so keep the root window from appearing
input_file_path = filedialog.askopenfilename(title="Select an input file") # Show an "Open" dialog box and return the path to the selected file
if input_file_path:
output_file_path = filedialog.asksaveasfilename(title="Select an output file", defaultextension=".txt", filetypes=[("Text files", "*.txt")])
if output_file_path:
process_file(input_file_path, output_file_path)
# Create a simple GUI
if __name__ == "__main__":
browse_files()RE: Pythin Script to Extract Email Data from Linkedin 2023 Database - saehjfueiwruhsfts - 09-05-2024 This is very useful, thank you RE: Pythin Script to Extract Email Data from Linkedin 2023 Database - ElysianSignals - 09-26-2024 Thanks for the code! Your script is for searching specific content in a text file. I wouldn't necessarily call a text file a database. Your share could be even more practical if you added instructions on where we find the database to read from. Nevertheless, the code is clean and fit for education. Thank you! RE: Pythin Script to Extract Email Data from Linkedin 2023 Database - Balalutiz - 10-08-2024 Ty for info bro :0 |