How to extract mails from a string and store it into excel file using python (English Language)
import re
import pandas as pd
with open(r'E:\daily_videos\daily_videos\text.txt', 'r') as f:
data = f.read()
print(data)
ids = re.findall('\d (.+) --- ([\w\.-]+@[\w\.-]+)', data)
dummy_list = []
for id in ids:
dummy_dict = dict()
print('Company = ', id[0])
print('id = ', id[1])
dummy_dict['Company Name'] = id[0]
dummy_dict['Mail Id'] = id[1]
dummy_list.append(dummy_dict)
print('=========================================')
print(id)
print(dummy_list)
df = pd.DataFrame(dummy_list)
df.to_excel('companies id.xlsx', index=False)
![[GBAY99 X AF] ANYTHING BUT ORDINARY ｜Afreeca Freecs Documentary](https://images.videosashka.com/watch/IPIXYlDVhmM)
![Painting A Mini For Someone Else Is Great - Motivationally-Speaking! [Ep. 85]](https://images.videosashka.com/watch/yjYS6LROZa0)
