Using CSV.read() to import data from a data input file into a DataFrame

General Usage
, ,
22

Just to show what Peter meant:

julia> using DataFrames, CSV

julia> data = """
       1511805.54010775,-3631401.61267572,134,14.0385102411102,1.58792636637882
       1511880.54010775,-3631401.61267572,135,14.0623467964249,1.63997535275912
       1511955.54010775,-3631401.61267572,136,13.8401810265915,1.48364309144577
       1511730.54010775,-3631476.61267572,248,14.3080113191324,1.8129535268525
       1511805.54010775,-3631476.61267572,249,14.2710283891669,1.78019664985144
       1511880.54010775,-3631476.61267572,250,14.2895778872987,1.79291534883922
       1511955.54010775,-3631476.61267572,251,13.9846463218381,1.55426381397442
       1512030.54010775,-3631476.61267572,252,13.1978960888864,1.12702376308933
       1512105.54010775,-3631476.61267572,253,12.0766192975667,0.867366055025797
       """
"1511805.54010775,-3631401.61267572,134,14.0385102411102,1.58792636637882\n1511880.54010775,-3631401.61267572,135,14.0623467964249,1.63997535275912\n1511955.54010775,-3631401.61267572,136,13.8401810265915,1.48364309144577\n1511730.54010775,-3631476.61267572,248,14.3080113191324,1.8129535268525\n1511805.54010775,-3631476.61267572,249,14.2710283891669,1.78019664985144\n1511880.54010775,-3631476.61267572,250,14.2895778872987,1.79291534883922\n1511955.54010775,-3631476.61267572,251,13.9846463218381,1.55426381397442\n1512030.54010775,-3631476.61267572,252,13.1978960888864,1.12702376308933\n1512105.54010775,-3631476.61267572,253,12.0766192975667,0.867366055025797\n"

julia> CSV.read(IOBuffer(data), DataFrame; delim = ",", header = false)
9×5 DataFrame
 Row │ Column1    Column2     Column3  Column4  Column5  
     │ Float64    Float64     Int64    Float64  Float64  
─────┼───────────────────────────────────────────────────
   1 │ 1.51181e6  -3.6314e6       134  14.0385  1.58793
   2 │ 1.51188e6  -3.6314e6       135  14.0623  1.63998
   3 │ 1.51196e6  -3.6314e6       136  13.8402  1.48364
   4 │ 1.51173e6  -3.63148e6      248  14.308   1.81295
   5 │ 1.51181e6  -3.63148e6      249  14.271   1.7802
   6 │ 1.51188e6  -3.63148e6      250  14.2896  1.79292
   7 │ 1.51196e6  -3.63148e6      251  13.9846  1.55426
   8 │ 1.51203e6  -3.63148e6      252  13.1979  1.12702
   9 │ 1.51211e6  -3.63148e6      253  12.0766  0.867366

Here I’m just reading the data from an IOBuffer, but equally I can write this out to a file and read back in from disk:

# df is the DataFrame I read in above
julia> CSV.write("test.csv", df)
"test.csv"

julia> CSV.read("test.csv", DataFrame; delim = ",")
# Same result as above (although the file written to disk has a header now, so I removed header=false here