实验要求：

1. 数据为csv格式，每一列分别为日期（Date），收盘价（Price），开盘价（Open），当日最高价（High），当日最低价（Low）。
2. 股市不是每天开盘的（周末和法定节假日休市）。非交易日的各项数据为NaN，请使用编程的方式删除该数据，并在屏幕上打印出删除行数的统计信息。
3. 源数据应当每个交易日存在一条记录，请使用编程的方式检查并删除日期重复的数据，并在屏幕上打印出删除行数的统计信息。
4. 在中国，股价的波动范围为通常为±10%（即涨停和跌停），但在美股中没有这项规定。请使用编程的方式计算在10年间共有多少次股价单日涨跌幅度超过±10%。具体的计算公式为：(今日收盘 - 昨日收盘) / 昨日收盘 × 100%。请在屏幕上分别打印出总计天数的统计信息。
5. 股价在一天之内往往有高低波动，请分别计算每日股价最高与最低之间的差值，存在Diff列中，与经过前述数据清洗后的结果合并后保存为新的csv文件。

注：数据源来自证券公司，为本门课程实验添加了适量脏数据，模拟实际应用中可能出现的情况，以供同学们练习。

数据集下载：
TSLA.csv

上机实现：

导入需要用到的包

import pandas as pd
import numpy as np
import os
import csv

导入实验数据

data_dir = "D:\\DataAnalysis"
fname = os.path.join(data_dir, "TSLA.csv")
f=open(fname,encoding='utf-8')
data=pd.read_csv(f)
#print(data.head(10))
f.close()
print(type(data))

<class 'pandas.core.frame.DataFrame'>

进行数据预览

data

运行结果：

2536 rows × 5 columns

以上数据有2536行，5列

进行数据清洗

一、检查每个Series列中空值有多少行

nan_in_data = data.isnull().sum()
print(nan_in_data)

Date      0
Price    50
Open     50
High     50
Low      50
dtype: int64

二、删除存在空值的行

print(data["Price"].value_counts('NaN'))
data.drop(data[np.isnan(data['Price'])].index, inplace=True)
print(data[np.isnan(data['Price'])].index)
data
#print(data.head(1000))

6.53     0.002816
43.92    0.002414
6.76     0.002011
5.90     0.002011
5.88     0.002011
           ...   
54.67    0.000402
54.25    0.000402
54.65    0.000402
52.55    0.000402
65.23    0.000402
Name: Price, Length: 2080, dtype: float64
Int64Index([], dtype='int64')

2486 rows × 5 columns

nan_in_data = data['Price'].isnull().sum()
print(nan_in_data)

0

三、初步删除结束后进行一次预览

data_no_NaN = data[data['Price'].notna()]
data_no_NaN

2486 rows × 5 columns

data.dropna()

2486 rows × 5 columns

四、删除日期重复的数据

data2 = data.drop_duplicates('Date',keep='first')
print(data2)
print(data_no_NaN['Date'].count() -data2['Date'].count())

运行结果 Date Price Open High Low
0 2022/4/14 985.00 999.29 1012.71 982.19
1 2022/4/13 1022.37 981.08 1026.24 973.10
2 2022/4/12 986.95 997.64 1021.19 976.60
3 2022/4/11 975.93 980.40 1008.47 974.64
6 2022/4/8 1025.49 1043.21 1048.44 1022.43
… … … … … …
2525 2012/4/23 6.39 6.57 6.59 6.34
2526 2012/4/20 6.63 6.63 6.75 6.59
2527 2012/4/19 6.63 6.55 6.69 6.50
2528 2012/4/18 6.53 6.42 6.55 6.31
2535 2012/4/17 6.45 6.49 6.61 6.41

[2478 rows x 5 columns]
8

计算10年内多少次单日涨跌幅超过-+10%

for row in data2['Price']:
  print(row)

