GitHub - SEL-Columbia/ss_data_analysis: Scripts used to generate timeseries tables from high res meter data and analyze it

SEL-Columbia / ss_data_analysis Public

Notifications You must be signed in to change notification settings
Fork 0
Star 1

Scripts used to generate timeseries tables from high res meter data and analyze it

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 8 Commits
README		README
base.py		base.py
cdfwatthours.py		cdfwatthours.py
cdfwatthourspg.py		cdfwatthourspg.py
cmpCredits.py		cmpCredits.py
concurrenttimeseries.py		concurrenttimeseries.py
conversion.txt		conversion.txt
countHourlyOscillations.py		countHourlyOscillations.py
counttimeseries.py		counttimeseries.py
createres.py		createres.py
createres2.py		createres2.py
createtabs.py		createtabs.py
credithistory.py		credithistory.py
dailyres.py		dailyres.py
dailytscache.py		dailytscache.py
denormalize_to_csv.py		denormalize_to_csv.py
final.py		final.py
forecast.py		forecast.py
get_emax_pmax.py		get_emax_pmax.py
getenergyAllCircuits.py		getenergyAllCircuits.py
getpdf.py		getpdf.py
getpdf2.py		getpdf2.py
getpdf3.py		getpdf3.py
getpdf4.py		getpdf4.py
getpdfAllHourlyEnergy.py		getpdfAllHourlyEnergy.py
getpdfAllHourlyEnergy2.py		getpdfAllHourlyEnergy2.py
getpdfAllHourlyEnergy2ug05.py		getpdfAllHourlyEnergy2ug05.py
getpdfAllHourlyEnergy3.py		getpdfAllHourlyEnergy3.py
getpdfAllMinutelyEnergy.py		getpdfAllMinutelyEnergy.py
getpdfAllMinutelyEnergy2.py		getpdfAllMinutelyEnergy2.py
getpdfAllMinutelyEnergy2ug05.py		getpdfAllMinutelyEnergy2ug05.py
getpdfAllMinutelyEnergy3.py		getpdfAllMinutelyEnergy3.py
getpdfAllPower.py		getpdfAllPower.py
getpdfDaytimeEnergy.py		getpdfDaytimeEnergy.py
getpdfDifferentialEnergy.py		getpdfDifferentialEnergy.py
getpdfDifferentialEnergy2.py		getpdfDifferentialEnergy2.py
getpdfDifferentialEnergy3.py		getpdfDifferentialEnergy3.py
getpdfEnergy.py		getpdfEnergy.py
getpdfEveningEnergy.py		getpdfEveningEnergy.py
getpdfMinutelyEnergyByTimeOfDay.py		getpdfMinutelyEnergyByTimeOfDay.py
getpdfPower.py		getpdfPower.py
getpdfbar1.py		getpdfbar1.py
getpdfbar2.py		getpdfbar2.py
getpdfbar3.py		getpdfbar3.py
guassian.py		guassian.py
hourlytscache.py		hourlytscache.py
hourres.py		hourres.py
inserthourlywh.py		inserthourlywh.py
insertres.py		insertres.py
insertres2.py		insertres2.py
insertres3.py		insertres3.py
insertres4.py		insertres4.py
kannel_stats2.py		kannel_stats2.py
loadtimeseries2.py		loadtimeseries2.py
loadwatts_ml00_00_1Q2011.py		loadwatts_ml00_00_1Q2011.py
loadwatts_ml00_00_2Q2011.py		loadwatts_ml00_00_2Q2011.py
loadwatts_ml00_00_3Q2011.py		loadwatts_ml00_00_3Q2011.py
loadwatts_ml00_00_4Q2011.py		loadwatts_ml00_00_4Q2011.py
loadwatts_ml00_00_after2011.py		loadwatts_ml00_00_after2011.py
loadwatts_ml00_00_before2011.py		loadwatts_ml00_00_before2011.py
logvalidate.py		logvalidate.py
meter_stats_2.py		meter_stats_2.py
minutelytscache.py		minutelytscache.py
minuteres.py		minuteres.py
ml00_0_2011.py		ml00_0_2011.py
poisson.py		poisson.py
refreshDbCalculations.py		refreshDbCalculations.py
requirements.txt		requirements.txt
scatterplot.py		scatterplot.py
scatterplot_credit_avgwatts.py		scatterplot_credit_avgwatts.py
scatterplot_precip_avgwatts.py		scatterplot_precip_avgwatts.py
secondlytscache.py		secondlytscache.py
sharedsolartimeseries.py		sharedsolartimeseries.py
sqlwalker.py		sqlwalker.py
ts.py		ts.py
ts2011.py		ts2011.py
ts2012.py		ts2012.py
tscache.py		tscache.py
ug00.py		ug00.py
ug07.py		ug07.py
ug08.py		ug08.py
waveletApp.py		waveletApp.py

Repository files navigation

Various scripts used to load data into timeseries databases and 
analyze that data.

Be extremely careful running these scripts on "production" as
they will overwrite existing data dumps without modifying hard-coded
configuration variables.  This needs a bit of TLC before being 
generally useful.  

Load scripts:
base.py, final.py (sample run in conversion.txt)

The rest of the scripts perform varied analyses on that data (to
be elaborated).