import pandas as pd
file_name = input("file_name = ") ### mutqagreq excel file orinak name.xlsx
df = pd.read_excel(file_name)
#print (df['Date/Time'])
name_columns = df.columns
time =[]
for t in df['Date/Time']:
	#print (t)
	time.append(str(t))
#print(time)
c = int(input('input columns  = ')) #### mutqagreq sunyaki hamar orinak 1 
#print (c)
#print(name_columns[0])
########################################
#time = df[name_columns[0]].values.tolist()
count = df[name_columns[c]].values.tolist()
#print(time)    
################################### ASNT hamar count rate 2 sec poxum e 1 min, qayl@ 30 e 
def fdate(x,y,z):
    S,T,C = [],[],[]
    for i in range(0,len(y),x):
        #print(y[i:i+x])
        l = y[i:i+x]
        if len(l)==x:
            S.append(sum(y[i:i+x]))
            T.append(z[i])
    C.append(T)
    C.append(S)
    return C
c_min = fdate(30,count,time) 
#print(c_min)

datan = {name_columns[0]:c_min[0], name_columns[c]:c_min[1]} 
#print (datan)
df1 = pd.DataFrame(datan) 
#print(df1)
#df1.to_csv('out.csv',index =False)
df1.to_excel(str(c)+'_out.xlsx',index =False)   #### sarqum e nor 1 min qaylov file , file anun@ linum e syunaki hamar@ + Out.xlsx