Dealing with empty and incomplete lines
When reading irregular files, i.e., files with varying/missing fields in rows, fread() tries to parse them intelligently. However, it may not be always possible to guess if the irregular lines should be skipped or imported by filling missing fields. For such cases, you can use the fill argument of fread().
You will be importing the following file:
id,name,val
9002019291929192,Robert Whitaker,
9200129401349301 ,Elisa Waters,190
9200149429834456 , Karla Schmidt
Notice that the first and last lines are incomplete.
This exercise is part of the course
Data Manipulation with data.table in R
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Import the file and note the warning message
incorrect <- ___
incorrect