def submit_info(renamedfilepath):
p, n = getPath(renamedfilepath)
name = [get_name(i)[1] for i in p]
submitednu = len(name)
submitedlist = name
needsubmitlist = [v for k, v in id_name.items()]
needsubmitnu = len(needsubmitlist)
notsubmitlist = [i for i in needsubmitlist if i not in submitedlist]
notsubmitnu = len(notsubmitlist)
return notsubmitnu, notsubmitlist
body = MIMEText(body, "plain", "utf-8")
msg.attach(body)
part = MIMEApplication(open(file_path, 'rb').read())
part.add_header('Content-Disposition',
'attachment',
filename=('gbk', '', filename))
msg.attach(part)
try:
smtp = smtplib.SMTP()
smtp.connect(smtpserver)
smtp.login(sender, psw)
except:
smtp = smtplib.SMTP_SSL(smtpserver, port)
smtp.login(sender, psw)
smtp.sendmail(sender, receiver, msg.as_string())
smtp.quit()
print('%s发送成功' % file_path)
for c in courses:
courese_path = r'C:\Users\Administrator\Desktop\%s' % c
log_path = courese_path + '\log.txt'
sent_ppt_path = read_log(log_path)
all_ppt_path, name = getPath(courese_path)
newppt = [i for i in all_ppt_path if i not in sent_ppt_path]
for ppt in newppt:
mail_content = ppt.split('\\')[-1]
ct = c + '-' + mail_content
send_ppt(ppt, ct, mail_content, mail_content)
write_log(log_path, ppt)
import pandas as pd
from Office.get_path import getPath
from Office.save_file import save_dfto_csv
f,p = getPath(r'C:\Users\xfs9619\Desktop\附件1 中央财经大学2019-2020学年第一学期研究生课程表（公共课部分）')
# for nj in f:
# print(nj)
# sheet = pd.ExcelFile(nj).sheet_names
# for zy in sheet[1:]:
# try:
# df = pd.read_excel(nj,sheet_name=zy)
# df = df.iloc[2:,1:]
# df.columns = ['节数']+['星期'+ str(i) for i in range(1,8)]
# dfs = df.set_index(df['节数']).drop(columns='节数').stack().reset_index()
# dfs.columns = ['节数','星期','课程信息']
# dfs = dfs.dropna(how='any')
# dfs['课程名称']= dfs['课程信息'].apply(lambda x:x.split('\n')[0])
# dfs['时间范围']= dfs['课程信息'].apply(lambda x:x.split('\n')[1])
# dfs['地点']= dfs['课程信息'].apply(lambda x:x.split('\n')[-1])
# res = dfs.drop(columns='课程信息')
# res['专业'] = zy
# save_dfto_csv('kb',res)
# print(zy +'success')
# except:
# print(zy + 'error')
df = pd.read_csv('课表.csv')
df.to_excel('课表.xlsx')
ddf = df.drop_duplicates(subset=['节数','星期','地点'])
ddf.to_excel('去重课表.xlsx')
submitednu = len(name)
submitedlist = name
needsubmitlist = [v for k, v in id_name.items()]
needsubmitnu = len(needsubmitlist)
notsubmitlist = [i for i in needsubmitlist if i not in submitedlist]
notsubmitnu = len(notsubmitlist)
return notsubmitnu, notsubmitlist
stu_path = r'C:\Users\Administrator\Desktop\学委\金融学硕18.xlsx'
filepath = r'C:\Users\Administrator\Desktop\attachment'
renamedfilepath = r'C:\Users\Administrator\Desktop\周一56节1班沙河主教219'
id_name = get_stu_info(stu_path)
name_id = {v: k for k, v in id_name.items()}
id_major = get_stu_info(stu_path, mode='id-major')
p, n = getPath(filepath)
for i in p:
try:
id, name = get_name(i)
major = id_major[id]
title = '%s-%s-%s' % (name, major, id)
if i.endswith('doc'):
newfilename = r'C:\Users\Administrator\Desktop\周一56节1班沙河主教219\%s.doc' % title
if i.endswith('docx'):
newfilename = r'C:\Users\Administrator\Desktop\周一56节1班沙河主教219\%s.docx' % title
if i.endswith('pdf'):
newfilename = r'C:\Users\Administrator\Desktop\周一56节1班沙河主教219\%s.pdf' % title
os.rename(i, newfilename)
except:
print(i)
import pandas as pd
from Office.get_path import getPath
mergefile = pd.read_csv(r'C:\\Users\\Administrator\\Desktop\\excel\\realreturn.csv',names = ['a','b','c'])
#print(mergefile)
f,n = getPath(r'C:\Users\Administrator\Desktop\excel')
fs = [i for i in f if 'CA' in i]
for i in fs:
name = i[-9:]
df = pd.read_csv(i,names=['a','d','c'])
data = pd.merge(mergefile,df,how='right',on=['a','c'])
data.to_csv(name)
import pandas as pd
from Office.get_path import getPath
def merge_excel(pathlist,filename):
dfs = []
for path in pathlist:
dfs.append(pd.read_csv(path))
df = pd.concat(dfs)
df.to_excel('%s.xlsx' % filename)
f,n = getPath(r'C:\pycharm project\Crawl')
pathlist = [i for i in f if '数据' in i and '-' in i]
merge_excel(pathlist,'上海市交易所数据')