Fagaalu_stage_data = Fagaalu_stage_data.reindex(pd.date_range(start2012,stop2014,freq='15Min'))
#### Import T and SSC Data
from load_from_MASTER_XL import TS3000,YSI,OBS,loadTSS
## Turbidimeter Data DAM
DAM_TS3K = TS3000(XL,'DAM-TS3K')
DAM_YSI = YSI(XL,'DAM-YSI')
## Turbidimeter Data LBJ
LBJ_YSI = YSI(XL,'LBJ-YSI')
LBJ_OBSa = OBS(XL,'LBJ-OBSa').truncate(after=dt.datetime(2013,4,1))
LBJ_OBSb = OBS(XL,'LBJ-OBSb')
LBJ_OBSa=LBJ_OBSa.rename(columns={'Turb_SS_Avg':'NTU'})
LBJ_OBSb=LBJ_OBSb.rename(columns={'Turb_SS_Mean':'NTU'})
LBJ_OBS=LBJ_OBSa.append(LBJ_OBSb)
## TSS Data, equivalent to SSC but I don't want to change all the code and file names
TSSXL = pd.ExcelFile(datadir+'SSC/TSS_grab_samples.xlsx')
TSS = loadTSS(TSSXL,'ALL_MASTER')
TSS= TSS[TSS['TSS (mg/L)']>0]
#### Import NUTRIENT Data
from load_from_MASTER_XL import loadNUTES1,loadNUTES2and3
##NUTRIENTS1 (first field season)
NUTESXL = pd.ExcelFile(datadir+'NUTRIENTS/NUTRIENTS1.xlsx')
NUTES1 = loadNUTES1(NUTESXL,'Data')
##NUTRIENTS2and3 (second and third field season)
NUTES2XL = pd.ExcelFile(datadir+'NUTRIENTS/NUTRIENTS from Lisa 5_5_14.xlsx')
NUTES2infoXL = pd.ExcelFile(datadir+'NUTRIENTS/NUTRIENTS to Lisa 3_17_14.xlsx')
Fagaalu_stage_data = Fagaalu_stage_data.reindex(
pd.date_range(start2012, stop2014, freq='15Min'))
#### Import T and SSC Data
from load_from_MASTER_XL import TS3000, YSI, OBS, loadTSS
## Turbidimeter Data DAM
DAM_TS3K = TS3000(XL, 'DAM-TS3K')
DAM_YSI = YSI(XL, 'DAM-YSI')
## Turbidimeter Data LBJ
LBJ_YSI = YSI(XL, 'LBJ-YSI')
LBJ_OBSa = OBS(XL, 'LBJ-OBSa').truncate(after=dt.datetime(2013, 4, 1))
LBJ_OBSb = OBS(XL, 'LBJ-OBSb')
LBJ_OBSa = LBJ_OBSa.rename(columns={'Turb_SS_Avg': 'NTU'})
LBJ_OBSb = LBJ_OBSb.rename(columns={'Turb_SS_Mean': 'NTU'})
LBJ_OBS = LBJ_OBSa.append(LBJ_OBSb)
## TSS Data, equivalent to SSC but I don't want to change all the code and file names
TSSXL = pd.ExcelFile(datadir + 'SSC/TSS_grab_samples.xlsx')
TSS = loadTSS(TSSXL, 'ALL_MASTER')
TSS = TSS[TSS['TSS (mg/L)'] > 0]
#### Import NUTRIENT Data
from load_from_MASTER_XL import loadNUTES1, loadNUTES2and3
##NUTRIENTS1 (first field season)
NUTESXL = pd.ExcelFile(datadir + 'NUTRIENTS/NUTRIENTS1.xlsx')
NUTES1 = loadNUTES1(NUTESXL, 'Data')
##NUTRIENTS2and3 (second and third field season)
NUTES2XL = pd.ExcelFile(datadir + 'NUTRIENTS/NUTRIENTS from Lisa 5_5_14.xlsx')
NUTES2infoXL = pd.ExcelFile(datadir +
'NUTRIENTS/NUTRIENTS to Lisa 3_17_14.xlsx')
