如何在python中将3个数据帧与某个阈值对齐？

pip install pandas

import pandas as pd

# 假设我们有三个数据帧df1, df2, df3和一个阈值threshold
threshold = 10

# 示例数据帧
data1 = {'value': [5, 12, 8, 20]}
data2 = {'value': [15, 7, 11, 3]}
data3 = {'value': [2, 18, 9, 14]}

df1 = pd.DataFrame(data1)
df2 = pd.DataFrame(data2)
df3 = pd.DataFrame(data3)

# 根据阈值筛选数据帧
df1_aligned = df1[df1['value'] > threshold]
df2_aligned = df2[df2['value'] > threshold]
df3_aligned = df3[df3['value'] > threshold]

# 打印对齐后的数据帧
print("Aligned DataFrame 1:")
print(df1_aligned)
print("\nAligned DataFrame 2:")
print(df2_aligned)
print("\nAligned DataFrame 3:")
print(df3_aligned)

# 假设df1, df2, df3有相同的索引或列名'key'
df_aligned = pd.merge(pd.merge(df1, df2, on='key'), df3, on='key')