diff options
| -rw-r--r-- | python/database_consistency.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/python/database_consistency.py b/python/database_consistency.py index df9dad32..cb5d54a3 100644 --- a/python/database_consistency.py +++ b/python/database_consistency.py @@ -20,4 +20,4 @@ SELECT dealname, updatedate AS date, SUM(curr_balance) AS bal FROM cte parse_dates=["date"], index_col=["dealname", "date"]) data12 = pd.merge(data1, data2, left_index=True, right_index=True) data13 = pd.merge(data1bis, data3, left_index=True, right_index=True) - print(data13.query('bal_x-bal_y>1|bal_x-bal_y<-1').sortlevel(level=1)) + print(data12.query('bal_x-bal_y>1|bal_x-bal_y<-1').sort_index(level=1)) |