修改以上代码,将经纬度以及输出结果都以csv格式保存到桌面
时间: 2024-03-12 20:48:05 浏览: 9
好的,您可以参考以下代码实现:
```python
import requests
import csv
import os
from datetime import datetime
# API endpoint
url = "https://api.sunrise-sunset.org/json"
# Location coordinates
lat = "36.7201600"
lng = "-4.4203400"
# Date for which to retrieve sunrise/sunset times
date = datetime.today().strftime('%Y-%m-%d')
# Parameters for API request
params = {"lat": lat, "lng": lng, "date": date}
# Send GET request to API
response = requests.get(url, params=params)
# Parse JSON response
data = response.json()["results"]
# Output sunrise/sunset times as CSV file on desktop
desktop_path = os.path.join(os.path.expanduser("~"), "Desktop")
filename = f"{date}_sunrise_sunset.csv"
filepath = os.path.join(desktop_path, filename)
with open(filepath, "w", newline="") as csvfile:
fieldnames = ["Date", "Latitude", "Longitude", "Sunrise", "Sunset"]
writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
writer.writeheader()
writer.writerow({
"Date": date,
"Latitude": lat,
"Longitude": lng,
"Sunrise": data["sunrise"],
"Sunset": data["sunset"]
})
print(f"Sunrise/sunset times saved to {filename} on desktop.")
```
这段代码将会在您的桌面上生成一个名为 `YYYY-MM-DD_sunrise_sunset.csv` 的文件,并将当天的日出和日落时间以及经纬度信息保存为 CSV 格式。