# 直感的で読みやすい構文
files = ['report1.xlsx', 'report2.xlsx', 'report3.xlsx']
for file in files:
process_excel_file(file)
print(f'{file} の処理が完了しました')

import pandas as pd
import glob
from datetime import datetime
def merge_excel_reports():
    """複数のExcelファイルを統合"""
files = glob.glob('reports/*.xlsx')
all_data = []
for file in files:
df = pd.read_excel(file)
df['ファイル名'] = file
df['処理日時'] = datetime.now()
all_data.append(df)
merged_df = pd.concat(all_data, ignore_index=True)
output_file = f'統合レポート_{datetime.now().strftime("%Y%m%d")}.xlsx'
merged_df.to_excel(output_file, index=False)
print(f'統合完了: {len(files)}ファイル → {output_file}')
return output_file
# 実行例
if __name__ == '__main__':
merge_excel_reports()

import requests
from bs4 import BeautifulSoup
import time
from datetime import datetime
class PriceMonitor:
def __init__(self, target_price):
self.target_price = target_price
def get_current_price(self, url):
        """商品価格を取得"""
headers = {
'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36'
}
response = requests.get(url, headers=headers)
soup = BeautifulSoup(response.content, 'html.parser')
price_element = soup.find('span', class_='price')
if price_element:
price_text = price_element.text.strip()
price = int(''.join(filter(str.isdigit, price_text)))
return price
return None
def monitor(self, url, product_name, check_interval=3600):
        """価格監視開始"""
print(f'{product_name}の価格監視を開始します')
while True:
try:
current_price = self.get_current_price(url)
if current_price and current_price <= self.target_price:
print(f'目標価格達成！現在価格: ¥{current_price:,}')
break
print(f'現在価格: ¥{current_price:,} (目標: ¥{self.target_price:,})')
time.sleep(check_interval)
except Exception as e:
print(f'エラー: {e}')
time.sleep(300)
# 使用例
monitor = PriceMonitor(target_price=50000)
monitor.monitor('https://example.com/product', 'ノートPC')

import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
import pandas as pd
class EmailAutomation:
def __init__(self, smtp_server, port, username, password):
self.smtp_server = smtp_server
self.port = port
self.username = username
self.password = password
def send_personalized_emails(self, recipient_file, template_file, subject):
        """パーソナライズされたメールを一括送信"""
recipients = pd.read_excel(recipient_file)
with open(template_file, 'r', encoding='utf-8') as f:
template = f.read()
server = smtplib.SMTP(self.smtp_server, self.port)
server.starttls()
server.login(self.username, self.password)
success_count = 0
for _, row in recipients.iterrows():
try:
personalized_content = template.format(
name=row['名前'],
company=row['会社名']
)
msg = MIMEMultipart()
msg['From'] = self.username
msg['To'] = row['メールアドレス']
msg['Subject'] = subject.format(name=row['名前'])
msg.attach(MIMEText(personalized_content, 'plain', 'utf-8'))
server.send_message(msg)
success_count += 1
print(f'送信完了: {row["名前"]}')
except Exception as e:
print(f'送信失敗: {row["名前"]} - {e}')
server.quit()
print(f'一括送信完了: {success_count}/{len(recipients)}件')
# 使用例
email_sender = EmailAutomation(
smtp_server='smtp.gmail.com',
port=587,
username='your-email@gmail.com',
password='your-app-password'
)