# 圖片格式轉換, Jpg轉Png
 
# 方法①
from PIL import Image
 
img = Image.open('test.jpg')
img.save('test1.png')
 
 
# 方法②
from cv2 import imread, imwrite
 
image = imread("test.jpg", 1)
imwrite("test2.png", image)

# PDF加密
import pikepdf
 
pdf = pikepdf.open("test.pdf")
pdf.save('encrypt.pdf', encryption=pikepdf.Encryption(owner="your_password", user="your_password", R=4))
pdf.close()

# PDF解密
import pikepdf
 
pdf = pikepdf.open("encrypt.pdf",  password='your_password')
pdf.save("decrypt.pdf")
pdf.close()

# 獲取計算機信息
import wmi
 
 
def System_spec():
    Pc = wmi.WMI()
    os_info = Pc.Win32_OperatingSystem()[0]
    processor = Pc.Win32_Processor()[0]
    Gpu = Pc.Win32_VideoController()[0]
    os_name = os_info.Name.encode('utf-8').split(b'|')[0]
    ram = float(os_info.TotalVisibleMemorySize) / 1048576
 
    print(f'操作系統(tǒng): {os_name}')
    print(f'CPU: {processor.Name}')
    print(f'內(nèi)存: {ram} GB')
    print(f'顯卡: {Gpu.Name}')
 
    print("\n計算機信息如上 ↑ ↑ ↑ ↑ ↑ ↑ ↑ ↑ ↑ ↑ ↑ ↑")
 
 
System_spec()

# 解壓文件
from zipfile import ZipFile
 
unzip = ZipFile("file.zip", "r")
unzip.extractall("output Folder")

import pandas as pd
 
# 文件名
filename = "test.xlsx"
# 表格數(shù)量
T_sheets = 5
 
df = []
for i in range(1, T_sheets+1):
    sheet_data = pd.read_excel(filename, sheet_name=i, header=None)
    df.append(sheet_data)
 
# 合并表格
output = "merged.xlsx"
df = pd.concat(df)
df.to_excel(output)

# 圖像轉換
import cv2
 
# 讀取圖片
img = cv2.imread("img.jpg")
# 灰度
grey = cv2.cvtColor(img, cv2.COLOR_BGR2GRAY)
invert = cv2.bitwise_not(grey)
# 高斯濾波
blur_img = cv2.GaussianBlur(invert, (7, 7), 0)
inverse_blur = cv2.bitwise_not(blur_img)
sketch_img = cv2.divide(grey, inverse_blur, scale=256.0)
# 保存
cv2.imwrite('sketch.jpg', sketch_img)
cv2.waitKey(0)
cv2.destroyAllWindows()

# 獲取CPU溫度
from time import sleep
from pyspectator.processor import Cpu
cpu = Cpu(monitoring_latency=1)
with cpu:
    while True:
        print(f'Temp: {cpu.temperature} °C')
        sleep(2)

# 方法①
import camelot
 
tables = camelot.read_pdf("tables.pdf")
print(tables)
tables.export("extracted.csv", f="csv", compress=True)
 
# 方法②, 需要安裝Java8
import tabula
 
tabula.read_pdf("tables.pdf", pages="all")
tabula.convert_into("table.pdf", "output.csv", output_format="csv", pages="all")

# 方法①from mss import msswith mss() as screenshot: screenshot.shot(output='scr.png')# 方法②import PIL.ImageGrabscr = PIL.ImageGrab.grab()scr.save("scr.png")# 方法①
from mss import mss
with mss() as screenshot:
    screenshot.shot(output='scr.png')
 
# 方法②
import PIL.ImageGrab
scr = PIL.ImageGrab.grab()
scr.save("scr.png")

# 拼寫檢查
# 方法①
import textblob
 
text = "mussage"
print("original text: " + str(text))
 
checked = textblob.TextBlob(text)
print("corrected text: " + str(checked.correct()))
 
# 方法②
import autocorrect
spell = autocorrect.Speller(lang='en')
 
# 以英語為例
print(spell('cmputr'))
print(spell('watr'))
print(spell('survice'))