Python 编程：深度解锁自动办公的无限可能

📊 Python 数据处理：从杂乱到有序

🔍 案例：销售数据深度分析

import pandas as pd

# 读取销售数据文件
sales_data = pd.read_csv('sales_data.csv')

# 按地区和年份分组，计算每年各地区的销售总额
region_year_sales = sales_data.groupby(['Region', 'Year'])['Sales'].sum().unstack()

# 计算各产品的销售占比
product_sales_sum = sales_data.groupby('Product')['Sales'].sum()
total_sales = product_sales_sum.sum()
product_sales_percentage = product_sales_sum / total_sales

print("各地区每年销售总额：")
print(region_year_sales)
print("\n各产品销售占比：")
print(product_sales_percentage)

🤖 Python 自动化脚本：解放双手的利器

🖼️ 案例：文件批量处理

import os
from PIL import Image

# 定义图片文件夹路径
image_folder = 'image_folder'

# 遍历文件夹中的所有文件
for index, filename in enumerate(os.listdir(image_folder)):
    if filename.endswith('.jpg') or filename.endswith('.jpeg'):
        # 新文件名
        new_filename = f'image_{index + 1}.jpg'
        old_file_path = os.path.join(image_folder, filename)
        new_file_path = os.path.join(image_folder, new_filename)
        
        # 重命名文件
        os.rename(old_file_path, new_file_path)
        
        # 打开图片并转换格式
        try:
            img = Image.open(new_file_path)
            png_filename = new_filename.replace('.jpg', '.png')
            png_file_path = os.path.join(image_folder, png_filename)
            img.save(png_file_path, 'PNG')
            print(f"成功将 {new_filename} 转换为 {png_filename}")
        except Exception as e:
            print(f"转换 {new_filename} 时出错：{e}")

🌐 Python 网络爬虫：信息获取的秘密武器

📈 案例：网页数据抓取与分析

import requests
from bs4 import BeautifulSoup
import matplotlib.pyplot as plt

# 定义目标网页 URL
url = 'https://example.com/products'

# 发送请求获取网页内容
response = requests.get(url)
if response.status_code == 200:
    # 解析网页内容
    soup = BeautifulSoup(response.text, 'html.parser')
    
    # 提取商品价格信息
    price_elements = soup.find_all('span', class_='product-price')
    prices = [float(price.text.replace('$', '')) for price in price_elements]
    
    # 绘制价格走势图表
    plt.plot(range(1, len(prices) + 1), prices)
    plt.xlabel('商品序号')
    plt.ylabel('价格（美元）')
    plt.title('商品价格走势')
    plt.show()
else:
    print(f"请求失败，状态码：{response.status_code}")

💎 总结