"Kaichao Zheng" [email protected] wrote:

Hi Prof. Wise, I have a further question for the requirement:

Also based on the header line, report any lines that do not have the same number of cells. (Cells are allowed to be empty.) I wonder which file should I base? The raw file or the merged file? Best regards, Kaichao Zheng

Hi Kaichao, The testing for the correct number of cells per row should happen for the 3 files submitted to the data cleaning program, after which all the lines in a given file should have the same number of cells. Joining two files containing lines with the same number of cells per line (though perhaps different for each file), will result in the joined rows having the same number of cells. No?

Cheers MichaelW 👨‍🎨