同花顺问财数据获取方法
同花顺问财是金融数据获取的重要工具,提供股票、基金、宏观经济等各类金融数据。通过Python可以高效地从问财获取所需数据。
安装必要库
使用requests和pandas库处理网络请求和数据整理:
pip install requests pandas基本数据获取代码框架
构建获取问财数据的通用代码框架:
import requests import pandas as pd def get_wencai_data(query, columns=None): url = f"http://www.iwencai.com/unifiedwap/unified-wap/result/get-stock-pick" params = { "question": query, "perpage": 10000 } headers = { "User-Agent": "Mozilla/5.0" } response = requests.get(url, params=params, headers=headers) data = response.json()["data"]["list"] df = pd.DataFrame(data) if columns: df = df[columns] return df常用查询示例
获取A股所有股票代码和名称:
stock_list = get_wencai_data("A股股票", columns=["股票代码", "股票简称"])筛选市盈率低于10倍的股票:
low_pe_stocks = get_wencai_data("市盈率小于10 主板", columns=["股票代码", "股票简称", "市盈率"])数据清洗与处理
对获取的数据进行清洗和处理:
# 转换数值型数据 low_pe_stocks["市盈率"] = pd.to_numeric(low_pe_stocks["市盈率"], errors="coerce") # 去除异常值 clean_data = low_pe_stocks.dropna()https://www.zhihu.com/zvideo/1994547787254227729/
https://www.zhihu.com/zvideo/1994547784943166304/
https://www.zhihu.com/zvideo/1994547783714247721/
https://www.zhihu.com/zvideo/1994547783038952423/
https://www.zhihu.com/zvideo/1994547782434956430/
https://www.zhihu.com/zvideo/1994547781931640306/
https://www.zhihu.com/zvideo/1994547782057496888/
https://www.zhihu.com/zvideo/1994547781369610655/
https://www.zhihu.com/zvideo/1994547781063444045/
https://www.zhihu.com/zvideo/1994547781289919910/
https://www.zhihu.com/zvideo/1994547780576907386/
https://www.zhihu.com/zvideo/1994547778152583337/
https://www.zhihu.com/zvideo/1994547778353910368/
https://www.zhihu.com/zvideo/1994547775917028949/
https://www.zhihu.com/zvideo/1994547776088994452/
https://www.zhihu.com/zvideo/1994547773865997505/
https://www.zhihu.com/zvideo/1994547772884530981/
https://www.zhihu.com/zvideo/1994547771030644364/
https://www.zhihu.com/zvideo/1994547769994671840/
https://www.zhihu.com/zvideo/1994547769923372054/
https://www.zhihu.com/zvideo/1994547769499738983/
https://www.zhihu.com/zvideo/1994547764596601342/
https://www.zhihu.com/zvideo/1994547763959072685/
https://www.zhihu.com/zvideo/1994547762394583739/
https://www.zhihu.com/zvideo/1994547762734334563/
https://www.zhihu.com/zvideo/1994547761002075008/
https://www.zhihu.com/zvideo/1994547760368742854/
https://www.zhihu.com/zvideo/1994547758976221618/
https://www.zhihu.com/zvideo/1994547758418375249/
https://www.zhihu.com/zvideo/1994547758498083954/
https://www.zhihu.com/zvideo/1994547757336244497/
https://www.zhihu.com/zvideo/1994547752659615874/
https://www.zhihu.com/zvideo/1994547753372635576/
https://www.zhihu.com/zvideo/1994547752374404733/
https://www.zhihu.com/zvideo/1994547752114340074/
https://www.zhihu.com/zvideo/1994547752194044389/
https://www.zhihu.com/zvideo/1994547752533787691/
https://www.zhihu.com/zvideo/1994547751913021526/
https://www.zhihu.com/zvideo/1994547751434872309/
https://www.zhihu.com/zvideo/1994547751380332761/
https://www.zhihu.com/zvideo/1994547751095121071/
https://www.zhihu.com/zvideo/1994547747546760736/
https://www.zhihu.com/zvideo/1994547745852237087/
https://www.zhihu.com/zvideo/1994547744208078625/
https://www.zhihu.com/zvideo/1994547745206323128/
https://www.zhihu.com/zvideo/1994547744128386874/
https://www.zhihu.com/zvideo/1994547743893520501/
https://www.zhihu.com/zvideo/1994547743549562926/
https://www.zhihu.com/zvideo/1994547742844937856/
https://www.zhihu.com/zvideo/1994547740953289640/
高级查询技巧
使用问财的高级语法进行复杂查询:
# 查询ROE连续3年大于15%的股票 quality_stocks = get_wencai_data("ROE连续3年大于15% 非ST", columns=["股票代码", "股票简称", "ROE"])注意事项
问财数据接口可能有访问频率限制,建议合理控制请求频率。对于大量数据获取,考虑分批次查询。商业用途需遵守同花顺的相关使用条款。