from openpyxl import Workbook

data = [
    ['姓名', '部門(mén)', '成績(jī)'],
    ['張三', '銷售部', 89],
    ['李四', '技術(shù)部', 95]
]

wb = Workbook()
ws = wb.active
ws.title = "員工成績(jī)表"

for row in data:
    ws.append(row)

wb.save("員工成績(jī)表.xlsx")
print(" Excel 報(bào)表已生成。")

import smtplib
from email.message import EmailMessage

msg = EmailMessage()
msg['Subject'] = '日?qǐng)?bào) - 自動(dòng)發(fā)送'
msg['From'] = 'your_email@example.com'
msg['To'] = 'receiver@example.com'
msg.set_content('請(qǐng)查收今日日?qǐng)?bào)，見(jiàn)附件。')

# 添加附件
with open('日?qǐng)?bào).xlsx', 'rb') as f:
    msg.add_attachment(f.read(), maintype='application',
                       subtype='vnd.openxmlformats-officedocument.spreadsheetml.sheet',
                       filename='日?qǐng)?bào).xlsx')

# 發(fā)送郵件（使用QQ郵箱為例）
with smtplib.SMTP_SSL('smtp.qq.com', 465) as smtp:
    smtp.login('your_email@example.com', 'your_app_password')
    smtp.send_message(msg)

print(" 郵件已發(fā)送。")

import pdfplumber

with pdfplumber.open('文件.pdf') as pdf:
    all_text = ''
    for page in pdf.pages:
        all_text += page.extract_text() + '\n'

with open('提取內(nèi)容.txt', 'w', encoding='utf-8') as f:
    f.write(all_text)

print(" PDF 文本已提取。")

import webbrowser
import pyautogui
import time

# 打開(kāi)網(wǎng)頁(yè)
webbrowser.open('https://www.google.com')
time.sleep(3)  # 等待頁(yè)面加載

# 模擬輸入搜索內(nèi)容
pyautogui.write('Python automation', interval=0.1)
pyautogui.press('enter')

print(" 自動(dòng)搜索已完成。")

import schedule
import time

def job():
    print("現(xiàn)在是：", time.strftime("%H:%M:%S"), " → 執(zhí)行任務(wù)")

# 每天早上 9 點(diǎn)執(zhí)行
schedule.every().day.at("09:00").do(job)

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

pip install openpyxl pandas

import pandas as pd
import os

folder = './excel_files'  # Excel 文件所在文件夾
output_file = '合并結(jié)果.xlsx'

all_data = []

for file in os.listdir(folder):
    if file.endswith('.xlsx'):
        file_path = os.path.join(folder, file)
        df = pd.read_excel(file_path)
        df['來(lái)源文件'] = file  # 可選：添加來(lái)源文件列
        all_data.append(df)

# 合并所有數(shù)據(jù)
merged_df = pd.concat(all_data, ignore_index=True)
merged_df.to_excel(output_file, index=False)

print(" 所有 Excel 文件已合并到：", output_file)

import pandas as pd
import os

folder = './excel_files'

for file in os.listdir(folder):
    if file.endswith('.xlsx'):
        path = os.path.join(folder, file)
        df = pd.read_excel(path)

        # 修改 “狀態(tài)” 列中的“未完成”為“完成”
        df['狀態(tài)'] = df['狀態(tài)'].replace('未完成', '完成')

        # 保存覆蓋原文件
        df.to_excel(path, index=False)
        print(f" 已修改：{file}")

import pandas as pd
import os

input_file = '員工信息表.xlsx'
df = pd.read_excel(input_file)

# 篩選工資大于10000的員工
filtered = df[df['工資'] > 10000]

filtered.to_excel('高薪員工.xlsx', index=False)
print(" 篩選結(jié)果已保存。")

import pandas as pd
import os

df = pd.read_excel('員工信息.xlsx')

output_dir = './員工報(bào)表'
os.makedirs(output_dir, exist_ok=True)

# 按“姓名”分組，每個(gè)員工一個(gè)文件
for name, group in df.groupby('姓名'):
    filename = os.path.join(output_dir, f'{name}_報(bào)表.xlsx')
    group.to_excel(filename, index=False)
    print(f" 已生成：{filename}")

import os
import pandas as pd

# === 配置區(qū)域 ===
input_folder = r"./excel_input"       # 待處理Excel文件所在文件夾
output_folder = r"./excel_output"     # 清洗后文件保存文件夾
subset_columns = None                 # 去重依據(jù)的列，例如 ["姓名", "身份證號(hào)"]，None表示全列去重
keep_rule = "first"                   # 保留規(guī)則: "first" 保留首次出現(xiàn), "last" 保留最后一次, False 保留所有重復(fù)(不常用)

# 創(chuàng)建輸出文件夾
os.makedirs(output_folder, exist_ok=True)

# 遍歷文件夾中的所有Excel文件
for filename in os.listdir(input_folder):
    if filename.lower().endswith((".xls", ".xlsx")):
        file_path = os.path.join(input_folder, filename)
        
        try:
            # 讀取Excel（保留所有sheet）
            xls = pd.ExcelFile(file_path)
            cleaned_sheets = {}
            
            for sheet_name in xls.sheet_names:
                df = pd.read_excel(xls, sheet_name=sheet_name)
                
                # 去重
                before_rows = len(df)
                df_cleaned = df.drop_duplicates(subset=subset_columns, keep=keep_rule)
                after_rows = len(df_cleaned)
                
                print(f"{filename} - {sheet_name}: {before_rows} -> {after_rows} 行")
                
                cleaned_sheets[sheet_name] = df_cleaned
            
            # 保存清洗后的文件
            output_path = os.path.join(output_folder, filename)
            with pd.ExcelWriter(output_path, engine="openpyxl") as writer:
                for sheet_name, df_cleaned in cleaned_sheets.items():
                    df_cleaned.to_excel(writer, sheet_name=sheet_name, index=False)
        
        except Exception as e:
            print(f"處理文件 {filename} 時(shí)出錯(cuò): {e}")

print(" 數(shù)據(jù)清洗完成！")