Python提升工作效率的七个实用秘籍

import os

def rename_files(directory, prefix):
    """
    批量重命名目录下的所有文件。
    :param directory: 文件夹路径
    :param prefix: 新的文件名前缀
    """
    files = os.listdir(directory)
    for file in files:
        ext = os.path.splitext(file)[1]
        new_name = f"{prefix}_{file}"
        old_path = os.path.join(directory, file)
        new_path = os.path.join(directory, new_name)
        os.rename(old_path, new_path)

# 使用示例
rename_files("path/to/your/directory", "new_prefix")
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.

import pandas as pd

def clean_data(file_path):
    """
    清洗并分析CSV文件中的数据。
    :param file_path: CSV文件路径
    """
    df = pd.read_csv(file_path)
    df.dropna(inplace=True)
    print(df.head())
    print(df.describe())

# 使用示例
clean_data("path/to/your/data.csv")
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.

   ColumnA  ColumnB
0       10       20
1       30       40
2       50       60
3       70       80
4       90      100

          ColumnA      ColumnB
count  4.000000e+00  4.000000e+00
mean   5.000000e+01  5.000000e+01
std    2.969848e+01  2.969848e+01
min    1.000000e+01  2.000000e+01
25%    3.000000e+01  4.000000e+01
50%    5.000000e+01  6.000000e+01
75%    7.000000e+01  8.000000e+01
max    9.000000e+01  1.000000e+02
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.

import re

def extract_emails(text):
    """
    从文本中提取所有邮箱地址。
    :param text: 待处理的文本
    :return: 匹配到的所有邮箱地址列表
    """
    pattern = r'\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,}\b'
    emails = re.findall(pattern, text)
    return emails

# 示例文本
text = """
Hello, my email is example@example.com and another one is test@example.org.
Feel free to contact me at john.doe@gmail.com.
"""

# 提取邮箱地址
emails = extract_emails(text)
print(emails)
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.

['example@example.com', 'test@example.org', 'john.doe@gmail.com']
1.

from openpyxl import load_workbook

def modify_excel(file_path):
    """
    读取并修改Excel文件。
    :param file_path: Excel文件路径
    """
    wb = load_workbook(file_path)
    ws = wb.active
    ws['A1'] = 'Hello, Python!'
    wb.save(file_path)

# 使用示例
modify_excel('path/to/your/excel.xlsx')
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.

import requests
from bs4 import BeautifulSoup

def web_scraping(url):
    """
    爬取指定URL的网页内容。
    :param url: 目标网页的URL
    :return: 解析后的HTML内容
    """
    response = requests.get(url)
    soup = BeautifulSoup(response.text, 'html.parser')
    title = soup.title.string
    return title

# 使用示例
url = 'https://www.example.com'
title = web_scraping(url)
print(title)
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.

Example Domain
1.

import smtplib
from email.mime.text import MIMEText

def send_email(subject, body, recipient):
    """
    发送邮件。
    :param subject: 邮件主题
    :param body: 邮件正文
    :param recipient: 收件人邮箱地址
    """
    server = smtplib.SMTP('smtp.example.com', 587)
    server.starttls()
    server.login('your_username', 'your_password')
    msg = MIMEText(body)
    msg['Subject'] = subject
    msg['From'] = 'your_username@example.com'
    msg['To'] = recipient
    server.sendmail('your_username@example.com', [recipient], msg.as_string())
    server.quit()

# 使用示例
send_email('Hello from Python!', 'This is a test email.', 'recipient@example.com')
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.