To prepare my data for analysis I am filtering and merging six different datasets with use of R in PuTTY (Linux). Five of six datasets are properly read into R, but one isn't. The dataset is (just like the other 5) a csv file named sire_ebv.csv and should have 56,141 rows which is what is confirmed when checking the number of rows in PuTTY. However, when simply reading the data into R, the dataset contains 42,875 rows. Somehow R deletes rows of the dataset. The following code is used to read the dataset into R:
sireebv <- read.csv("sire_ebv.csv", header = TRUE, sep = ";")
Head and tail were compared between PuTTY and R and were completely similar, also no double rows are present in the data.
Does anyone know what might cause this deletion of rows and how I can fix it?
Thank you in advance!
Edit: the original file also does not contain empty lines.