partly_shading_conversion.py
f84eded83745master

partly_shading_conversion.py
View Options

			import numpy as np
			import pandas as pd
			import os
			import sys
			import util

			def combine_partly_shading_from_file( filename, target_column_name ):

			# create 50cm DOM long file
			shading_stats = pd.read_csv(filename)

			shading_list = []

			for column_name in shading_stats.columns:
			if column_name[:5] != 'mean_':
			continue

			# split the column name up in its fragements to extract information on day and time
			splitted_col = column_name.split('_')
			month = int(splitted_col[1])
			hour = int(splitted_col[2][:-1])

			timestamp = pd.to_datetime('2001-%d-15 %d:00' %(month, hour))
			# print(timestamp)

			# take information from 50cm dataframe
			new_df = shading_stats.loc[:,['DF_UID', column_name]]
			new_df = new_df.rename( {column_name : target_column_name}, axis=1 )
			new_df['timestamp'] = timestamp

			shading_list.append(new_df)

			return pd.concat(shading_list).sort_values(['DF_UID', 'timestamp']).reset_index().drop('index', axis=1)