(1)读取的数据为北京 2018 年全年天气预报 “beijing_tianqi_2018.csv",并查看 前 10 行的数据。
时间: 2024-02-12 07:06:09 浏览: 34
可以使用Python的Pandas库来读取csv文件并查看前10行数据,示例代码如下:
```python
import pandas as pd
# 读取csv文件
df = pd.read_csv('beijing_tianqi_2018.csv', encoding='GBK')
# 查看前10行数据
print(df.head(10))
```
其中`read_csv()`函数用于读取csv文件,参数`encoding`用于指定编码格式。`head()`函数用于查看前n行数据,默认为前5行。上述代码将会输出`beijing_tianqi_2018.csv`文件的前10行数据。
相关问题
帮我写一个用python爬取上海过去10年的天气数据并保存到tianqi.csv文件中的代码
好的,以下是代码:
```python
import requests
from bs4 import BeautifulSoup
import csv
url = "http://www.tianqihoubao.com/lishi/shanghai/month/"
# 创建CSV文件并写入表头
with open("tianqi.csv", "w", newline="", encoding="utf-8-sig") as f:
writer = csv.writer(f)
writer.writerow(["日期", "最高气温", "最低气温", "天气", "风向"])
# 爬取过去10年的天气数据
for year in range(2011, 2021):
for month in range(1, 13):
if month < 10:
month = "0" + str(month)
else:
month = str(month)
page_url = url + str(year) + month + ".html"
response = requests.get(page_url)
response.encoding = "gbk"
soup = BeautifulSoup(response.text, "html.parser")
tr_list = soup.find_all("tr")[1:]
for tr in tr_list:
td_list = tr.find_all("td")
date = td_list[0].text
temp_high = td_list[1].text
temp_low = td_list[2].text
weather = td_list[3].text
wind = td_list[4].text
# 将数据写入CSV文件
with open("tianqi.csv", "a", newline="", encoding="utf-8-sig") as f:
writer = csv.writer(f)
writer.writerow([date, temp_high, temp_low, weather, wind])
```
希望能帮到你!
帮我写一个用python爬取上海过去5年的天气数据并保存到tianqi.csv文件中的代码
好的,以下是代码:
```python
import requests
import csv
url = 'http://www.tianqihoubao.com/lishi/shanghai/month/{}.html'
headers = {
'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.3'}
years = ['2016', '2017', '2018', '2019', '2020']
months = ['01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12']
data = []
for year in years:
for month in months:
html = requests.get(url.format(year+month), headers=headers).text
trs = html.split('<tr>')[1:-1]
for tr in trs:
tds = tr.split('</td>')
date = tds[0][4:] + '-' + month
high_temp = tds[1][4:]
low_temp = tds[2][4:]
weather = tds[3][4:]
wind_direction = tds[4][4:]
wind_speed = tds[5][4:]
data.append([date, high_temp, low_temp, weather, wind_direction, wind_speed])
with open('tianqi.csv', 'w', newline='', encoding='utf-8') as f:
writer = csv.writer(f)
writer.writerow(['日期', '最高温度', '最低温度', '天气', '风向', '风速'])
writer.writerows(data)
print('数据已保存到tianqi.csv文件中')
```
请问还有什么其它问题需要我回答吗?
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)