PROSAGA码农传奇-python-转换为'datetime'类型的问题：小时必须在0..23

转换为'datetime'类型的问题：小时必须在0..23

作者: Gassyc加西可
发布时间: 2025-03-25 12:20:52 (13天前)
转自：

<div class =“post-text”itemprop =“text”>
  <P>
    显然问题是
     <code>
      24:00
    </code>
    ，解决方案是
    <a href="http://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.str.split.html" rel="nofollow noreferrer">
       <code>
        Series.str.split
      </code>
    </A>
    ，
     <code>
      date
    </code>
    转换为
    <a href="http://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.to_datetime.html" rel="nofollow noreferrer">
       <code>
        to_datetime
      </code>
    </A>
     和
     <code>
      time
    </code>
     通过
    <a href="http://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.to_timedelta.html" rel="nofollow noreferrer">
       <code>
        to_timedelta
      </code>
    </A>
     和总结：
  </p>
   <pre>
    <code>
      print (df)
           datetime
0  10/10/1949 20:30
1  10/10/1949 21:00
2  10/10/1955 17:00
3  10/10/1956 24:00

df[['date','time']] = df['datetime'].str.split(expand=True)
df['datetime'] = (pd.to_datetime(df.pop('date'), format='%d/%m/%Y') + 
                  pd.to_timedelta(df.pop('time') + ':00'))
print (df)
             datetime
0 1949-10-10 20:30:00
1 1949-10-10 21:00:00
2 1955-10-10 17:00:00
3 1956-10-11 00:00:00

</code>
  </pre>
</DIV>

转换为'datetime'类型的问题： 小时必须在0..23

转换为'datetime'类型的问题：小时必须在0..23