Different number of samples inside .csv when exploring with Excel and Pandas

Question

I am new to Data Science and am working on pandas. I have downloaded a dataset and when I try to read the dataset using the pd.read_excel command I can view 130.808 rows. But when I read the file using pd.read_csv I can view only 130.802. My question is where did the 5 rows go? I have not modified my dataset. Can anyone help me?

Answer 1

You need to check two things in your dataset. number one do you have any quote char in your dataset. number two does your dataset have any line terminator.

In case you don't have them use them. the line terminator will tell this is not a new line its a row. 

If you want to know more about the Data Science then do check out the following Data Science which will help you in understanding Data Science from scratch