python时间数据合并_python – 使用numpy / pandas按时间戳合并时间序列数据

我想你可以简单

>将时间戳定义为每个DataFrame的索引(使用set_index)

>使用连接将它们与“外部”方法合并

> Optionnaly将时间戳转换为日期时间

这是它的样子.

# generating some test data

timestamp = [1440540000, 1450540000]

df1 = pd.DataFrame(

{ imestamp: timestamp, a: [val_a, val2_a], : [val_b, val2_b], c: [val_c, val2_c]})

# building a different index

timestamp = timestamp * np.random.randn(abs(1))

df2 = pd.DataFrame(

{ imestamp: timestamp, d: [val_d, val2_d], e: [val_e, val2_e], f: [val_f, val2_f],

g: [val_g, val2_g]}, index=index)

# keeping a value in common with the first index

timestamp = [1440540000, 1450560000]