python实验:sqlist，pandas和爬虫

1.使用select查询，数据库名字.execute("SELECT 数据名称 FROM 表名字")

2.使用pandans创建数据分析库并构建指定类名行名

import pandas as pd
# 已知淡水鱼数据  
data = [  
    ['f1','鲤鱼','杂食性',300],  
    ['f2','草鱼','食草性',240],  
    ['f3','鲫鱼','温水性',500],  
    ['f4','鳙鱼','温水性',400],  
    ['f5','黑鱼','肉食性',480],  
]  
df=pd.DataFrame(data,columns=['a','b','c','d','e'])

3.爬虫

import requests
from bs4 import BeautifulSoup
url="网址"
respons=requests.get(url)
if respons.status_code=200
    soup==BeautifulSoup(respons.text,'html.parser')
    for link in soup.find_all('a',string=lambda text:"计算机科学"in text):
          print(link.get_text(strip=True), link.get('href'))