vicuna-13b Arena Human Preference 55K
Write me a python script that exports all of my Outlook emails to a CSV and prepares…
- User
Write me a python script that exports all of my Outlook emails to a CSV and prepares them so that they are ready to use to finetune a LLM
- Assistant
Here is a sample Python script that exports all of your Outlook emails to a CSV file and prepares them for use in fine-tuning a language model:
import csv import os import win32com.client # Set the path to your Outlook folders FolDER = "C:\\PST\\Outlook\\FOLDER" # Set the path to the output CSV file CSV_FILE = "C:\\PST\\Outlook\\exports.csv" # Create a variable to hold the mails mails = [] # Connect to Outlook olt = win32com.client.Dispatch("Outlook.Application") olNs = olt.GetNamespace("MAPI") # Get a list of all the folders in your Outlook account folders = olNs.GetDefaultFolder(olFolderDeferredDelivery).Folders # Loop through each folder for folder in folders: # Check if the folder is an Outlook folder if folder.DefaultItemType == olMailFolder: # Get the folder's ID folder_id = folder.FolderID # Get the folder's path folder_path = olt.GetPath_olFolder(folder_id) # Set the folder variable to the folder's path folder = folder_path.Replace(FolDER, "") # Get all the mails in the folder mails += olNs.GetFolder(folder).Items # Create a CSV file and write the headers with open(CSV_FILE, "w", newline="", encoding="utf-8") as csvfile: writer = csv.writer(csvfile) writer.writerow(["Subject", "Body"]) for mail in mails: msg = mail.Get Inspector.WordEditor.Body message = msg.Body # Split the message into lines lines = message.split("\n") # Split each line into words words = [line.split(" ") for line in lines] # Get the subject of the mail subject = "".join(words[0]) # Get the body of the mail body = " ".join(words[1:]) - User
Show me the code in its entirety
- Assistant
Here is the code in its entirety:
import csv import os import win32com.client # Set the path to your Outlook folders FolDER = "C:\\PST\\Outlook\\FOLDER" # Set the path to the output CSV file CSV_FILE = "C:\\PST\\Outlook\\exports.csv" # Create a variable to hold the mails mails = [] # Connect to Outlook olt = win32com.client.Dispatch("Outlook.Application") olNs = olt.GetNamespace("MAPI") # Get a list of all the folders in your Outlook account folders = olNs.GetDefaultFolder(olFolderDeferredDelivery).Folders # Loop through each folder for folder in folders: # Check if the folder is an Outlook folder if folder.DefaultItemType == olMailFolder: # Get the folder's ID folder_id = folder.FolderID # Get the folder's path folder_path = olt.GetPath_olFolder(folder_id) # Set the folder variable to the folder's path folder = folder_path.Replace(FolDER, "") # Get all the mails in the folder mails += olNs.GetFolder(folder).Items # Create a CSV file and write the headers with open(CSV_FILE, "w", newline="", encoding="utf-8") as csvfile: writer = csv.writer(csvfile) writer.writerow(["Subject", "Body"]) for mail in mails: msg = mail.Get Inspector.WordEditor.Body message = msg.Body # Split the message into lines lines = message.split("\n") # Split each line into words words = [line.split(" ") for line in lines] # Get the subject of the mail subject = "".join(words[0]) # Get the body of the mail body = " ".join(words[1:]) # Write the mail to the CSV file writer.writerow([subject, body])This script will export all of the mails in your Outlook account to a CSV file, with the subject and body of each mail in separate columns. The CSV file will be saved in the
C:\PST\Outlook\exports.csvfile.
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.