DataDelta: Dataset Comparison Report

Summary comparison of changes between two tables 29-December-2021 (04:18 PM)

Old Dataframe Summary

Number of Records: 6 | Number of Columns: 26
Primary Key: A   |   Primary Key Is Unique: True
column_names n_valid_records prop_valid_records datatype
0 A 6 100.0 int64
1 B 6 100.0 float64
2 C 6 100.0 int64
3 D 6 100.0 object
4 E 6 100.0 object
5 F 6 100.0 object
6 G 6 100.0 int64
7 I 6 100.0 int64
8 J 6 100.0 int64
9 K 6 100.0 int64
10 L 6 100.0 int64
11 M 6 100.0 int64
12 N 6 100.0 int64
13 O 6 100.0 int64
14 P 6 100.0 int64
15 Q 6 100.0 int64
16 R 6 100.0 int64
17 W 6 100.0 int64
18 X 6 100.0 int64
19 Y 6 100.0 int64
20 Z 6 100.0 int64
21 H 2 33.3 float64
22 S 0 0.0 float64
23 T 0 0.0 float64
24 U 0 0.0 float64
25 V 0 0.0 float64

New Dataframe Summary

Number of Records: 7 | Number of Columns: 26
Primary Key: A   |   Primary Key Is Unique: True
column_names n_valid_records prop_valid_records datatype
0 A 7 100.0 int64
1 B 7 100.0 float64
2 C 7 100.0 int64
3 D 7 100.0 object
4 F 7 100.0 object
5 G 7 100.0 int64
6 I 7 100.0 object
7 J 7 100.0 int64
8 K 7 100.0 int64
9 L 7 100.0 int64
10 M 7 100.0 int64
11 N 7 100.0 int64
12 O 7 100.0 int64
13 P 7 100.0 int64
14 Q 7 100.0 int64
15 R 7 100.0 int64
16 W 7 100.0 int64
17 X 7 100.0 int64
18 Y 7 100.0 int64
19 Z 7 100.0 int64
20 HH 6 85.7 float64
21 H 2 28.6 float64
22 S 0 0.0 float64
23 T 0 0.0 float64
24 U 0 0.0 float64
25 V 0 0.0 float64

Column Changes


Top 50 Removed Columns

['E']

Top 50 Added Columns

['HH']

Record Count Changes


Top 50 Removed Records

[2]

Top 50 Added Records

[6, 7]

Datatype Changes


Summary of Datatype Changes

column_name old_df_dtype new_df_dtype
I int64 object

Top 50 Changed Columns

['I']

Record Value Changes


Proportion of Records that have Changed for Each Column

column_names n_changed_records changed_records_%
0 I 5 100.0
1 F 4 80.0
2 D 3 60.0
3 B 2 40.0
4 C 2 40.0
5 H 2 40.0

Top 50 Changed Records

[1, 3, 4, 5, 8]

Top 50 Changed Columns

['I', 'F', 'D', 'B', 'C', 'H']

Comparison of Changed Records

A B_NEW B_OLD C_NEW C_OLD D_NEW D_OLD E_OLD F_NEW F_OLD G_NEW G_OLD HH_NEW H_NEW H_OLD I_NEW I_OLD J_NEW J_OLD K_NEW K_OLD L_NEW L_OLD M_NEW M_OLD N_NEW N_OLD O_NEW O_OLD P_NEW P_OLD Q_NEW Q_OLD R_NEW R_OLD S_NEW S_OLD T_NEW T_OLD U_NEW U_OLD V_NEW V_OLD W_NEW W_OLD X_NEW X_OLD Y_NEW Y_OLD Z_NEW Z_OLD
0 1 0.93215 0.93215 5 5 cat cat lkasd 1 asd 10 10 1.0 NaN 4.0 Cat 11 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 NaN NaN NaN NaN NaN NaN NaN NaN 10 10 10 10 10 10 10 10
1 3 0.93215 0.93215 4 6 hat potato lkasd cat sd 10 10 1.0 NaN NaN Cat 11 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 NaN NaN NaN NaN NaN NaN NaN NaN 10 10 10 10 10 10 10 10
2 4 1.00000 0.93215 5 5 nugget chicken lkasd 1 asd 10 10 1.0 5.0 4.0 Cat 11 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 NaN NaN NaN NaN NaN NaN NaN NaN 10 10 10 10 10 10 10 10
3 5 1.00000 0.93215 4 1 joy chicken lkasd 1 d 10 10 1.0 NaN NaN Cat 11 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 NaN NaN NaN NaN NaN NaN NaN NaN 10 10 10 10 10 10 10 10
4 8 0.93215 0.93215 1 1 chicken chicken lkasd d d 10 10 NaN NaN NaN 11 11 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 NaN NaN NaN NaN NaN NaN NaN NaN 10 10 10 10 10 10 10 10