Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in Data Science by (18.4k points)
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?

1 Answer

0 votes
by (36.8k points)

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

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...