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,'上海市交易所数据')