运行结果985.0
1022.37
986.95
975.93
1025.49
1057.26
1045.76
1091.26
1145.45
1084.59
1077.6
1093.99
1099.57
1091.84
1010.64
1013.92
999.11
993.98
921.16
905.39
871.6
840.23
801.89
766.37
795.35
838.3
858.97
824.4
804.58
879.89
864.37
870.43
809.87
800.77
856.98
876.35
923.39
922.43
875.76
932.0
922.0
907.34
923.32
891.14
936.72
846.35
829.1
937.41
918.4
996.27
995.65
1030.51
1049.61
1031.56
1058.12
1026.96
1064.7
1088.12
1149.59
1070.34
1086.19
1088.47
1093.94
1067.0
899.94
932.57
926.92
975.99
958.51
1003.8
1068.96
1051.75
1009.01
1014.97
1144.76
1136.99
1081.92
1116.0
1109.03
1096.38
1089.01
1054.73
1013.39
1033.42
1023.5
1162.94
1222.09
1229.91
1213.86
1114.0
1077.04
1037.86
1018.43
1024.86
865.8
864.27
870.11
843.03
818.32
791.94
785.49
793.61
782.75
780.59
775.48
781.31
777.56
791.36
774.39
739.38
730.17
759.49
756.99
755.83
736.27
754.86
753.87
752.92
733.57
735.72
730.91
711.92
701.16
711.2
680.26
673.47
688.99
665.71
686.17
717.17
722.25
707.82
709.99
713.76
699.1
714.63
710.92
709.74
709.67
687.2
677.35
646.98
644.78
657.62
643.38
649.26
655.29
660.5
646.22
644.22
650.6
653.38
668.54
685.7
656.95
652.81
644.65
659.58
678.9
677.92
679.7
680.76
688.72
671.87
679.82
656.57
623.71
620.83
623.31
616.6
604.87
599.36
617.69
609.89
610.12
598.78
603.59
605.13
599.05
572.84
605.12
623.9
625.22
630.85
619.13
604.69
606.44
580.88
586.78
563.46
577.87
576.83
589.74
571.69
589.89
617.2
629.04
672.37
663.54
670.94
673.6
684.9
709.44
677.0
694.4
704.74
738.2
729.4
719.69
744.12
718.99
714.63
739.78
738.85
732.23
762.32
701.98
677.02
683.8
670.97
691.62
691.05
661.75
667.93
635.62
611.29
618.71
640.39
630.27
662.16
670.0
654.87
653.16
701.81
676.88
707.94
693.73
699.6
668.06
673.58
563.0
597.95
621.44
653.2
686.44
718.43
675.5
682.22
742.02
698.84
714.5
781.3
787.38
798.15
796.22
816.12
811.66
804.82
849.46
863.42
852.23
849.99
854.69
872.79
839.81
793.53
835.43
864.16
883.09
880.8
846.64
844.99
850.45
844.55
826.16
845.0
854.41
849.44
811.19
880.02
816.04
755.98
735.11
729.77
705.67
694.78
665.99
663.69
661.77
645.98
640.34
649.86
695.0
655.9
622.77
633.25
639.83
609.99
627.07
604.48
649.88
641.76
599.04
593.38
568.82
584.76
567.6
585.76
574.0
555.38
521.85
489.61
499.27
486.64
441.61
408.09
408.5
411.76
417.13
410.36
421.26
429.95
438.09
420.98
423.9
400.51
388.04
410.83
406.02
424.68
420.28
420.63
425.79
422.64
421.94
430.83
439.67
448.88
461.3
446.65
442.3
434.0
425.92
425.3
413.98
425.68
415.09
448.16
429.01
419.07
421.2
407.34
387.79
380.36
424.23
449.39
442.15
423.43
441.76
449.76
419.62
372.72
371.34
366.28
330.21
418.32
407.0
447.37
475.05
498.32
442.68
447.75
430.63
404.67
402.84
410.0
400.37
375.71
377.42
367.13
330.14
324.2
310.95
274.88
283.71
290.54
297.92
297.0
297.4
297.0
286.15
297.5
299.82
295.3
307.92
283.4
302.61
318.47
313.67
328.6
300.17
300.13
309.2
303.36
299.41
308.93
278.86
273.18
277.97
274.32
241.73
223.93
215.96
201.87
191.95
197.2
192.17
200.36
198.86
200.18
200.79
198.36
196.43
198.18
187.06
194.57
205.01
188.13
189.98
177.13
172.88
176.59
176.31
179.62
167.0
161.16
164.05
163.77
163.38
165.52
163.11
161.6
162.73
159.83
160.67
158.19
161.88
162.26
163.88
156.01
156.52
153.64
152.24
140.26
156.38
160.1
153.82
159.75
145.03
141.13
146.42
137.34
149.27
150.78
149.04
145.97
141.98
130.19
114.6
109.77
109.09
103.25
96.0
90.89
96.31
104.8
100.43
102.87
105.63
107.85
101.0
86.86
85.51
85.53
72.24
86.04
89.01
109.32
112.11
126.85
129.07
121.6
140.7
144.91
149.9
149.1
148.72
133.6
135.8
155.76
159.98
166.76
180.2
179.88
183.48
171.68
160.01
160.8
153.46
154.88
154.26
149.61
149.79
146.94
177.41
156.0
130.11
128.16
116.2
113.38
111.6
112.96
114.44
113.91
109.44
102.1
102.7
103.7
107.58
104.97
95.63
96.27
98.43
93.81
90.31
88.6
86.05
83.67
82.94
86.08
86.19
85.05
83.84
81.12
80.81
78.63
75.8
76.3
71.68
71.94
70.54
69.77
67.91
67.18
66.07
66.61
67.24
66.97
65.99
66.26
65.78
67.27
66.61
70.97
70.44
71.9
70.0
70.43
69.87
69.22
69.99
69.02
67.43
67.11
65.32
63.44
63.49
62.66
62.98
63.0
63.24
65.54
65.63
59.94
50.94
51.12
50.7
51.39
52.39
51.95
51.58
51.39
49.58
48.95
48.91
48.01
47.54
46.29
46.61
48.63
48.94
48.17
48.43
48.51
45.74
44.64
48.25
48.12
49.32
48.7
48.96
48.56
49.04
49.17
49.42
47.11
46.36
45.49
45.92
44.14
45.0
45.12
44.34
43.12
42.82
43.0
42.28
44.43
44.17
45.17
45.37
43.99
43.13
43.92
47.0
45.8
47.0
47.66
46.68
46.15
45.66
46.87
46.77
48.32
48.45
47.15
45.61
45.76
52.98
52.03
51.14
51.64
50.71
50.97
50.48
50.7
49.02
47.72
47.78
46.01
46.07
46.62
46.98
44.91
45.43
44.69
44.57
43.85
43.95
44.73
44.37
43.92
45.29
44.95
45.01
42.98
42.78
41.85
43.42
42.58
40.9
41.19
39.32
38.72
35.79
37.03
37.64
37.97
37.74
38.13
39.1
38.55
41.02
41.07
42.21
45.67
46.39
46.46
45.4
47.9
48.4
48.97
49.41
51.07
51.01
48.82
46.8
47.74
48.29
47.03
49.53
51.73
52.78
52.55
54.65
54.25
54.67
53.28
53.54
53.68
55.21
54.46
54.64
54.99
53.56
58.36
57.18
57.84
55.97
55.72
54.97
53.55
52.08
52.91
54.8
54.72
53.49
53.9
55.09
57.99
57.79
56.67
58.18
56.83
55.32
55.25
55.31
57.07
58.96
63.98
62.95
59.57
59.75
58.94
58.25
60.51
61.13
61.58
60.75
61.63
62.36
62.57
61.16
61.5
63.44
64.27
62.58
62.44
61.4
61.75
59.49
59.28
59.41
58.3
57.52
59.78
60.45
69.46
69.21
68.89
66.88
69.45
68.99
67.71
67.07
66.99
63.54
60.07
62.02
66.56
66.77
63.23
65.22
59.08
63.95
63.08
66.59
67.41
69.68
73.14
75.36
73.32
73.35
73.03
71.59
72.61
71.94
71.7
70.1
68.23
69.57
68.78
69.2
65.17
67.64
69.5
70.69
70.86
69.69
68.8
67.75
66.26
70.1
70.28
69.63
68.21
68.28
69.28
68.86
67.46
65.98
66.97
66.18
62.97
57.7
58.83
52.19
52.0
52.78
54.36
55.32
51.92
51.76
50.45
51.38
52.56
50.11
52.39
56.37
58.96
60.2
62.14
52.95
61.5
61.92
60.2
59.94
59.82
59.67
59.8
56.99
58.97
59.04
57.89
58.11
55.89
57.1
52.65
56.19
56.15
57.79
60.33
60.63
61.0
62.37
63.85
64.56
64.02
64.33
64.38
61.69
61.1
67.09
67.74
69.53
71.28
71.1
70.49
74.07
75.91
68.4
69.63
69.91
60.17
59.63
58.03
59.44
61.33
61.75
59.49
60.64
62.72
64.05
64.77
64.54
62.02
63.77
63.34
63.79
64.49
63.7
61.78
61.83
62.17
67.01
68.59
69.99
68.9
68.4
66.6
66.73
69.5
72.44
70.51
74.17
71.63
71.54
68.96
68.55
66.42
63.53
63.22
63.9
58.23
59.35
58.36
56.95
58.34
56.75
55.77
55.57
55.81
55.0
56.9
55.36
56.91
57.3
56.84
58.39
60.21
61.0
61.37
60.39
60.55
58.82
56.89
60.23
59.98
58.78
58.81
57.1
56.14
56.69
56.67
58.05
60.02
58.67
57.54
58.24
60.07
58.82
60.19
60.94
57.93
59.86
61.14
57.39
53.51
50.5
53.23
51.56
55.84
60.84
60.31
61.82
63.31
62.11
62.71
64.27
65.12
65.33
68.37
69.1
65.43
65.82
66.46
65.64
66.67
67.02
66.19
68.61
70.2
71.48
70.41
69.23
66.66
66.95
67.1
66.81
64.46
64.73
63.15
62.08
63.05
69.0
66.79
66.63
68.75
69.85
70.86
69.16
69.91
68.57
67.53
69.18
70.56
70.31
70.0
68.91
69.43
68.01
67.24
67.59
66.96
66.74
67.28
63.32
62.92
63.45
64.11
62.27
63.07
62.33
63.46
65.04
66.33
65.8
66.22
67.77
68.69
67.58
67.81
68.21
65.78
63.03
62.25
62.65
60.74
61.04
61.31
61.77
61.51
63.51
63.36
63.11
62.52
63.56
61.75
63.01
62.5
62.26
61.74
63.08
60.6
60.6
60.88
61.21
60.56
61.22
59.85
64.22
66.31
64.02
64.17
65.23
65.17
67.47
67.4
69.02
70.36
71.93
71.15
70.12
71.11
71.14
70.92
71.12
68.59
71.38
71.07
71.0
69.63
68.31
68.22
67.92
68.19
69.05
69.0
70.22
73.3
74.78
75.02
77.0
75.96
75.53
73.25
72.55
72.74
68.68
70.12
68.91
69.92
71.08
71.18
70.64
69.47
69.13
69.61
70.59
70.55
68.27
67.57
69.49
70.38
72.58
72.47
72.76
71.57
71.08
72.71
73.04
71.03
71.38
69.42
65.18
63.91
64.69
67.01
66.89
68.77
67.92
68.5
65.68
65.98
65.05
65.65
63.91
65.56
64.68
65.9
65.44
63.21
62.64
61.77
65.42
70.52
72.32
72.15
74.25
72.47
75.5
76.69
76.52
75.28
74.45
73.96
74.28
75.07
76.13
75.19
71.8
71.46
74.0
71.93
70.57
69.46
67.97
68.07
68.2
67.02
65.03
63.37
62.04
60.77
62.07
62.17
62.61
61.22
63.4
63.18
64.96
64.62
65.04
64.25
61.44
61.67
59.09
62.2
63.78
64.57
62.81
61.73
62.03
62.76
61.61
61.12
60.5
61.1
60.05
60.29
60.8
59.37
61.74
62.48
60.51
59.74
59.0
60.74
59.7
55.66
55.58
55.48
55.49
54.04
52.63
50.96
51.0
50.14
52.38
52.3
52.41
51.15
51.6
49.23
48.74
48.98
49.37
49.72
50.24
50.31
50.1
50.0
50.0
49.25
51.4
51.2
54.7
55.48
54.45
53.79
55.95
56.2
56.12
53.85
53.84
52.42
51.5
51.55
50.27
50.31
49.85
50.39
50.13
50.59
50.5
50.89
50.92
49.78
48.95
48.75
47.67
47.12
47.55
45.92
45.95
45.97
46.26
45.8
45.35
45.4
43.4
42.74
42.94
43.95
43.91
42.67
41.69
41.54
41.76
40.55
40.5
39.52
39.74
39.63
38.49
38.44
38.46
38.63
37.17
37.36
36.29
36.38
37.88
37.91
39.22
39.33
38.63
38.23
36.9
37.0
37.73
36.79
36.75
36.29
37.71
37.07
38.01
38.99
38.64
38.11
37.48
37.6
38.16
39.55
39.99
40.8
40.45
40.47
40.55
40.02
39.82
40.71
39.82
38.79
39.3
40.05
40.3
40.02
40.19
39.32
40.2
41.69
42.28
42.74
40.81
40.14
41.25
41.16
41.8
41.49
41.29
41.04
40.93
41.27
41.08
40.08
39.28
39.21
39.66
38.89
39.47
40.34
40.57
39.56
40.15
42.4
42.27
43.04
44.0
44.19
44.52
44.97
44.59
45.0
44.7
44.65
44.72
45.12
45.12
44.98
45.13
45.82
45.23
46.01
46.12
45.16
45.44
46.0
46.96
46.12
45.7
45.9
46.0
44.45
44.1
45.67
45.05
45.25
44.08
44.31
44.51
44.93
44.96
43.36
43.19
42.89
42.8
43.3
42.46
42.04
40.36
39.71
38.63
39.28
39.33
43.92
43.94
43.09
43.59
43.54
42.99
43.57
43.76
45.87
47.1
46.47
44.14
43.8
43.79
43.91
44.65
44.61
45.02
43.92
43.58
43.24
44.06
43.04
42.23
40.93
41.66
41.52
41.46
41.79
41.74
41.78
42.99
42.31
44.51
46.46
48.36
48.15
49.54
50.29
50.75
50.36
50.75
49.66
49.99
49.47
50.78
50.9
50.37
50.91
49.56
49.98
50.01
51.44
53.08
51.09
49.4
47.52
45.95
45.38
46.03
46.05
45.55
44.52
46.85
47.66
46.55
45.28
44.39
43.67
43.03
41.5
41.04
41.74
40.52
41.06
40.21
39.15
37.67
37.27
38.39
190.35
38.07
37.49
35.8
35.44
35.55
33.32
33.35
33.74
31.03
30.21
30.09
28.73
29.65
29.6
32.52
35.07
34.7
36.56
39.39
38.24
37.94
37.61
38.71
39.28
40.51
39.99
39.74
40.94
41.0
41.24
40.06
41.99
41.57
42.2
43.13
43.81
44.69
44.68
48.0
47.62
47.44
45.79
46.11
45.94
45.99
46.51
46.09
46.68
46.9
44.22
43.72
43.4
45.41
44.9
45.34
46.23
46.08
46.54
46.4
47.44
46.05
46.32
45.93
43.65
43.55
44.0
44.36
44.21
42.8
42.86
41.44
42.59
43.82
43.3
45.07
46.47
46.35
46.33
41.67
42.76
41.39
42.33
42.59
42.07
43.05
41.82
42.34
42.02
42.61
45.62
45.4
44.26
43.38
43.85
43.12
44.14
45.34
46.39
48.29
49.23
49.51
47.98
49.68
49.33
49.69
51.38
52.62
52.21
52.19
52.84
52.12
52.41
52.45
50.71
50.64
50.05
49.7
49.78
49.63
48.39
49.11
49.54
47.73
49.81
49.7
48.6
44.97
44.01
43.77
46.15
48.44
51.05
52.14
51.0
48.63
48.5
47.63
47.47
48.23
48.5
49.23
54.03
53.26
52.0
53.23
53.36
52.76
52.96
50.6
53.08
53.44
53.57
53.35
56.45
54.93
53.34
52.63
53.13
52.43
51.83
51.58
50.99
53.58
55.94
56.0
53.83
53.65
52.4
53.42
53.76
53.03
53.53
51.96
52.5
52.38
52.08
50.62
50.08
50.14
50.28
50.14
51.2
51.26
49.83
49.18
49.8
49.67
49.89
50.16
50.29
49.49
49.49
49.55
49.12
48.87
49.43
49.75
49.77
48.82
48.64
48.95
47.9
47.32
47.36
46.09
46.59
46.1
45.21
45.21
46.49
46.1
46.31
43.69
43.72
43.89
41.88
41.05
41.36
41.34
41.57
41.49
41.96
42.18
42.02
41.53
40.65
40.62
38.2
37.52
37.75
38.11
37.0
38.08
38.86
40.34
39.93
39.62
39.13
40.14
38.95
39.14
37.74
38.21
38.75
38.06
38.18
38.78
40.13
40.49
39.91
39.47
40.67
41.44
40.75
40.82
41.47
43.42
42.34
40.89
40.87
40.75
40.58
42.56
43.26
43.5
43.47
44.2
43.71
43.67
42.19
40.72
41.04
39.87
41.2
41.31
40.26
40.32
39.31
38.39
38.61
38.37
38.54
40.85
40.44
41.33
42.12
42.19
42.26
42.02
43.86
44.48
44.45
45.14
45.56
44.45
44.19
44.52
43.86
43.65
41.16
39.56
40.81
41.4
41.78
41.97
43.38
42.87
44.74
45.66
45.86
46.29
46.33
48.9
49.69
49.62
49.34
48.56
49.74
49.55
51.54
50.8
51.74
50.34
49.82
50.22
48.39
48.04
48.24
46.19
47.79
48.52
48.34
47.73
47.62
48.55
44.33
47.05
47.06
46.22
47.07
46.09
45.5
45.27
45.94
45.41
44.92
47.38
51.4
51.86
51.91
52.12
51.04
50.28
48.05
48.54
49.05
49.32
49.39
50.43
50.08
50.01
51.86
52.76
52.28
52.15
50.77
55.84
56.06
56.22
55.7
56.42
55.48
57.21
56.24
56.82
53.94
52.77
52.65
52.35
52.51
51.36
50.87
51.14
51.35
51.99
52.4
52.28
52.06
51.99
51.86
49.63
50.48
49.79
47.7
47.7
46.65
44.66
45.78
45.0
44.96
44.71
44.71
44.5
43.92
44.11
44.0
43.08
43.43
43.92
45.34
43.63
43.89
44.61
43.81
44.53
45.85
45.88
47.94
48.01
47.81
47.12
47.38
46.5
47.44
45.92
45.56
45.42
46.33
44.92
41.28
40.7
40.89
40.46
41.06
41.63
41.38
40.8
40.99
40.94
41.55
42.05
42.05
42.31
41.46
40.98
39.89
39.06
39.22
38.31
37.72
38.12
38.03
36.93
36.45
35.72
40.27
41.46
43.32
42.18
41.55
41.58
41.38
39.7
39.97
41.57
41.6
43.73
40.88
39.62
39.82
38.78
39.62
40.76
40.84
43.39
43.09
41.5
42.45
45.08
46.06
43.39
41.69
42.47
41.46
42.59
44.09
44.03
45.78
46.98
47.17
48.01
46.8
46.19
47.56
48.3
46.88
47.77
49.24
50.59
50.53
50.97
50.11
48.96
50.51
50.6
49.6
43.53
41.92
41.99
38.73
40.74
39.65
39.93
39.06
39.32
39.31
37.31
35.68
34.88
35.75
35.42
36.28
36.57
35.05
35.68
33.92
34.92
36.3
35.71
35.34
34.0
34.19
32.83
32.25
27.87
29.14
29.51
30.26
29.87
29.4
29.91
30.02
30.09
30.49
30.22
31.1
30.28
28.71
28.65
28.14
29.6
30.49
29.59
29.53
29.49
27.93
28.44
28.32
27.47
28.1
27.79
28.94
24.83
25.46
25.39
24.1
24.17
24.28
24.42
24.22
25.22
24.32
27.09
27.52
27.74
27.56
28.94
27.59
27.95
30.23
35.36
35.04
32.43
31.99
31.84
32.89
32.57
33.93
34.63
32.9
34.31
34.52
36.68
36.56
36.71
36.79
35.94
35.74
34.59
33.76
34.95
36.61
36.2
34.66
36.19
38.6
38.67
38.18
37.73
37.05
36.47
36.22
36.68
35.58
33.24
33.25
33.32
33.11
32.99
32.7
33.27
32.14
33.39
33.99
34.12
33.79
33.8
33.21
33.29
33.4
32.84
32.37
31.42
29.57
29.92
28.98
28.4
27.93
27.87
29.09
29.48
30.6
30.7
26.85
28.43
28.94
27.6
27.11
26.86
26.35
26.92
25.88
24.81
24.34
24.55
24.49
23.94
23.81
24.05
21.81
25.45
25.98
25.12
24.45
24.69
24.32
24.02
23.05
23.56
23.44
21.47
21.85
21.14
20.48
20.3
19.91
20.13
20.94
20.68
20.44
20.06
19.64
19.55
18.89
20.01
20.41
19.47
19.07
18.97
18.52
19.55
20.99
20.93
22.07
19.42
18.55
17.45
17.52
17.99
18.3
18.45
16.97
16.65
17.56
15.35
13.88
11.16
11.1
11.9
10.91
10.82
10.66
10.8
10.99
10.24
10.4
10.09
10.2
10.04
9.57
9.39
9.09
9.12
8.66
8.75
8.72
8.37
8.1
8.37
8.27
8.4
8.22
8.87
8.79
7.58
7.63
7.57
7.51
7.32
7.2
7.19
7.02
7.03
7.06
7.37
7.8
7.82
7.82
7.69
7.65
7.54
7.33
7.12
6.93
6.97
7.02
6.89
6.88
7.22
7.03
7.71
7.86
7.41
7.66
7.69
7.58
7.68
7.85
7.9
7.83
7.63
7.55
7.66
7.5
7.5
7.59
7.61
7.4
7.4
7.2
7.04
6.9
6.88
6.82
6.78
6.65
6.58
6.71
6.73
6.74
6.87
6.88
6.95
7.07
6.77
6.64
6.74
6.72
6.86
6.8
6.89
6.92
6.92
6.88
6.76
6.72
7.05
7.06
6.91
6.83
6.78
6.74
6.78
6.92
6.76
6.74
6.65
6.43
6.45
6.43
6.49
6.6
6.58
6.37
6.16
6.28
6.32
6.21
6.06
6.26
6.31
6.23
6.3
5.78
5.85
5.63
5.48
5.5
5.48
5.68
5.57
5.55
5.61
5.76
5.61
5.47
5.53
5.66
5.68
5.67
5.85
5.78
5.88
5.86
5.96
5.83
5.86
5.7
5.51
5.53
6.13
6.0
6.18
6.21
6.27
6.51
6.08
5.9
5.66
5.56
5.47
5.87
5.71
5.59
5.63
5.7
5.68
5.68
5.74
5.66
5.9
6.15
5.99
5.82
5.9
6.0
6.06
5.88
5.88
6.23
5.99
5.88
5.82
6.05
5.65
5.45
5.22
5.25
5.48
5.47
5.9
5.63
5.79
5.97
6.13
6.36
6.45
6.43
6.67
7.19
6.85
6.54
6.3
6.25
6.3
6.2
6.25
6.13
6.08
6.26
6.28
6.39
6.32
6.62
6.76
6.44
6.76
6.42
6.37
5.98
5.88
5.95
5.93
5.82
6.02
5.79
5.84
5.58
5.58
5.63
5.9
6.08
6.34
5.96
6.06
6.2
6.16
5.75
5.51
5.71
5.84
5.89
6.01
6.45
6.59
6.01
6.04
6.49
6.37
6.49
6.79
6.76
6.63
6.67
6.7
6.58
6.36
6.39
6.63
6.63
6.53
6.45

