https://ithelp.ithome.com.tw/questions/10199175
這次的問題是上一篇的延伸

在那之後我有把完整程式碼補完整

import pandas as pd
import numpy as np

df = pd.read_excel('C:\\Users\\user\\20200102.xlsx', header=0, index_col=None)  
df = pd.DataFrame(df)

A = np.array(df[:300]['Date'])
B = np.array(df[:300]['Time'])
C = np.array(df[:300]['Open'])
D = np.array(df[:300]['High'])
E = np.array(df[:300]['Low'])
F = np.array(df[:300]['Close'])
G = np.array(df[:300]['Volume'])

H1,H2= [] ,[]

for i in range(0, 300) :
      for x in range(i , 300) :
            if df.at[x, 'High'] - df.at[i, 'Open'] >=20 :
                    H1.append(B[x])
                    H2.append(20)               
                    break
         
            elif df.at[i, 'Open'] - df.at[x, 'Low'] >=20 :
                    H1.append(B[x])
                    H2.append(-20)
                    break

data_dist = { 
    "Date":A,
    "Time":B,
    "Open":C, 
    "High":D, "Low":E,"Close":F,"Volume":G,
"損益時間20 20":H1,"損益20 20":H2}

data_df = pd.DataFrame.from_dict(data_dist, orient='index')
                 
data_df1 = data_df.T

print(data_df1)

#data_df1.to_csv('20200102+-全.csv', encoding='utf_8_sig') 

這次的問題是我想直接統計一年
但結果怪怪的
我想要的是今天統計完
統計隔天的
今天和隔天彼此不相關
也就是執行把上面程式碼執行好幾次
但我迴圈執行出來的東西跟我想要的不一樣

第一天後半部接近13:45分後
第二天之後結果都是錯的
https://imgur.com/rrkHadf

H1.append(B[x])
H2.append(20)

這部分寫入問題
不知道怎麼寫到正確的地方的地方

我自己再努力想想

EXCEL檔案
https://drive.google.com/file/d/1wWD5_bZuSfb23uqCcJoKSKB54uk39TcC/view?usp=sharing

import pandas as pd
import numpy as np

df = pd.read_excel('E:\\future\\2018.xlsx', header=0, index_col=None)  
df = pd.DataFrame(df)

A = np.array(df[:70500]['Date'])
B = np.array(df[:70500]['Time'])
C = np.array(df[:70500]['Open'])
D = np.array(df[:70500]['High'])
E = np.array(df[:70500]['Low'])
F = np.array(df[:70500]['Close'])
G = np.array(df[:70500]['Volume'])

H1,H2= [] ,[]

for d in range (0,235):
    for i in range(0+d*300, 300+d*300) :
        for x in range(i , 300+d*300 ) :
            if df.at[x, 'High'] - df.at[i, 'Open'] >=20 :
                    H1.append(B[x])
                    H2.append(20)               
                    break
         
            elif df.at[i, 'Open'] - df.at[x, 'Low'] >=20 :
                    H1.append(B[x])
                    H2.append(-20)
                    break


data_dist = { 
    "Date":A,
    "Time":B,
    "Open":C, 
    "High":D, "Low":E,"Close":F,"Volume":G,
"損益時間20 20":H1,"損益20 20":H2}

data_df = pd.DataFrame.from_dict(data_dist, orient='index')
                 
data_df1 = data_df.T

print(data_df1)

#data_df1.to_csv('2018+-全.csv', encoding='utf_8_sig') 

程式碼為下方
自己搞錯重點很抱歉

import pandas as pd
import numpy as np

df = pd.read_excel('E:\\future\\2018.xlsx', header=0, index_col=None)  
df = pd.DataFrame(df)

A = np.array(df[:70500]['Date'])
B = np.array(df[:70500]['Time'])
C = np.array(df[:70500]['Open'])
D = np.array(df[:70500]['High'])
E = np.array(df[:70500]['Low'])
F = np.array(df[:70500]['Close'])
G = np.array(df[:70500]['Volume'])

H1,H2= [] ,[]
data_dist = { 
    "Date":A,
    "Time":B,
    "Open":C, 
    "High":D, "Low":E,"Close":F,"Volume":G,
"損益時間20 20":H1,"損益20 20":H2}

data_df = pd.DataFrame.from_dict(data_dist, orient='index')
                 
data_df1 = data_df.T
print(data_df1)

rowmax = 300
for d in range(0,235):
    for i in range(0+d*300, 300+d*300):
        for x in range(i , 300+d*300 ):
            if data_df1.at[x, 'High'] - data_df1.at[i, 'Open'] >=20 :
                    data_df1.at[i, '損益時間20 20'] = B[x]
                    data_df1.at[i,'損益20 20']  =  20            
                    break
         
            elif data_df1.at[i, 'Open'] - data_df1.at[x, 'Low'] >=20 :
                    data_df1.at[i, '損益時間20 20'] = B[x]
                    data_df1.at[i,'損益20 20']  =  -20    
                    break
print(data_df1)
data_df1.to_csv('2018+-全12.csv', encoding='utf_8_sig')