6個(gè)Python辦公黑科技，助你提升工作效率

# encoding: utf-8
import os, sys
from pdfminer.pdfparser import PDFParser
from pdfminer.pdfdocument import PDFDocument
from pdfminer.pdfpage import PDFPage
from pdfminer.pdfinterp import PDFResourceManager
from pdfminer.pdfinterp import PDFPageInterpreter
from pdfminer.layout import LAParams
from pdfminer.converter import PDFPageAggregator

import smtplib
smtpObj = smtplib.SMTP( [host [, port [, local_hostname]]] )

SMTP.sendmail(from_addr, to_addrs, msg[, mail_options, rcpt_options])

#!/usr/bin/python# -*- coding: UTF-8 -*- 
import smtplibfrom email.mime.text 
import MIMETextfrom email.header 
import Header sender = 'from@runoob.com'
# 西紅柿微：ZPYDWXYreceivers = ['1221121@qq.com']  
# 接收郵件，可設(shè)置為你的QQ郵箱或者其他郵箱 
# 三個(gè)參數(shù)：第一個(gè)為文本內(nèi)容，第二個(gè) plain 設(shè)置文本格式，第三個(gè) utf-8 設(shè)置編碼message = MIMEText('Python 郵件發(fā)送測試...', 'plain', 'utf-8')message['From'] = Header("不吃西紅柿", 'utf-8')   
# 發(fā)送者message['To'] =  Header("測試", 'utf-8')        
# 接收者 subject = 'Python SMTP 郵件測試'message['Subject'] = Header(subject, 'utf-8')  
try:    smtpObj = smtplib.SMTP('localhost')    smtpObj.sendmail(sender, receivers, message.as_string())    
print "郵件發(fā)送成功"except smtplib.SMTPException:    
print "Error: 無法發(fā)送郵件"

#查看訂單明細(xì)號是否重復(fù)，結(jié)果是沒。
df1["訂單明細(xì)號"].duplicated().value_counts()
df2["訂單明細(xì)號"].duplicated().value_counts()

df_c=pd.merge(df1,df2,on="訂單明細(xì)號",how="left")

pd.pivot_table(sale,index="地區(qū)名稱",columns="業(yè)務(wù)員名稱",values="利潤",aggfunc=[np.sum,np.mean])

sale["訂單明細(xì)號2"]=sale["訂單明細(xì)號"]

#在訂單明細(xì)號2里前10個(gè)都+1.
sale["訂單明細(xì)號2"][1:10]=sale["訂單明細(xì)號2"][1:10]+1

#差異輸出
result=sale.loc[sale["訂單明細(xì)號"].isin(sale["訂單明細(xì)號2"])==False]

sale.drop_duplicates("業(yè)務(wù)員編碼",inplace=True)

#用0填充缺失值
sale["客戶名稱"]=sale["客戶名稱"].fillna(0)
#刪除有客戶編碼缺失值的行
sale.dropna(subset=["客戶編碼"])

sale.loc[(sale["地區(qū)名稱"]=="北京")(sale["業(yè)務(wù)員名稱"]=="張愛")(sale["訂單金額"]>5000)]

sale.loc[sale["存貨名稱"].str.contains("三星|索尼")]

sale.groupby(["地區(qū)名稱","業(yè)務(wù)員名稱"])["利潤"].sum()

sale.loc[sale["存貨名稱"].str.contains("三星")(sale["稅費(fèi)"]>=1000)][["訂單明細(xì)號","利潤"]].describe()

sale["存貨名稱"].map(lambda s :s.strip(""))

# encoding: utf-8
import json
from pyecharts.charts import Pie
from pyecharts import options as opts
from pyecharts.charts import Radar



def draw_Radar():
    from pyecharts.charts import Radar
    radar = Radar()
    # //由于雷達(dá)圖傳入的數(shù)據(jù)得為多維數(shù)據(jù)，所以這里需要做一下處理
    radar_data = [[10, 10, 10, 10, 10]]
    radar_data1 = [[2, 10, 3, 6, 3]]
    radar_data2 = [[1, 8, 7, 5, 8]]

    # //設(shè)置column的最大值，為了雷達(dá)圖更為直觀，這里的月份最大值設(shè)置有所不同
    schema = [
        ("物理", 100), ("魔法", 10), ("防御", 10),("難度", 10),("喜好", 10)
    ]
    # //傳入坐標(biāo)
    radar.add_schema(schema)
    radar.add("滿分", radar_data)
    # //一般默認(rèn)為同一種顏色，這里為了便于區(qū)分，需要設(shè)置item的顏色
    radar.add("安妮", radar_data1, color="#E37911")
    radar.add("卡爾瑪", radar_data2, color="#1C86EE")
    radar.render()

if __name__ == '__main__':

    draw_Radar()

# encoding: utf-8
import os, sys
import docx

def word_reader(file):
    try:
        # docx 直接讀
        if 'docx' in file:
            res = ''
            f = docx.Document(file)
            for para in f.paragraphs:
                res = res + '\n' +para.text
        else:
            # 先轉(zhuǎn)格式doc>docx
            os.system("textutil -convert docx '%s'"%file)
            word_reader(file+'x')
            res = ''
            f = docx.Document(file+'x')
            for para in f.paragraphs:
                res = res + '\n' +para.text
        return res
    except:
        # print(file, 'read failed')
        return ''

>>> import math
>>> math.cos(math.pi / 4)
0.70710678118654757
>>> math.log(1024, 2)
10.0