for row2 in data2['Price'].loc[1:]:
    print(row2)

运行结果1022.37
986.95
975.93
1025.49
1057.26
1045.76
1091.26
1145.45
1084.59
1077.6
1093.99
1099.57
1091.84
1010.64
1013.92
999.11
993.98
921.16
905.39
871.6
840.23
801.89
766.37
795.35
838.3
858.97
824.4
804.58
879.89
864.37
870.43
809.87
800.77
856.98
876.35
923.39
922.43
875.76
932.0
922.0
907.34
923.32
891.14
936.72
846.35
829.1
937.41
918.4
996.27
995.65
1030.51
1049.61
1031.56
1058.12
1026.96
1064.7
1088.12
1149.59
1070.34
1086.19
1088.47
1093.94
1067.0
899.94
932.57
926.92
975.99
958.51
1003.8
1068.96
1051.75
1009.01
1014.97
1144.76
1136.99
1081.92
1116.0
1109.03
1096.38
1089.01
1054.73
1013.39
1033.42
1023.5
1162.94
1222.09
1229.91
1213.86
1114.0
1077.04
1037.86
1018.43
1024.86
865.8
864.27
870.11
843.03
818.32
791.94
785.49
793.61
782.75
780.59
775.48
781.31
777.56
791.36
774.39
739.38
730.17
759.49
756.99
755.83
736.27
754.86
753.87
752.92
733.57
735.72
730.91
711.92
701.16
711.2
680.26
673.47
688.99
665.71
686.17
717.17
722.25
707.82
709.99
713.76
699.1
714.63
710.92
709.74
709.67
687.2
677.35
646.98
644.78
657.62
643.38
649.26
655.29
660.5
646.22
644.22
650.6
653.38
668.54
685.7
656.95
652.81
644.65
659.58
678.9
677.92
679.7
680.76
688.72
671.87
679.82
656.57
623.71
620.83
623.31
616.6
604.87
599.36
617.69
609.89
610.12
598.78
603.59
605.13
599.05
572.84
605.12
623.9
625.22
630.85
619.13
604.69
606.44
580.88
586.78
563.46
577.87
576.83
589.74
571.69
589.89
617.2
629.04
672.37
663.54
670.94
673.6
684.9
709.44
677.0
694.4
704.74
738.2
729.4
719.69
744.12
718.99
714.63
739.78
738.85
732.23
762.32
701.98
677.02
683.8
670.97
691.62
691.05
661.75
667.93
635.62
611.29
618.71
640.39
630.27
662.16
670.0
654.87
653.16
701.81
676.88
707.94
693.73
699.6
668.06
673.58
563.0
597.95
621.44
653.2
686.44
718.43
675.5
682.22
742.02
698.84
714.5
781.3
787.38
798.15
796.22
816.12
811.66
804.82
849.46
863.42
852.23
849.99
854.69
872.79
839.81
793.53
835.43
864.16
883.09
880.8
846.64
844.99
850.45
844.55
826.16
845.0
854.41
849.44
811.19
880.02
816.04
755.98
735.11
729.77
705.67
694.78
665.99
663.69
661.77
645.98
640.34
649.86
695.0
655.9
622.77
633.25
639.83
609.99
627.07
604.48
649.88
641.76
599.04
593.38
568.82
584.76
567.6
585.76
574.0
555.38
521.85
489.61
499.27
486.64
441.61
408.09
408.5
411.76
417.13
410.36
421.26
429.95
438.09
420.98
423.9
400.51
388.04
410.83
406.02
424.68
420.28
420.63
425.79
422.64
421.94
430.83
439.67
448.88
461.3
446.65
442.3
434.0
425.92
425.3
413.98
425.68
415.09
448.16
429.01
419.07
421.2
407.34
387.79
380.36
424.23
449.39
442.15
423.43
441.76
449.76
419.62
372.72
371.34
366.28
330.21
418.32
407.0
447.37
475.05
498.32
442.68
447.75
430.63
404.67
402.84
410.0
400.37
375.71
377.42
367.13
330.14
324.2
310.95
274.88
283.71
290.54
297.92
297.0
297.4
297.0
286.15
297.5
299.82
295.3
307.92
283.4
302.61
318.47
313.67
328.6
300.17
300.13
309.2
303.36
299.41
308.93
278.86
273.18
277.97
274.32
241.73
223.93
215.96
201.87
191.95
197.2
192.17
200.36
198.86
200.18
200.79
198.36
196.43
198.18
187.06
194.57
205.01
188.13
189.98
177.13
172.88
176.59
176.31
179.62
167.0
161.16
164.05
163.77
163.38
165.52
163.11
161.6
162.73
159.83
160.67
158.19
161.88
162.26
163.88
156.01
156.52
153.64
152.24
140.26
156.38
160.1
153.82
159.75
145.03
141.13
146.42
137.34
149.27
150.78
149.04
145.97
141.98
130.19
114.6
109.77
109.09
103.25
96.0
90.89
96.31
104.8
100.43
102.87
105.63
107.85
101.0
86.86
85.51
85.53
72.24
86.04
89.01
109.32
112.11
126.85
129.07
121.6
140.7
144.91
149.9
149.1
148.72
133.6
135.8
155.76
159.98
166.76
180.2
179.88
183.48
171.68
160.01
160.8
153.46
154.88
154.26
149.61
149.79
146.94
177.41
156.0
130.11
128.16
116.2
113.38
111.6
112.96
114.44
113.91
109.44
102.1
102.7
103.7
107.58
104.97
95.63
96.27
98.43
93.81
90.31
88.6
86.05
83.67
82.94
86.08
86.19
85.05
83.84
81.12
80.81
78.63
75.8
76.3
71.68
71.94
70.54
69.77
67.91
67.18
66.07
66.61
67.24
66.97
65.99
66.26
65.78
67.27
66.61
70.97
70.44
71.9
70.0
70.43
69.87
69.22
69.99
69.02
67.43
67.11
65.32
63.44
63.49
62.66
62.98
63.0
63.24
65.54
65.63
59.94
50.94
51.12
50.7
51.39
52.39
51.95
51.58
51.39
49.58
48.95
48.91
48.01
47.54
46.29
46.61
48.63
48.94
48.17
48.43
48.51
45.74
44.64
48.25
48.12
49.32
48.7
48.96
48.56
49.04
49.17
49.42
47.11
46.36
45.49
45.92
44.14
45.0
45.12
44.34
43.12
42.82
43.0
42.28
44.43
44.17
45.17
45.37
43.99
43.13
43.92
47.0
45.8
47.0
47.66
46.68
46.15
45.66
46.87
46.77
48.32
48.45
47.15
45.61
45.76
52.98
52.03
51.14
51.64
50.71
50.97
50.48
50.7
49.02
47.72
47.78
46.01
46.07
46.62
46.98
44.91
45.43
44.69
44.57
43.85
43.95
44.73
44.37
43.92
45.29
44.95
45.01
42.98
42.78
41.85
43.42
42.58
40.9
41.19
39.32
38.72
35.79
37.03
37.64
37.97
37.74
38.13
39.1
38.55
41.02
41.07
42.21
45.67
46.39
46.46
45.4
47.9
48.4
48.97
49.41
51.07
51.01
48.82
46.8
47.74
48.29
47.03
49.53
51.73
52.78
52.55
54.65
54.25
54.67
53.28
53.54
53.68
55.21
54.46
54.64
54.99
53.56
58.36
57.18
57.84
55.97
55.72
54.97
53.55
52.08
52.91
54.8
54.72
53.49
53.9
55.09
57.99
57.79
56.67
58.18
56.83
55.32
55.25
55.31
57.07
58.96
63.98
62.95
59.57
59.75
58.94
58.25
60.51
61.13
61.58
60.75
61.63
62.36
62.57
61.16
61.5
63.44
64.27
62.58
62.44
61.4
61.75
59.49
59.28
59.41
58.3
57.52
59.78
60.45
69.46
69.21
68.89
66.88
69.45
68.99
67.71
67.07
66.99
63.54
60.07
62.02
66.56
66.77
63.23
65.22
59.08
63.95
63.08
66.59
67.41
69.68
73.14
75.36
73.32
73.35
73.03
71.59
72.61
71.94
71.7
70.1
68.23
69.57
68.78
69.2
65.17
67.64
69.5
70.69
70.86
69.69
68.8
67.75
66.26
70.1
70.28
69.63
68.21
68.28
69.28
68.86
67.46
65.98
66.97
66.18
62.97
57.7
58.83
52.19
52.0
52.78
54.36
55.32
51.92
51.76
50.45
51.38
52.56
50.11
52.39
56.37
58.96
60.2
62.14
52.95
61.5
61.92
60.2
59.94
59.82
59.67
59.8
56.99
58.97
59.04
57.89
58.11
55.89
57.1
52.65
56.19
56.15
57.79
60.33
60.63
61.0
62.37
63.85
64.56
64.02
64.33
64.38
61.69
61.1
67.09
67.74
69.53
71.28
71.1
70.49
74.07
75.91
68.4
69.63
69.91
60.17
59.63
58.03
59.44
61.33
61.75
59.49
60.64
62.72
64.05
64.77
64.54
62.02
63.77
63.34
63.79
64.49
63.7
61.78
61.83
62.17
67.01
68.59
69.99
68.9
68.4
66.6
66.73
69.5
72.44
70.51
74.17
71.63
71.54
68.96
68.55
66.42
63.53
63.22
63.9
58.23
59.35
58.36
56.95
58.34
56.75
55.77
55.57
55.81
55.0
56.9
55.36
56.91
57.3
56.84
58.39
60.21
61.0
61.37
60.39
60.55
58.82
56.89
60.23
59.98
58.78
58.81
57.1
56.14
56.69
56.67
58.05
60.02
58.67
57.54
58.24
60.07
58.82
60.19
60.94
57.93
59.86
61.14
57.39
53.51
50.5
53.23
51.56
55.84
60.84
60.31
61.82
63.31
62.11
62.71
64.27
65.12
65.33
68.37
69.1
65.43
65.82
66.46
65.64
66.67
67.02
66.19
68.61
70.2
71.48
70.41
69.23
66.66
66.95
67.1
66.81
64.46
64.73
63.15
62.08
63.05
69.0
66.79
66.63
68.75
69.85
70.86
69.16
69.91
68.57
67.53
69.18
70.56
70.31
70.0
68.91
69.43
68.01
67.24
67.59
66.96
66.74
67.28
63.32
62.92
63.45
64.11
62.27
63.07
62.33
63.46
65.04
66.33
65.8
66.22
67.77
68.69
67.58
67.81
68.21
65.78
63.03
62.25
62.65
60.74
61.04
61.31
61.77
61.51
63.51
63.36
63.11
62.52
63.56
61.75
63.01
62.5
62.26
61.74
63.08
60.6
60.6
60.88
61.21
60.56
61.22
59.85
64.22
66.31
64.02
64.17
65.23
65.17
67.47
67.4
69.02
70.36
71.93
71.15
70.12
71.11
71.14
70.92
71.12
68.59
71.38
71.07
71.0
69.63
68.31
68.22
67.92
68.19
69.05
69.0
70.22
73.3
74.78
75.02
77.0
75.96
75.53
73.25
72.55
72.74
68.68
70.12
68.91
69.92
71.08
71.18
70.64
69.47
69.13
69.61
70.59
70.55
68.27
67.57
69.49
70.38
72.58
72.47
72.76
71.57
71.08
72.71
73.04
71.03
71.38
69.42
65.18
63.91
64.69
67.01
66.89
68.77
67.92
68.5
65.68
65.98
65.05
65.65
63.91
65.56
64.68
65.9
65.44
63.21
62.64
61.77
65.42
70.52
72.32
72.15
74.25
72.47
75.5
76.69
76.52
75.28
74.45
73.96
74.28
75.07
76.13
75.19
71.8
71.46
74.0
71.93
70.57
69.46
67.97
68.07
68.2
67.02
65.03
63.37
62.04
60.77
62.07
62.17
62.61
61.22
63.4
63.18
64.96
64.62
65.04
64.25
61.44
61.67
59.09
62.2
63.78
64.57
62.81
61.73
62.03
62.76
61.61
61.12
60.5
61.1
60.05
60.29
60.8
59.37
61.74
62.48
60.51
59.74
59.0
60.74
59.7
55.66
55.58
55.48
55.49
54.04
52.63
50.96
51.0
50.14
52.38
52.3
52.41
51.15
51.6
49.23
48.74
48.98
49.37
49.72
50.24
50.31
50.1
50.0
50.0
49.25
51.4
51.2
54.7
55.48
54.45
53.79
55.95
56.2
56.12
53.85
53.84
52.42
51.5
51.55
50.27
50.31
49.85
50.39
50.13
50.59
50.5
50.89
50.92
49.78
48.95
48.75
47.67
47.12
47.55
45.92
45.95
45.97
46.26
45.8
45.35
45.4
43.4
42.74
42.94
43.95
43.91
42.67
41.69
41.54
41.76
40.55
40.5
39.52
39.74
39.63
38.49
38.44
38.46
38.63
37.17
37.36
36.29
36.38
37.88
37.91
39.22
39.33
38.63
38.23
36.9
37.0
37.73
36.79
36.75
36.29
37.71
37.07
38.01
38.99
38.64
38.11
37.48
37.6
38.16
39.55
39.99
40.8
40.45
40.47
40.55
40.02
39.82
40.71
39.82
38.79
39.3
40.05
40.3
40.02
40.19
39.32
40.2
41.69
42.28
42.74
40.81
40.14
41.25
41.16
41.8
41.49
41.29
41.04
40.93
41.27
41.08
40.08
39.28
39.21
39.66
38.89
39.47
40.34
40.57
39.56
40.15
42.4
42.27
43.04
44.0
44.19
44.52
44.97
44.59
45.0
44.7
44.65
44.72
45.12
45.12
44.98
45.13
45.82
45.23
46.01
46.12
45.16
45.44
46.0
46.96
46.12
45.7
45.9
46.0
44.45
44.1
45.67
45.05
45.25
44.08
44.31
44.51
44.93
44.96
43.36
43.19
42.89
42.8
43.3
42.46
42.04
40.36
39.71
38.63
39.28
39.33
43.92
43.94
43.09
43.59
43.54
42.99
43.57
43.76
45.87
47.1
46.47
44.14
43.8
43.79
43.91
44.65
44.61
45.02
43.92
43.58
43.24
44.06
43.04
42.23
40.93
41.66
41.52
41.46
41.79
41.74
41.78
42.99
42.31
44.51
46.46
48.36
48.15
49.54
50.29
50.75
50.36
50.75
49.66
49.99
49.47
50.78
50.9
50.37
50.91
49.56
49.98
50.01
51.44
53.08
51.09
49.4
47.52
45.95
45.38
46.03
46.05
45.55
44.52
46.85
47.66
46.55
45.28
44.39
43.67
43.03
41.5
41.04
41.74
40.52
41.06
40.21
39.15
37.67
37.27
38.39
190.35
38.07
37.49
35.8
35.44
35.55
33.32
33.35
33.74
31.03
30.21
30.09
28.73
29.65
29.6
32.52
35.07
34.7
36.56
39.39
38.24
37.94
37.61
38.71
39.28
40.51
39.99
39.74
40.94
41.0
41.24
40.06
41.99
41.57
42.2
43.13
43.81
44.69
44.68
48.0
47.62
47.44
45.79
46.11
45.94
45.99
46.51
46.09
46.68
46.9
44.22
43.72
43.4
45.41
44.9
45.34
46.23
46.08
46.54
46.4
47.44
46.05
46.32
45.93
43.65
43.55
44.0
44.36
44.21
42.8
42.86
41.44
42.59
43.82
43.3
45.07
46.47
46.35
46.33
41.67
42.76
41.39
42.33
42.59
42.07
43.05
41.82
42.34
42.02
42.61
45.62
45.4
44.26
43.38
43.85
43.12
44.14
45.34
46.39
48.29
49.23
49.51
47.98
49.68
49.33
49.69
51.38
52.62
52.21
52.19
52.84
52.12
52.41
52.45
50.71
50.64
50.05
49.7
49.78
49.63
48.39
49.11
49.54
47.73
49.81
49.7
48.6
44.97
44.01
43.77
46.15
48.44
51.05
52.14
51.0
48.63
48.5
47.63
47.47
48.23
48.5
49.23
54.03
53.26
52.0
53.23
53.36
52.76
52.96
50.6
53.08
53.44
53.57
53.35
56.45
54.93
53.34
52.63
53.13
52.43
51.83
51.58
50.99
53.58
55.94
56.0
53.83
53.65
52.4
53.42
53.76
53.03
53.53
51.96
52.5
52.38
52.08
50.62
50.08
50.14
50.28
50.14
51.2
51.26
49.83
49.18
49.8
49.67
49.89
50.16
50.29
49.49
49.49
49.55
49.12
48.87
49.43
49.75
49.77
48.82
48.64
48.95
47.9
47.32
47.36
46.09
46.59
46.1
45.21
45.21
46.49
46.1
46.31
43.69
43.72
43.89
41.88
41.05
41.36
41.34
41.57
41.49
41.96
42.18
42.02
41.53
40.65
40.62
38.2
37.52
37.75
38.11
37.0
38.08
38.86
40.34
39.93
39.62
39.13
40.14
38.95
39.14
37.74
38.21
38.75
38.06
38.18
38.78
40.13
40.49
39.91
39.47
40.67
41.44
40.75
40.82
41.47
43.42
42.34
40.89
40.87
40.75
40.58
42.56
43.26
43.5
43.47
44.2
43.71
43.67
42.19
40.72
41.04
39.87
41.2
41.31
40.26
40.32
39.31
38.39
38.61
38.37
38.54
40.85
40.44
41.33
42.12
42.19
42.26
42.02
43.86
44.48
44.45
45.14
45.56
44.45
44.19
44.52
43.86
43.65
41.16
39.56
40.81
41.4
41.78
41.97
43.38
42.87
44.74
45.66
45.86
46.29
46.33
48.9
49.69
49.62
49.34
48.56
49.74
49.55
51.54
50.8
51.74
50.34
49.82
50.22
48.39
48.04
48.24
46.19
47.79
48.52
48.34
47.73
47.62
48.55
44.33
47.05
47.06
46.22
47.07
46.09
45.5
45.27
45.94
45.41
44.92
47.38
51.4
51.86
51.91
52.12
51.04
50.28
48.05
48.54
49.05
49.32
49.39
50.43
50.08
50.01
51.86
52.76
52.28
52.15
50.77
55.84
56.06
56.22
55.7
56.42
55.48
57.21
56.24
56.82
53.94
52.77
52.65
52.35
52.51
51.36
50.87
51.14
51.35
51.99
52.4
52.28
52.06
51.99
51.86
49.63
50.48
49.79
47.7
47.7
46.65
44.66
45.78
45.0
44.96
44.71
44.71
44.5
43.92
44.11
44.0
43.08
43.43
43.92
45.34
43.63
43.89
44.61
43.81
44.53
45.85
45.88
47.94
48.01
47.81
47.12
47.38
46.5
47.44
45.92
45.56
45.42
46.33
44.92
41.28
40.7
40.89
40.46
41.06
41.63
41.38
40.8
40.99
40.94
41.55
42.05
42.05
42.31
41.46
40.98
39.89
39.06
39.22
38.31
37.72
38.12
38.03
36.93
36.45
35.72
40.27
41.46
43.32
42.18
41.55
41.58
41.38
39.7
39.97
41.57
41.6
43.73
40.88
39.62
39.82
38.78
39.62
40.76
40.84
43.39
43.09
41.5
42.45
45.08
46.06
43.39
41.69
42.47
41.46
42.59
44.09
44.03
45.78
46.98
47.17
48.01
46.8
46.19
47.56
48.3
46.88
47.77
49.24
50.59
50.53
50.97
50.11
48.96
50.51
50.6
49.6
43.53
41.92
41.99
38.73
40.74
39.65
39.93
39.06
39.32
39.31
37.31
35.68
34.88
35.75
35.42
36.28
36.57
35.05
35.68
33.92
34.92
36.3
35.71
35.34
34.0
34.19
32.83
32.25
27.87
29.14
29.51
30.26
29.87
29.4
29.91
30.02
30.09
30.49
30.22
31.1
30.28
28.71
28.65
28.14
29.6
30.49
29.59
29.53
29.49
27.93
28.44
28.32
27.47
28.1
27.79
28.94
24.83
25.46
25.39
24.1
24.17
24.28
24.42
24.22
25.22
24.32
27.09
27.52
27.74
27.56
28.94
27.59
27.95
30.23
35.36
35.04
32.43
31.99
31.84
32.89
32.57
33.93
34.63
32.9
34.31
34.52
36.68
36.56
36.71
36.79
35.94
35.74
34.59
33.76
34.95
36.61
36.2
34.66
36.19
38.6
38.67
38.18
37.73
37.05
36.47
36.22
36.68
35.58
33.24
33.25
33.32
33.11
32.99
32.7
33.27
32.14
33.39
33.99
34.12
33.79
33.8
33.21
33.29
33.4
32.84
32.37
31.42
29.57
29.92
28.98
28.4
27.93
27.87
29.09
29.48
30.6
30.7
26.85
28.43
28.94
27.6
27.11
26.86
26.35
26.92
25.88
24.81
24.34
24.55
24.49
23.94
23.81
24.05
21.81
25.45
25.98
25.12
24.45
24.69
24.32
24.02
23.05
23.56
23.44
21.47
21.85
21.14
20.48
20.3
19.91
20.13
20.94
20.68
20.44
20.06
19.64
19.55
18.89
20.01
20.41
19.47
19.07
18.97
18.52
19.55
20.99
20.93
22.07
19.42
18.55
17.45
17.52
17.99
18.3
18.45
16.97
16.65
17.56
15.35
13.88
11.16
11.1
11.9
10.91
10.82
10.66
10.8
10.99
10.24
10.4
10.09
10.2
10.04
9.57
9.39
9.09
9.12
8.66
8.75
8.72
8.37
8.1
8.37
8.27
8.4
8.22
8.87
8.79
7.58
7.63
7.57
7.51
7.32
7.2
7.19
7.02
7.03
7.06
7.37
7.8
7.82
7.82
7.69
7.65
7.54
7.33
7.12
6.93
6.97
7.02
6.89
6.88
7.22
7.03
7.71
7.86
7.41
7.66
7.69
7.58
7.68
7.85
7.9
7.83
7.63
7.55
7.66
7.5
7.5
7.59
7.61
7.4
7.4
7.2
7.04
6.9
6.88
6.82
6.78
6.65
6.58
6.71
6.73
6.74
6.87
6.88
6.95
7.07
6.77
6.64
6.74
6.72
6.86
6.8
6.89
6.92
6.92
6.88
6.76
6.72
7.05
7.06
6.91
6.83
6.78
6.74
6.78
6.92
6.76
6.74
6.65
6.43
6.45
6.43
6.49
6.6
6.58
6.37
6.16
6.28
6.32
6.21
6.06
6.26
6.31
6.23
6.3
5.78
5.85
5.63
5.48
5.5
5.48
5.68
5.57
5.55
5.61
5.76
5.61
5.47
5.53
5.66
5.68
5.67
5.85
5.78
5.88
5.86
5.96
5.83
5.86
5.7
5.51
5.53
6.13
6.0
6.18
6.21
6.27
6.51
6.08
5.9
5.66
5.56
5.47
5.87
5.71
5.59
5.63
5.7
5.68
5.68
5.74
5.66
5.9
6.15
5.99
5.82
5.9
6.0
6.06
5.88
5.88
6.23
5.99
5.88
5.82
6.05
5.65
5.45
5.22
5.25
5.48
5.47
5.9
5.63
5.79
5.97
6.13
6.36
6.45
6.43
6.67
7.19
6.85
6.54
6.3
6.25
6.3
6.2
6.25
6.13
6.08
6.26
6.28
6.39
6.32
6.62
6.76
6.44
6.76
6.42
6.37
5.98
5.88
5.95
5.93
5.82
6.02
5.79
5.84
5.58
5.58
5.63
5.9
6.08
6.34
5.96
6.06
6.2
6.16
5.75
5.51
5.71
5.84
5.89
6.01
6.45
6.59
6.01
6.04
6.49
6.37
6.49
6.79
6.76
6.63
6.67
6.7
6.58
6.36
6.39
6.63
6.63
6.53
6.45

