Reading in Excel Data from GitHub

New to Julia
, ,
5

@Michael_Barmann, using the github’s link to the raw version of your csv file, it works:

using HTTP, CSV
data_url = "https://raw.githubusercontent.com/MichaelBarmann/ParamEst_MRE/main/sample_data.csv"
my_file = CSV.File(HTTP.get(data_url).body)
df = DataFrame(my_file)

103×3 DataFrame
 Row │ Date        t      Ic    
     │ String      Int64  Int64 
─────┼──────────────────────────
   1 │ 8/24/2020       0     79
   2 │ 8/25/2020       1    168
   3 │ 8/26/2020       2    222
   4 │ 8/27/2020       3    282
   5 │ 8/28/2020       4    347
   6 │ 8/29/2020       5    397
   7 │ 8/30/2020       6    501
   8 │ 8/31/2020       7    731
   9 │ 9/1/2020        8    930
  10 │ 9/2/2020        9   1050
  11 │ 9/3/2020       10   1138
  12 │ 9/4/2020       11   1242
  13 │ 9/5/2020       12   1279
  14 │ 9/6/2020       13   1316
  ⋮  │     ⋮         ⋮      ⋮
  90 │ 11/21/2020     89   3998
  91 │ 11/22/2020     90   4017
  92 │ 11/23/2020     91   4043
  93 │ 11/24/2020     92   4056
  94 │ 11/25/2020     93   4070
  95 │ 11/26/2020     94   4103
  96 │ 11/27/2020     95   4124
  97 │ 11/28/2020     96   4195
  98 │ 11/29/2020     97   4221
  99 │ 11/30/2020     98   4253
 100 │ 12/1/2020      99   4276
 101 │ 12/2/2020     100   4301
 102 │ 12/3/2020     101   4321
 103 │ 12/4/2020     102   4346
                 75 rows omitted
2 Likes