时间戳

首页 > 解决方案 > 如何在多索引数据框的索引中插入值

python - 如何在多索引数据框的索引中插入值

问题描述

我想在只有一行的数据框的索引中引入当前时间。

这是数据框：

COIN    $ANRX                                                                              
                                                                                                                             $BASED ... ZRX ZT
        24h Volume  Commits in Last 4 Weeks Contributors    FB Likes    Market Cap Dominance    Mkt Cap Price   Reddit Subscribers  24h Volume  Commits in Last 4 Weeks ... Price   Reddit Subscribers  24h Volume  Commits in Last 4 Weeks Contributors    FB Likes    Market Cap Dominance    Mkt Cap Price   Reddit Subscribers
TIME                                                                                    
0       $483,788    0   0

这就是我想要的：

COIN    $ANRX                                                                              
                                                                                                                             $BASED ... ZRX ZT
                        24h Volume  Commits in Last 4 Weeks Contributors    FB Likes    Market Cap Dominance    Mkt Cap Price   Reddit Subscribers  24h Volume  Commits in Last 4 Weeks ... Price   Reddit Subscribers  24h Volume  Commits in Last 4 Weeks Contributors    FB Likes    Market Cap Dominance    Mkt Cap Price   Reddit Subscribers
TIME                                                                                    
'11:51 14/03/2021'      $483,788    0   0

使用此代码花费的时间（如果您想知道）

now = datetime.now()
current_time = now.strftime("%H:%M %d/%m/%Y")
current_time

标签： pythonpandas

解决方案

You can create a temporary TIME column, populate it with datetime.now(), set it as DatetimeIndex and drop the temporary column:

df['TIME'] = pd.datetime.now().strftime("%H:%M %d/%m/%Y")
df = df.set_index(pd.DatetimeIndex(df['TIME']))
df = df.drop(columns=['TIME'])

推荐阅读