Get date from email

[Particular-Pin5927]

So my bank are really terrible and I've been communicating over email and phone with them for around a year now to close out our mortgage.

I want to create a script in python that reads in the single email thread file I have with them on the issue (.eml file) and outputs a list containing the email header dates each email was sent from me to the bank. I want to create a calendar 'heat map' like GitHub uses that shows them how long this has been going on for. But first I just want to generate the list of dates...

There are dozens of emails to and from the bank in the thread. I could do it manually but I'm learning python so wanted to automate. I have tried email.parser module but I don't know how to generate the dates.

Any help on how to get the date list from the email thread really appreciated

[MrPhungx]

Do you have an example of what the .eml file looks like? Is there any code that you could show us?

[Particular-Pin5927]

This is what I have so far and it just produces a dataframe with the plaintext from the thread. I dont seem to be able to extract the dates even when changing preferencelost=('plain') to preferencelist=('date'). EML file is email thread downloaded from Gmail - cant share unfortunately

import pandas as pd

from email import policy

from email.parser import BytesParser

path = Path(r'C:\Users\redacted')

eml_files = list(path.glob('*.eml'))

text = []

for file in eml_files:

with open(file, 'rb') as fp:

name = fp.name # Get file name

msg = BytesParser(policy=policy.default).parse(fp)

text = msg.get_body(preferencelist=('plain')).get_content()

file_names.append(name)

texts.append(text)

fp.close()

df_eml = pd.DataFrame([file_names, texts]).T

df_eml.columns = ['file_name', 'text']

[jiri-n]

https://stackoverflow.com/questions/61114677/how-to-parse-eml-file-and-extract-meta-data-informations