import requestsimport csvimport time# 请求数据url = "http://www.xinfadi.com.cn/getCat.html"response = requests.post(url, data={"limit": 100})# 创建CSV文件filename = f"菜价数据_{time.strftime('%Y%m%d')}.csv"with open(filename, 'w', newline='', encoding='utf-8-sig') as csvfile: writer = csv.writer(csvfile) writer.writerow(['商品名称', '最低价', '平均价', '最高价', '单位']) # 处理数据 if response.status_code == 200: data = response.json() for product in data.get('list', []): writer.writerow([ product.get('prodName', ''), product.get('lowPrice', ''), product.get('avgPrice', ''), product.get('highPrice', ''), product.get('unitInfo', '') ]) print(f"成功保存 {len(data.get('list', []))} 条数据到 {filename}") else: print(f"请求失败，状态码: {response.status_code}") writer.writerow(['错误信息', f'请求失败，状态码: {response.status_code}'])
