Python 生成词云：一篇文章生成漂亮词云图
from wordcloud import WordCloud
import jieba
def make_wordcloud(text_file, output='wordcloud.png'):
with open(text_file, 'r', encoding='
Python 统计文件夹大小：找出最占空间的文件
import os def folder_size(path): total = 0 for root, _, files in os.walk(path): for name in files: try: total += os.path.
Python 找出重复文件：自动清理占空间的大文件
import os
import hashlib
from collections import defaultdict
def file_hash(path, chunk=8192):
h = hashlib.md5()
with open(path, 'rb') as f:
Python 定时关机：到点自动关机 / 重启
import osimport timefrom datetime import datetime def shutdown_at(hour, minute, restart=False): while True: now = datetime.now() if now.hour ==
Python 批量下载图片：从网页抓取所有图片
import osimport requestsfrom bs4 import BeautifulSoupfrom urllib.parse import urljoin def download_images(url, folder='images'): os.makedirs(folder,
Python 视频压缩：一键减小视频体积
import subprocess
import os
def compress_video(src, dst, crf=28):
"""crf 越大压缩越狠，18~28 之间比较合适"""
cmd = [
'ffmpeg', '-i
Python 视频转音频：批量提取视频里的声音
import os
from moviepy.editor import VideoFileClip
def video_to_audio(folder):
for name in os.listdir(folder):
if not name.lower().endswith(('.
Python 文字转语音：把文字变成 MP3 音频
from gtts import gTTS def text_to_speech(text, output='output.mp3', lang='zh-cn'): tts = gTTS(text=text, lang=lang, slow=False) tts.save(o
Python 图片文字识别 OCR：批量提取图片里的文字
import os
import pytesseract
from PIL import Image
# Windows 需指定 tesseract 路径
pytesseract.pytesseract.tesseract_cmd = r'C:\Program Files\Tesseract-OCR
Python 给 PDF 加水印：批量加文字水印
from pypdf import PdfReader, PdfWriter
from reportlab.pdfgen import canvas
from reportlab.lib.pagesizes import A4
import io
def add_pdf_watermark(src, dst, tex
Python PDF 转 Word：保留排版批量转换
import os
from pdf2docx import Converter
def pdf_to_word(folder):
for name in os.listdir(folder):
if not name.lower().endswith('.pdf'):
Python Excel 转 PDF：批量转换 Excel 文件为 PDF
import os
import win32com.client
def excel_to_pdf(folder):
excel = win32com.client.Dispatch('Excel.Application')
excel.Visible = False
for
Python 网页转 PDF：一键保存网页为 PDF
from playwright.sync_api import sync_playwright
def html_to_pdf(url, output='page.pdf'):
with sync_playwright() as p:
browser = p.chromium.
Python 网页截图：批量给网页截图保存
from selenium import webdriverfrom selenium.webdriver.chrome.options import Options def screenshot(url, output='screenshot.png'): options = Options()
Python 识别二维码内容：批量读取二维码
import osfrom pyzbar.pyzbar import decodefrom PIL import Image def decode_qrcodes(folder): for name in os.listdir(folder): if not name.lower().endswit
Python 批量生成二维码：带 Logo 的漂亮二维码
import qrcodefrom qrcode.image.styledpil import StyledPilImagefrom qrcode.image.styles.moduledrawers import RoundedModuleDrawer def gen_qrcode(data, output='
Python 批量给图片加水印：文字 / Logo 都支持
import os
from PIL import Image, ImageDraw, ImageFont
def add_watermark(folder, text='© 我的网站'):
out_dir = os.path.join(folder, 'waterm
Python 批量压缩图片：一键缩小 90% 体积不失真
import os
from PIL import Image
def compress_images(folder, quality=75, max_size=(1920, 1920)):
out_dir = os.path.join(folder, 'compressed')
os
Python 批量修改文件名：一分钟搞定上千个文件重命名
import os
def batch_rename(folder, prefix='file_', start=1):
"""批量给文件夹里的文件加前缀+序号"""
files = sorted([f for f in os.listdir(folder
Python文件按类型自动分类整理
import os
import shutil
folder = './下载'
rules = {
'图片': ['.jpg', '.jpeg', '.png', '.gif', '.webp
Python提取 Excel 中重复项 / 去重
import pandas as pd df = pd.read_excel('数据.xlsx') # 去重df.drop_duplicates(subset=['手机号'], keep='first').to_excel('去重后.xlsx&
Python批量发送邮件（带附件）
import smtplibfrom email.message import EmailMessage def send_mail(to_list, subject, body, attachment=None): msg = EmailMessage() msg['From'] = &#
Python定时提醒 / 番茄钟
import time
from plyer import notification
def pomodoro(minutes=25):
print(f"专注 {minutes} 分钟，开始！")
time.sleep(minutes * 60)
notification.notify
Python 批量改图片尺寸
import os
from PIL import Image
folder = './图片'
size = (800, 800) # 目标尺寸
for f in os.listdir(folder):
if f.lower().endswith(('.jpg',
Python PDF 合并 / 拆分
from pypdf import PdfWriter, PdfReader
# 合并
writer = PdfWriter()
for pdf in ['a.pdf', 'b.pdf', 'c.pdf']:
writer.append(pdf)
write
Python批量提取 Word 文本
import os
from docx import Document
folder = './文档'
for f in os.listdir(folder):
if f.endswith('.docx'):
doc = Document(os.path.j
Python Excel 拆分（按某列分组生成多个表）
import pandas as pd
df = pd.read_excel('总表.xlsx')
for name, group in df.groupby('部门'):
group.to_excel(f'拆分_{name}.xlsx', inde
Python Excel 合并（多个表合成一个）
import pandas as pd
import glob
files = glob.glob('./表格/*.xlsx')
df_list = [pd.read_excel(f) for f in files]
merged = pd.concat(df_list, ignore_index
Python批量重命名文件（加前缀/序号）-日常办公最常用的 Python 小工具
import os
def batch_rename(folder, prefix='file_', start=1):
files = sorted([f for f in os.listdir(folder) if os.path.isfile(os.path.join(folder, f
python自动扫描当前文件夹里所有 .txt 全部切割
import os def split_file(input_file, lines_per_file=2000, output_dir='output'): """ 将 input_file 按每 lines_per_file 行分割成多个文件，保存到 outpu