擅长:python、mysql、java
<p>您可以简单地将两列组合在一个字符串函数中。我假设你使用的是24小时制或军事时间,精确到一分钟(100?)</p>
<pre><code>import pandas as pd
df = pd.read_clipboard()
for i in df.columns:
df[i] = df[i].apply(str)
df['datetime'] = pd.to_datetime(df['date'] + ' ' + df['time'].apply(lambda x: x.zfill(4)))
df
Out[11]:
ccy date time open high low close datetime
0 EURUSD 20190211 100 1.1318 1.1319 1.1317 1.1319 2019-02-11 01:00:00
1 EURUSD 20190211 200 1.132 1.1322 1.1319 1.1319 2019-02-11 02:00:00
2 EURUSD 20190211 300 1.1318 1.1319 1.1318 1.1319 2019-02-11 03:00:00
3 EURUSD 20190211 400 1.1319 1.1319 1.1318 1.1318 2019-02-11 04:00:00
4 EURUSD 20190211 500 1.1318 1.1318 1.1318 1.1318 2019-02-11 05:00:00
</code></pre>