python数据采集入门，轻易拿捏！！

3Ghz

已于 2023-04-26 16:48:02 修改

阅读量421

点赞数 3

文章标签： pandas python 开发语言 httpx

于 2022-11-21 13:27:39 首次发布

本文链接：https://blog.csdn.net/m0_63825760/article/details/127962777

版权

import requests

import random

import pandas as pd

import time

url='https://api-ddc-wscn.awtmt.com/market/kline?prod_code=CN10YR.OTC&tick_count=1500&period_type=86400&fields=tick_at%2Copen_px%2Cclose_px%2Chigh_px%2Clow_px&timestamp=1668816001&adjust_price_type=forward'

headers = {'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36'}

res=requests.get(url,headers=headers).text

content=eval(res)

c1=content.get('data');c2=c1.get('candle');c3=c2.get('CN10YR.OTC');c4=c3.get('lines')

df=pd.DataFrame(c4)

df.columns=['开','收','高','低','日期']

pd.set_option('display.unicode.ambiguous_as_wide', True)

pd.set_option('display.unicode.east_asian_width', True)

times=[]

for i in range(0,len(c4)):

    e=time.strftime("%Y-%m-%d",time.localtime(c4[i][4]))

    times.append(e)

df['日期']=times

print(df)