Before /home/pythonscripts/mpxdatacheck/LINELIST_PAHO2024_03_28_04_53_21.csv After /home/pythonscripts/mpxdatacheck/LINELIST_PAHO2024_03_29_04_53_04.csv DataComPy Comparison -------------------- DataFrame Summary ----------------- DataFrame Columns Rows 0 df1 34 60902 1 df2 34 60936 Column Summary -------------- Number of columns in common: 34 Number of columns in df1 but not in df2: 0 Number of columns in df2 but not in df1: 0 Row Summary ----------- Matched on: index Any duplicates on match values: No Absolute Tolerance: 0 Relative Tolerance: 0 Number of rows in common: 60,902 Number of rows in df1 but not in df2: 0 Number of rows in df2 but not in df1: 34 Number of rows with some compared columns unequal: 1 Number of rows with all compared columns equal: 60,901 Column Comparison ----------------- Number of columns compared with some values unequal: 2 Number of columns compared with all values equal: 32 Total number of values which compare unequal: 2 Columns with Unequal Values or Types ------------------------------------ Column df1 dtype df2 dtype # Unequal Max Diff # Null Diff 0 clade object object 1 0 1 1 icu object object 1 0 1 Sample Rows with Unequal Values ------------------------------- clade (df1) clade (df2) recordid reporting_country ON1274161 CANADA NaN UNK icu (df1) icu (df2) recordid reporting_country ON1274161 CANADA UNK NaN Sample Rows Only in df2 (First 10 Columns) ------------------------------------------ pregnant case_class smallpox_vaccine gender sexual_orientation clade hospitalised concurrrent_sti icu outcome recordid reporting_country ON1356362 CANADA NaN CONFIRMED NaN MALE NaN UNK NO NaN NaN NaN ON1357023 CANADA NaN CONFIRMED NaN MALE NaN UNK NO NaN NaN NaN BCmpx_224 CANADA NaN CONFIRMED NaN MALE NaN NaN NO NaN NO NaN ON1357077 CANADA NO CONFIRMED NaN FEMALE NaN UNK NO NaN NaN NaN ON1357037 CANADA NaN CONFIRMED NaN MALE NaN UNK NO NaN NaN NaN BCmpx_223 CANADA NO CONFIRMED NaN MALE NaN NaN NO NaN NO NaN ON1353405 CANADA NaN CONFIRMED NaN MALE NaN NaN NO NaN NaN NaN ON1355005 CANADA NaN CONFIRMED NaN MALE NaN UNK NO NaN NaN NaN ON1357928 CANADA NaN CONFIRMED NaN MALE NaN UNK NO NaN NaN NaN ON1351934 CANADA NaN CONFIRMED NaN MALE NaN NaN NO NaN NaN NaN