Read CSV with yyyyMMddhhmmss and group months
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Hello! Matlab newbie, so I apologize if this is a simple question.
I've got a 5000 by 1 CSV file filled with numbers in the yyyyMMddhhmmss format. I'm simply trying to group each line by month.
4 Commenti
Stephen23
il 10 Gen 2022
Modificato: Stephen23
il 10 Gen 2022
@Lauren: what version of MATLAB are you using?
" I'm simply trying to group each line by month."
Which of these to you want?:
- group by month only (so you will get twelve groups, i.e. 2021-03 is in the same group as 2019-03)
- group by month of every year (i.e. 2021-03 is in a different group from 2019-03).
What do you want to occur with missing data? For example, such as here:
Note that your description does not match the uploaded file:
yyyyMMddhhmmss % your description.
202009090029 % actually in the file (no seconds).
Risposta accettata
Stephen23
il 11 Gen 2022
Here is one way to group by month only, ignoring empty lines of the CSV file:
str = fileread('sample.csv');
tkn = regexp(str,'^(\d{4})(\d\d)','tokens','lineanchors');
tkn = vertcat(tkn{:})
[~,~,grp] = unique(tkn(:,2),'stable')
Più risposte (1)
KSSV
il 9 Gen 2022
Read about datevec. This will split the date into year, month, days etc.....from this you can apply the function unique and get them grouped.
0 Commenti
Vedere anche
Categorie
Scopri di più su Dates and Time in Help Center e File Exchange
Prodotti
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!