def Launcher(): data = pd.read_excel("C:/Users/utente/Documents/PUN/Anno 2010.xlsx", sheetname=1) data2 = pd.read_excel("C:/Users/utente/Documents/PUN/Anno 2011.xlsx", sheetname=0) data3 = pd.read_excel("C:/Users/utente/Documents/PUN/Anno 2012.xlsx", sheetname=0) data4 = pd.read_excel("C:/Users/utente/Documents/PUN/Anno 2013.xlsx", sheetname=0) data5 = pd.read_excel("C:/Users/utente/Documents/PUN/Anno 2014.xlsx", sheetname=0) data6 = pd.read_excel("C:/Users/utente/Documents/PUN/Anno 2015.xlsx", sheetname=0) meteo = pd.read_table("C:/Users/utente/Documents/PUN/storico_roma.txt", sep="\t") # varn = "PUN" # pun1 = np.concatenate([np.array(data[varn]), np.array(data2[varn]), # np.array(data3[varn]), # np.array(data4[varn]), np.array(data5[varn]), # np.array(data6[varn])]) cols = set(data.columns).intersection(set(data2.columns)) cols = set(cols).intersection(set(data3.columns)) cols = set(cols).intersection(set(data4.columns)) cols = set(cols).intersection(set(data5.columns)) cols = set(cols).intersection(set(data6.columns)) cols = list(cols) hour = cols.index("Ora\nHour") dt = cols.index(" Data/Date\n(YYYYMMDD)") ncol = [] ncol.append(cols[dt]) ncol.append(cols[hour]) ncol2 = [el for i, el in enumerate(cols) if i not in ncol] data = data.append(data2[ncol2], ignore_index=True) data = data.append(data3[ncol2], ignore_index=True) data = data.append(data4[ncol2], ignore_index=True) data = data.append(data5[ncol2], ignore_index=True) data = data.append(data6[ncol2], ignore_index=True) start = time.time() test, y = rolling.create_rolling_dataset(data, "ven", "CSUD", meteo, 1, 0, 24) end = time.time() print end - start return test, y
def Launcher(): data = pd.read_excel("C:/Users/utente/Documents/PUN/Anno 2010.xlsx", sheetname=1) data2 = pd.read_excel("C:/Users/utente/Documents/PUN/Anno 2011.xlsx", sheetname=0) data3 = pd.read_excel("C:/Users/utente/Documents/PUN/Anno 2012.xlsx", sheetname=0) data4 = pd.read_excel("C:/Users/utente/Documents/PUN/Anno 2013.xlsx", sheetname=0) data5 = pd.read_excel("C:/Users/utente/Documents/PUN/Anno 2014.xlsx", sheetname=0) data6 = pd.read_excel("C:/Users/utente/Documents/PUN/Anno 2015.xlsx", sheetname=0) meteo = pd.read_table("C:/Users/utente/Documents/PUN/storico_roma.txt", sep="\t") # varn = "PUN" # pun1 = np.concatenate([np.array(data[varn]), np.array(data2[varn]), # np.array(data3[varn]), # np.array(data4[varn]), np.array(data5[varn]), # np.array(data6[varn])]) cols = set(data.columns).intersection(set(data2.columns)) cols = set(cols).intersection(set(data3.columns)) cols = set(cols).intersection(set(data4.columns)) cols = set(cols).intersection(set(data5.columns)) cols = set(cols).intersection(set(data6.columns)) cols = list(cols) hour = cols.index('Ora\nHour') dt = cols.index(' Data/Date\n(YYYYMMDD)') ncol = [] ncol.append(cols[dt]) ncol.append(cols[hour]) ncol2 = [el for i,el in enumerate(cols) if i not in ncol] data = data.append(data2[ncol2], ignore_index=True) data = data.append(data3[ncol2], ignore_index=True) data = data.append(data4[ncol2], ignore_index=True) data = data.append(data5[ncol2], ignore_index=True) data = data.append(data6[ncol2], ignore_index=True) start = time.time() test, y = rolling.create_rolling_dataset(data,"ven", "CSUD",meteo,1,0,24) end = time.time() print end-start return test, y
# -*- coding: utf-8 -*- """ Created on Tue Aug 23 10:52:30 2016 @author: utente Generation of all ROLLING datasets """ import pandas as pd import numpy as np import time import sys, os sys.path.append('C:/Users/utente/Python Scripts') import rolling data = pd.read_excel("C:/Users/utente/Documents/PUN/Anno 2011.xlsx") meteo = pd.read_table("C:/Users/utente/Documents/PUN/storico_roma.txt", sep="\t") start = time.time() test, y = rolling.create_rolling_dataset(data,"sab", "CSUD",meteo,1,0,24) end = time.time() print end-start
# -*- coding: utf-8 -*- """ Created on Tue Aug 23 10:52:30 2016 @author: utente Generation of all ROLLING datasets """ import pandas as pd import numpy as np import time import sys, os sys.path.append('C:/Users/utente/Python Scripts') import rolling data = pd.read_excel("C:/Users/utente/Documents/PUN/Anno 2011.xlsx") meteo = pd.read_table("C:/Users/utente/Documents/PUN/storico_roma.txt", sep="\t") start = time.time() test, y = rolling.create_rolling_dataset(data, "sab", "CSUD", meteo, 1, 0, 24) end = time.time() print end - start