import pandas as pd
from datetime import datetime

# 讀取多個(gè)數(shù)據(jù)源
df1 = pd.read_csv('system_a_export.csv')
df2 = pd.read_excel('system_b_export.xlsx')

# 合并數(shù)據(jù)
merged = pd.merge(df1, df2, on='order_id', how='left')

# 添加統(tǒng)計(jì)
summary = merged.groupby('category')['amount'].sum().reset_index()

# 導(dǎo)出報(bào)表
today = datetime.now().strftime('%Y%m%d')
summary.to_excel(f'daily_report_{today}.xlsx', index=False)
print(f'日?qǐng)?bào)已生成：daily_report_{today}.xlsx')

from PIL import Image
import os

def batch_compress_images(folder_path, quality=80):
    """批量壓縮圖片"""
    for filename in os.listdir(folder_path):
        if filename.endswith(('.jpg', '.png')):
            img = Image.open(os.path.join(folder_path, filename))
            img.save(
                os.path.join(folder_path, f'compressed_{filename}'),
                quality=quality,
                optimize=True
            )
    print(f'壓縮完成：{folder_path}')

# 使用
batch_compress_images('./product_images')

import requests
from bs4 import BeautifulSoup
import schedule
import time

def check_price(url):
    """監(jiān)控商品價(jià)格"""
    response = requests.get(url)
    soup = BeautifulSoup(response.text, 'html.parser')
    price = soup.find('span', {'class': 'price'}).text
    return price

def monitor():
    products = [
        ('競(jìng)品 A', 'https://example.com/product1'),
        ('競(jìng)品 B', 'https://example.com/product2'),
    ]
    
    for name, url in products:
        price = check_price(url)
        print(f'{name}: {price}')

# 每小時(shí)檢查一次
schedule.every().hour.do(monitor)

while True:
    schedule.run_pending()
    time.sleep(60)

import smtplib
from email.mime.text import MIMEText

def send_email(subject, body, to_list):
    """發(fā)送郵件"""
    msg = MIMEText(body)
    msg['Subject'] = subject
    msg['From'] = 'your_email@example.com'
    msg['To'] = ', '.join(to_list)
    
    with smtplib.SMTP('smtp.example.com', 587) as server:
        server.starttls()
        server.login('your_email', 'your_password')
        server.send_message(msg)

# 使用
send_email(
    subject='項(xiàng)目進(jìn)度更新',
    body='本周完成：xxx\n下周計(jì)劃：xxx',
    to_list=['team@example.com']
)

import pandas as pd

def clean_data(file_path):
    """數(shù)據(jù)清洗"""
    df = pd.read_csv(file_path)
    
    # 刪除空行
    df = df.dropna()
    
    # 刪除重復(fù)
    df = df.drop_duplicates()
    
    # 格式標(biāo)準(zhǔn)化
    df['phone'] = df['phone'].str.replace('-', '')
    df['date'] = pd.to_datetime(df['date'])
    
    # 導(dǎo)出
    df.to_csv('cleaned_data.csv', index=False)
    return df

# 使用
clean_data('messy_data.csv')

from selenium import webdriver
from datetime import datetime

def capture_screenshot(url, save_path):
    """自動(dòng)截圖"""
    driver = webdriver.Chrome()
    driver.get(url)
    timestamp = datetime.now().strftime('%Y%m%d_%H%M%S')
    driver.save_screenshot(f'{save_path}_{timestamp}.png')
    driver.quit()

# 使用
capture_screenshot('https://example.com/dashboard', './screenshots/daily')

from selenium import webdriver
from selenium.webdriver.common.by import By

def auto_fill_form(url, data):
    """自動(dòng)填表"""
    driver = webdriver.Chrome()
    driver.get(url)
    
    driver.find_element(By.NAME, 'username').send_keys(data['username'])
    driver.find_element(By.NAME, 'email').send_keys(data['email'])
    driver.find_element(By.NAME, 'phone').send_keys(data['phone'])
    driver.find_element(By.XPATH, '//button[@type="submit"]').click()
    
    driver.quit()

# 使用
data = {
    'username': 'your_name',
    'email': 'your@email.com',
    'phone': '13800138000'
}
auto_fill_form('https://example.com/register', data)

import shutil
from datetime import datetime

def backup_folder(source, dest):
    """自動(dòng)備份文件夾"""
    timestamp = datetime.now().strftime('%Y%m%d_%H%M%S')
    backup_name = f'backup_{timestamp}'
    shutil.copytree(source, f'{dest}/{backup_name}')
    print(f'備份完成：{backup_name}')

# 使用
backup_folder('./important_files', './backups')

import requests
import json

def fetch_competitor_info(urls):
    """抓取競(jìng)品信息"""
    results = []
    for url in urls:
        response = requests.get(url)
        # 解析頁(yè)面內(nèi)容
        # ... 添加具體解析邏輯
        results.append({
            'url': url,
            'title': '競(jìng)品標(biāo)題',
            'price': '價(jià)格',
            'timestamp': datetime.now().isoformat()
        })
    
    # 保存到文件
    with open('competitor_data.json', 'w') as f:
        json.dump(results, f, ensure_ascii=False, indent=2)
    
    return results

# 使用
urls = [
    'https://competitor1.com/product',
    'https://competitor2.com/product'
]
fetch_competitor_info(urls)

import schedule
import time

def job1():
    print('執(zhí)行任務(wù) 1：發(fā)送日?qǐng)?bào)')
    # 發(fā)送日?qǐng)?bào)代碼
    
def job2():
    print('執(zhí)行任務(wù) 2：備份數(shù)據(jù)')
    # 備份代碼

# 設(shè)置定時(shí)
schedule.every().day.at("09:00").do(job1)
schedule.every().friday.at("18:00").do(job2)

# 持續(xù)運(yùn)行
while True:
    schedule.run_pending()
    time.sleep(60)