| 0,0 → 1,80 |
|---|
| #!/usr/bin/python |
| |
| import pandas as pd |
| import os |
| import time |
| import datetime |
| |
| |
| |
| dataSource = "/home/odroid/geozor/station/testingData/" |
| dataArchive = "/home/odroid/geozor/station/testingData/archive/" |
| loop = 1 |
| |
| |
| while True: |
| try: |
| print("Start") |
| ## Create sorted list of csv files |
| listOfDataFiles = list() #empty list |
| listOfSpecDataFiles = list() #empty list |
| files = list() #empty list |
| falg = False # is computation needed |
| |
| files = sorted(os.listdir(dataSource)) # list of all files and folders in directory |
| for idx, val in enumerate(files): #goes through files |
| if val.endswith("data.csv"): # in case of *data.csv |
| listOfDataFiles.append(val) #add file to listOfFiles |
| |
| ## Find the newest and oldest and compare them. If they are from different day, compute the average of all measurement from oldest day |
| if len(listOfDataFiles)>=2: # if there are more than 2 data files |
| first = listOfDataFiles[0] # get first of them |
| last = listOfDataFiles[-1] # get last of them |
| |
| if time.mktime(datetime.datetime.strptime(last[:8], "%Y%m%d").timetuple()) > time.mktime(datetime.datetime.strptime(first[:8], "%Y%m%d").timetuple()): # if the last is older than first |
| flag = True # computation needed |
| print("Computing...") |
| print(loop) |
| loop +=1 |
| listOfSpecDataFiles = list() # empty list |
| |
| for file in listOfDataFiles: # go through data files and create lis of data files measured on same day |
| # if the day is same like the first one |
| if time.mktime(datetime.datetime.strptime(first[:8], "%Y%m%d").timetuple()) == time.mktime(datetime.datetime.strptime(file[:8], "%Y%m%d").timetuple()): |
| listOfSpecDataFiles.append(file) |
| |
| for file in listOfSpecDataFiles: |
| df=pd.read_csv(file, sep=';', header=None) # read current csv |
| dim=df.shape # gets data file dimensions |
| rowsInd=dim[0] # maximal index of rows |
| columnsInd=dim[1] # maximal index of columns |
| values=pd.DataFrame() # empty DataFrame |
| |
| for x in range(0,columnsInd): # for each column |
| values = values.set_value(0,x,round(df[x].mean(),3),0) #calculates mean value for all cloumns and round it by 3 |
| |
| filename = first[:8]+'000000_VRTY-S1_data_mean.csv' |
| outfile = open(filename, 'a') |
| values.to_csv(filename, sep=';', header=None, index=False, mode='a') # save (add) DataFrame to csv |
| outfile.close() |
| |
| # move files to archive structure |
| for file in listOfSpecDataFiles: |
| year = file[:4] |
| month = file[4:6] |
| day = file[6:8] |
| directory = dataArchive + year + "/" + month + "/" + day + "/" |
| if not os.path.exists(directory): |
| os.makedirs(directory) |
| os.rename(dataSource + file, dataArchive + year + "/" + month + "/" + day + "/" + file) # move file |
| |
| else: |
| flag = False # computation is not needed |
| else: |
| flag = False # computation is not needed |
| |
| if flag == False: |
| time.sleep(10) #long sleep, because is nothing to process |
| |
| except ValueError: |
| print ValueError |