new_data=[]
for index,row in your_DataFrame.iterrows():
zone_id_date=str(row['zone_id'])+'_'+str(row['date'])
for hour in range(1,25):
ID=zone_id_date+'_h'+str(hour)
observation=row['h'+str(hour)]
new_row=[ID,observation]
new_data.append(new_row)
output_data=pandas.DataFrame(data=new_data, columns = ['ID', 'observation'])
result = df.set_index('date')\
.filter(regex='^h')\
.stack()\
.to_frame()
# index values are now tuples such as (2018-01-01, 'h1')
result = result.set_index(result.index.map(
lambda idx: idx[0] + timedelta(hours=int(idx[1][1:]))
))
下面的代码块将创建一个包含两列的新数据帧:
代码:
假设您想删除非小时列,一个解决方案是:
相关问题 更多 >
编程相关推荐