# 直感的で読みやすい構文
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')