import pandas as pd
import numpy as np
#创建一个符合正态分布的10个股票5天的涨跌幅数据
stock_change = np.random.normal(0,1,(10,5))#标准差为1，平均值为0
#添加行索引
stock = [f"股票{i}" for i in range(10)]
#添加列索引
date = pd.date_range(start = "20250101", periods=5, freq = "B")# freq = "B" ， B代表工作日,连续的工作日
data = pd.DataFrame(stock_change,index = stock, columns = date)#行：index，列： column
data.plot(x = '2025-01-03',y = '2025-01-02',kind = 'scatter')#在pandas中x和y都是列名
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
plt.rcParams['font.sans-serif'] = ['SimHei']
plt.rcParams['axes.unicode_minus'] = False
# 创建一个符合正态分布的10个股票5天的涨跌幅数据
stock_change = np.random.normal(0, 1, (10, 5)) # 标准差为1，平均值为0
# 添加行索引
stock = [f"股票{i}" for i in range(10)]
# 添加列索引
date = pd.date_range(start="20250101", periods=5, freq="B") # freq="B" 表示工作日
# 创建 DataFrame
data = pd.DataFrame(stock_change, index=stock, columns=date)
# 打印数据以确认
print(data)
# 绘制某一天（例如 "2025-01-02"）的涨跌幅柱状图
data["2025-01-02"].plot(
kind="bar", # 柱状图
figsize=(10, 6), # 图形大小
color="skyblue", # 柱子颜色
title="2025-01-02 股票涨跌幅", # 图表标题
rot=45, # x轴标签旋转角度
grid=True # 显示网格线
)
文件读取与存储
# CSV
import pandas as pd
# pd.read_csv("D:/BaiduNetdiskDownload/day2资料/02-代码/test.csv",usecols = ['value1','value3']])#usecols可选择显示的数据列，names=[]
