python之将秒列转换为 hh :mm:ss之Pandas

我确定这是在 SO 中，但我似乎找不到它。我正在尝试将 floats 的 column 转换为显示为 hh:mm:ss 的 timestamps。以下是我的尝试:

import pandas as pd 
 
d = ({ 
    'A' : [100.4,200.2,300.3,400.6,500.8,600.9],                  
    'B' : [10.4,21.5,36.3,44.3,56.6,60.5],                                       
     }) 
 
df = pd.DataFrame(data = d) 
 
df['A','B'] = pd.to_datetime(df['A','B'], unit='h') 

预期输出:

          A         B 
0  00:01:40  00:00:10 
1  00:03:20  00:00:22 
2  00:05:00  00:00:36 
3  00:06:41  00:00:44 
4  00:08:21  00:00:57 
5  00:10:01  00:01:01 

请您参考如下方法:

import pandas as pd 
 
d = ({ 
    'A' : [100.4,200.2,300.3,400.6,500.8,600.9],                  
    'B' : [10.4,21.5,36.3,44.3,56.6,60.5],                                       
     }) 
 
df = pd.DataFrame(data = d) 
 
df['A'] = df['A'].astype('float64')  
df['B'] = df['B'].astype('float64')  
 
df['A'] = pd.to_datetime(df["A"], unit='s').dt.strftime("%H:%M:%S") 
df['B'] = pd.to_datetime(df["B"], unit='s').dt.strftime("%H:%M:%S") 

输出是:

 
    A           B 
0   00:01:40    00:00:10 
1   00:03:20    00:00:21 
2   00:05:00    00:00:36 
3   00:06:40    00:00:44 
4   00:08:20    00:00:56 
5   00:10:00    00:01:00