import matplotlib.pyplot as plt
# 數(shù)據(jù)
x = [1, 2, 3, 4, 5]
y = [10, 8, 6, 4, 2]
# 繪制折線圖
plt.plot(x, y)
# 添加標題和標簽
plt.title('折線圖示例')
plt.xlabel('X軸')
plt.ylabel('Y軸')
# 顯示圖表
plt.show()

import seaborn as sns
# 數(shù)據(jù)
x = ['A', 'B', 'C', 'D']
y = [10, 8, 6, 4]
# 繪制柱狀圖
sns.barplot(x, y)
# 添加標題和標簽
plt.title('柱狀圖示例')
plt.xlabel('X軸')
plt.ylabel('Y軸')
# 顯示圖表
plt.show()

import pandas as pd
# 數(shù)據(jù)
data = {'姓名': ['張三', '李四', '王五'],
        '年齡': [25, 30, 35],
        '性別': ['男', '女', '男']}
# 創(chuàng)建DataFrame
df = pd.DataFrame(data)
# 生成報表
df.to_excel('report.xlsx', index=False)

from openpyxl import Workbook
# 創(chuàng)建工作簿和工作表
wb = Workbook()
ws = wb.active
# 數(shù)據(jù)
data = [['姓名', '年齡', '性別'],
        ['張三', 25, '男'],
        ['李四', 30, '女'],
        ['王五', 35, '男']]
# 寫入數(shù)據(jù)
for row in data:
    ws.append(row)
# 保存工作簿
wb.save('report.xlsx')

import requests
import pandas as pd
import matplotlib.pyplot as plt
from openpyxl import Workbook
# 億牛云爬蟲代理信息
proxyHost = 't.16yun.cn'
proxyPort = 30001
# 代理配置
proxy = f'http://{proxyHost}:{proxyPort}'
proxies = {
    'http': proxy,
    'https': proxy
}
# 網(wǎng)頁請求
url = 'https://example.com'
response = requests.get(url, proxies=proxies)
# 數(shù)據(jù)處理
data = response.json()
df = pd.DataFrame(data)
# 數(shù)據(jù)可視化
plt.plot(df['x'], df['y'])
plt.xlabel('x')
plt.ylabel('y')
plt.title('Data Visualization')
plt.show()
# 報表生成
wb = Workbook()
ws = wb.active
for i, row in enumerate(df.iterrows()):
    ws.cell(row=i+1, column=1, value=row[1]['x'])
    ws.cell(row=i+1, column=2, value=row[1]['y'])
wb.save('data_report.xlsx')