擅长:python、mysql、java
<p>我想你可能想把“hms”表单当作文本,然后编写自己的计数函数?希望这有帮助</p>
<pre><code>import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
def converter(hms):
"""Takes a time in hms returns number of 15 second intervals after 00:00:00.
"""
h,m,s = hms.split(':')
return int(h)*4+int(m)//15
converter('02:15:00') # 9
path = 'YOUR path'
new_df = pd.read_csv(path+'stack.txt')
new_df['Interval Mapped'] = new_df['Interval'].apply(lambda x: converter(x))
new_df
</code></pre>