import os
import pandas as pd
source_folder = r"D:\\DATA"
dest_folder = r"D:\\pdata"
for file in os.listdir(source_folder):
if file.startswith("ABC") and file.endswith(".csv"):
r=file.rfind("_")
h=file[r:][9:15]
data= pd.read_csv("D:\\DATA\\"+file+" ")
data['Time']= h
data.to_csv("D:\\pdata\\updated_"+file)
import win32com.client
import datetime
import pandas as pd
import matplotlib.pyplot as plt
from datetime import date, timedelta,datetime
def get_week_Last_day(year, week):
year_start = date(year, 1, 1)
# the following line assumes your this_week_int starts at 0
# if this_week_int starts at 1, change to week-2
week_start = year_start + timedelta(days=-year_start.isoweekday(), weeks=week-1)
week_end = week_start + timedelta(days=6)
week_start=week_start.strftime("%d/%m/%Y")
week_end=week_end.strftime("%Y%m%d")
lastweek="From "+week_start+ " to "+week_end
return week_end
now = datetime.now()
curday=now
week_num=curday.strftime("%U")
year_num=curday.strftime("%Y")
week_num=int(week_num)
year_num=int(year_num)
LDOW=get_week_Last_day(year_num,week_num)
lday=LDOW
#######################################################
df=pd.read_csv("E:\\MyWork\\Python\\Data\\Tables_"+lday+".csv")
df=df[['DATE','TableName','Records']]
df= df.query("TableName=='Apple.AppleTable'").groupby(['DATE','TableName']).agg({'Records': 'sum'})
print(df)
df.plot(kind="bar",title='AppleTables')
plt.savefig("E:\\MyWork\\Python\\Data\image1.jpg",bbox_inches='tight')
import win32com.client
import datetime
import pandas as pd
import matplotlib.pyplot as plt
from datetime import date, timedelta,datetime
import time
from PIL import ImageGrab
import os
#import exchangelib as ex
from exchangelib import Message,FileAttachment,HTMLBody
from exchangelib import Credentials, Account
credentials = Credentials('Your@hotmail', 'password123')
account = Account('tahirkhalid@hotmail', credentials=credentials, autodiscover=True)
img_name=['image1','image2']
filetoattach = "E:\\TEST_"+lday+".csv"
with open(filetoattach, 'rb') as f:
dmartcsv=FileAttachment(name=dmart_filename,content=f.read(),is_inline=False,content_id=dmart_filename)
logo1 = "E:\\MyWork\\Python\\Data\\image1.jpg"
logo2 = "E:\\MyWork\\Python\Data\image2.jpg"
with open(dmartcopperlogo, 'rb') as fa,open(dmartgponlogo, 'rb') as fb, \
logoImage1 =FileAttachment(name=logo1, content=fa.read(), is_inline=True,content_id=logo1)
logoImage2 =FileAttachment(name=logo2, content=fb.read(), is_inline=True,content_id=logo2)
html1= '<html><body>ABC '+wk+'<br>'+globals()["df"+str(img_name[0])].to_html()+'<br>
<img src="cid:%s"><br></body></html>' % (logo1,)
html2 ='<html><body>$$$$<br>'+globals()["df"+str(img_name[1])].to_html()+'<br>
<img src="cid:%s"><br></body></html>' % (logo2,)
body =HTMLBody(html1+html2)
m = Message(account=account,subject="ABC",body=body,to_recipients=['your@hotmail.com'])
m.attach(logoImage1)
m.attach(logoImage2)
m.attach(csv)
m.send()
