python—实战训练（五）

最新推荐文章于 2024-07-06 17:14:45 发布

luran_lz

最新推荐文章于 2024-07-06 17:14:45 发布

阅读量297

点赞数

CC 4.0 BY-SA版权

分类专栏： Python学习

本文链接：https://blog.youkuaiyun.com/luran_lz/article/details/88854102

该博客介绍了如何读取平安银行一年的CSV股票数据，从中筛选出成交量超过1百万手的交易日，并将这些交易日的open、high、low、close和amount数据导出到Excel文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

题目：
1.拿到平安银行一年的股票数据 csv文件
2.里面一共244个交易日，我们读取csv文件，然后找到成交量(amount)大于1百万手的交易日的数据

3.然后把大于1百万手的那天的如下数据:
open
high
low
close
amount
写入excel文件

import csv,xlwt
def reader_csv(path):
	res = []
	file = open(path)
	data = csv.reader(file)
	for row in data:
		if data.line_num==1:
			continue
		elif float(row[-1])>=1000000:
			res.append([row[3],row[4],row[5],row[6],row[-1]])
	return res
def exchange_to_excel(data):
	workbook = xlwt.Workbook()
	sheet = workbook.add_sheet('data')
	row_num = 0
	for line in data:
		cell_num = 0
		for i in line:
			sheet.write(row_num,cell_num,i)
			cell_num = cell_num+1
		row_num = row_num + 1
	workbook.save('/Users/lu-zyr/Downloads/000001.xls')
def main ():
	path = "/Users/lu-zyr/Downloads/000001.csv"
	result = reader_csv(path)
	for i in result:
 		print(i)
	exchange_to_excel(result)

if __name__=='__main__':
	main()

运行结果

['10.59', '10.66', '10.47', '10.59', '1126374.829']
['10.75', '10.8', '10.52', '10.57', '1099654.683']
['10.57', '10.88', '10.57', '10.85', '1466899.416']
['10.61', '10.72', '10.49', '10.57', '1123173.219']
['10.41', '10.65', '10.38', '10.54', '1126736.143']
['10.71', '10.73', '10.4', '10.55', '1716198.382']
['10.95', '11.04', '10.82', '10.92', '1409457.171']
['11.04', '11.16', '10.83', '11.09', '2439179.135']
['10.99', '11.05', '10.76', '10.83', '1679443.449']
['10.95', '10.99', '10.75', '10.9