擅长:python、mysql、java
<p>假设您想删除非小时列,一个解决方案是:</p>
<pre class="lang-python prettyprint-override"><code>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:]))
))
</code></pre>