import pandas as pd
df = pd.read_csv("asnt.csv")
print (df)
name_columns = df.columns
#print(name_columns[0])
########################################
time = df[name_columns[0]].values.tolist()
count = df[name_columns[1]].values.tolist()
#print(len(time))    
###################################
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[1]:c_min[1]} 
print (datan)
df1 = pd.DataFrame(datan) 
#print(df1)
#df1.to_csv('out.csv',index =False)
df1.to_excel('out.xlsx',index =False)