Hi Rob,
I have data in a .csv file, similar to the following:
line1,,,,,,,,,,,
line2,,,,,,,,,,,
line3,,,,,,,,,,,
line4,,,,,,,,,,,
line5,,,,,,,,,,,
"Date Stamp","var01_A.B","var02_A.B","var03_A.B","var04_A.B","var05_A.B","var06_A.B","var07_A.B","var08_A.B","var09_A.B","var10_A.B","var11_A.B"
02/10/1984,,,,0.43229652,,0.016809284,0.935454489,,0.835706171,0.931661173,
03/10/1984,,,,0.873636498,,0.766104375,0.58352002,,0.149819958,0.843031183,
04/10/1984,,,,0.690550564,,0.850058145,0.660475501,,0.138391391,0.012552724,
05/10/1984,,,,0.786253598,,0.725499888,0.095887078,,0.954524359,0.643051778,
08/10/1984,,,,ND,,ND,ND,,ND,ND,
09/10/1984,,,,0.207159227,,0.124627798,0.479387627,,0.513664361,0.792096811,
10/10/1984,,,,0.062584772,,0.983969584,0.851868512,,0.349656018,0.504837902,
11/10/1984,,,,ND,,ND,ND,,ND,ND,
12/10/1984,,,,0.029694137,,0.425849422,0.472271915,,0.885554126,0.349329919,
etc etc
31/10/1984,,,,0.732169031,,0.243894477,0.187721696,,0.835966601,0.515125823,
to present day
I'd like to read into fable as a tsibble, for VAR analysis, it's
- DAILY, 5 days per week
- there's empty cells (as viewed in Excel), i.e. missing values
- there's ND for missing values
- I want to remove the first 5 lines, COMPACT to a MONTHLY, read in all 11 variables but ONLY the values for the LAST day of every MONTH.
Please can you help.
thanks,
Amarjit