擅长:python、mysql、java
<pre><code>import pandas as pd
# create sample dataframe
idx = pd.date_range('2021-07-24 09:28:01', periods=3, freq='H')
df = pd.DataFrame({ 'idx': idx, 'val': np.random.randn(len(idx)) })
df.set_index(pd.DatetimeIndex(df['idx']), inplace=True, drop=True)
# apply function to index column to create new column with H:M
df['hm'] = df.index.map(lambda i: i.strftime('%H:%M'))
print(df)
</code></pre>
<p>输出:</p>
<pre><code> val hm
idx
2015-02-24 09:28:01 2015-02-24 09:28:01 -0.344819 09:28
2015-02-24 10:28:01 2015-02-24 10:28:01 -1.616330 10:28
2015-02-24 11:28:01 2015-02-24 11:28:01 1.711378 11:28
</code></pre>