Difference between File and Rows

[timholy]

Perhaps it's intended, but the attached file
facultyinvolvement.csv

gives different results when parsed via File and Rows:

julia> CSV.File("facultyinvolvement.csv") |> DataFrame
6×8 DataFrame
 Row │ Faculty  DBBS Approval Date  INTERVIEW Biochemistry  INTERVIEW Biomedical Informatics and Data Science  INTERVIEW Human and Statistical Genetics  THESIS CMTE Biochemistry  THESIS CMTE Biomedical ⋯
     │ String7  String15            Missing                 Union{Missing, Int64}                              Union{Missing, Int64}                     Union{Missing, Int64}     Missing                ⋯
─────┼─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
   1 │ fac1     01/01/2020                         missing                                            missing                                   missing                         1                         ⋯
   2 │ fac2     01/01/2020                         missing                                                  2                                   missing                   missing 
   3 │ fac3     01/01/2020                         missing                                            missing                                         5                   missing 
   4 │ fac4     01/01/2020                         missing                                                  3                                         3                   missing 
   5 │ fac5     01/01/2020                         missing                                            missing                                   missing                         1                         ⋯
   6 │ fac6     01/01/2020                         missing                                            missing                                         3                         1 
                                                                                                                                                                                          2 columns omitted

julia> CSV.Rows("facultyinvolvement.csv") |> DataFrame
6×8 DataFrame
 Row │ Faculty     DBBS Approval Date  INTERVIEW Biochemistry  INTERVIEW Biomedical Informatics and Data Science  INTERVIEW Human and Statistical Genetics  THESIS CMTE Biochemistry  THESIS CMTE Biomedi ⋯
     │ PosLenSt…?  PosLenSt…?          PosLenSt…?              PosLenSt…?                                         PosLenSt…?                                PosLenSt…?                PosLenSt…?          ⋯
─────┼─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
   1 │ fac1        01/01/2020          missing                 missing                                            missing                                   1                         missing             ⋯
   2 │ fac2        01/01/2020          missing                 2                                                  missing                                   1                         missing
   3 │ fac3        01/01/2020          missing                 2                                                  5                                         1                         missing
   4 │ fac4        01/01/2020          missing                 3                                                  3                                         1                         missing
   5 │ fac5        01/01/2020          missing                 3                                                  3                                         1                         missing             ⋯
   6 │ fac6        01/01/2020          missing                 3                                                  3                                         1                         missing

It looks like any missing field borrows the result from the previous return value?

[quinnj]

Yes, this was also reported in #903; an unfortunate side effect of an internal refactoring that happened for the 0.9 release.

[timholy]

Thanks for the fix!