csv文件:
Month,Sales
1-01,3071.5425
1-02,3068.012
1-03,3128.9271
1-04,3117.9739
1-05,3075.0301
1-06,3082.2316
1-07,3081.1773
1-08,3100.8586
1-09,3091.0334
1-10,3136.6448
import numpy as np
from pandas import read_csv
series = read_csv('stocktest.csv', header=0, parse_dates=[0], index_col=0, squeeze=True)
values = series.values
values = values.reshape(len(values), 1) #重构成二维数组
print(np.shape(values))
leftDataProp = [] # 创建一个数组来存储数据
# 读取除首行以后每一行的第1列数据,并将其加入到数组leftDataProp之中
for r in values:
#for r in values[0:30]:(前三十行的平均值)
leftDataProp.append(float(r[0])) # 将字符串数据转化为浮点型加入到数组之中
print('均值:', np.mean(leftDataProp)) # 输出均值
'
(360, 1)
均值: 2855.3491080555555
'