ret = 0
for i in range(len(data2['Price'])-1):
    #print(data2['Price'].iloc[i],'\t',data2['Price'].iloc[i+1])
    d1 = data2['Price'].iloc[i]
    d2 = data2['Price'].iloc[i+1]
    #print((d1-d2)/d2*100)
    if(((d1-d2)/d2*100)>=10):
        ret = ret+1
print(ret)

38

ret = 0
for i in range(len(data2['Price'])-1):
    #print(data2['Price'].iloc[i],'\t',data2['Price'].iloc[i+1])
    d1 = data2['Price'].iloc[i]
    d2 = data2['Price'].iloc[i+1]
    #print((d1-d2)/d2*100)
    if(((d1-d2)/d2*100)<=-10):
        ret = ret+1
print(ret)

21

diff = data2['High'] - data2['Low']
data2['diff'] = diff
print(data2)

运行结果 Date Price Open High Low diff
0 2022/4/14 985.00 999.29 1012.71 982.19 30.52
1 2022/4/13 1022.37 981.08 1026.24 973.10 53.14
2 2022/4/12 986.95 997.64 1021.19 976.60 44.59
3 2022/4/11 975.93 980.40 1008.47 974.64 33.83
6 2022/4/8 1025.49 1043.21 1048.44 1022.43 26.01
… … … … … … …
2525 2012/4/23 6.39 6.57 6.59 6.34 0.25
2526 2012/4/20 6.63 6.63 6.75 6.59 0.16
2527 2012/4/19 6.63 6.55 6.69 6.50 0.19
2528 2012/4/18 6.53 6.42 6.55 6.31 0.24
2535 2012/4/17 6.45 6.49 6.61 6.41 0.20

[2478 rows x 6 columns]

C:\Users\zhu\AppData\Local\Temp\ipykernel_13496\4163829141.py:2: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
data2[‘diff’] = diff

将数据重新写入一个csv表

data2.to_csv('data3.csv',index=True)

data3.csv