Mon but c'est d'obtenir une format graphique des données en fonction des dates , mais avant tout il faut convertir les dates de la matrice en des vecteurs pour arriver à la fin à tracer la courbe , j'ai utilisé :
1 2
| [D,Q]=textread('le nom de fichier','sheet');
C=datenum(D,'yyyymmdd'); |
et le message d'erreur est:
??? Error using ==> datenum at 174
DATENUM failed.
Caused by:
Error using ==> dtstr2dtnummx
The input cell array must be either a column or a row.
le classeur ci joint au dessus :
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97
| 1972-1973 sept oct nov dec janv fev mars avril mai juin juil aout
Day T T T T T T T T
1 11.6 9.4 7.4 12 23.3 22.3 25.2 27.6
2 11.9 7.8 8.2 12.3 25.6 20 23.7 24.6
3 10.8 8 9 12.3 19.1 20.2 24.6 24
4 10.8 10.9 10.1 10.6 25.3 20.4 22 24.1
5 11 12.8 9.6 10.3 21.6 21.2 26.4 23.6
6 9.7 11.7 11.7 12.1 17.3 21 24.7 24.1
7 8.9 10.2 10.6 17.4 16.2 21.2 24.8 24.2
8 10.4 13.4 9.7 16.8 15.7 21.3 25.5 24.9
9 10.6 14 9.1 17.6 16.4 21 26.3 24.2
10 9.3 12.3 10.3 13.2 14.3 19.8 25.8 23.7
11 10 9.8 8.1 11.6 15.9 20.1 25.9 25.1
12 9.9 10 6.7 11.1 15.8 21.3 25.1 25.2
13 8.9 11.7 10 10.8 14.3 21.2 27 25.8
14 8.8 9.2 8.9 12.8 14.4 21.7 26.2 25.1
15 12.9 8.2 8.4 12.2 17.3 21.3 26 24.9
16 11.9 8.3 8.5 11 18.1 20.8 25.1 25.8
17 11.5 6.2 9.1 10.8 18.8 22.1 25.8 27.7
18 11.8 9.3 8.7 10.6 17.6 22.2 24.2 27.1
19 9.9 7 10.6 13.1 19.4 22.4 24.9 25.9
20 11.8 6.8 9.2 12.7 20.7 24.2 25.2 25.2
21 11.8 7.1 14.7 12.2 20.6 22.6 25.4 25
22 9.5 9.9 17.1 15.2 17.4 19.2 27.1 25.1
23 8.6 12.4 13.5 13.9 18.7 20.2 25.1 25.6
24 12.6 13.4 14.3 15.7 19.7 19.9 24.2 28.6
25 9.7 12.4 13.9 13.5 20.5 21.1 25.7 26.6
26 10.4 10.4 9.9 14.7 20.3 22.9 24.3 24.6
27 10.2 9.1 10.4 16.8 19.7 25.2 23.4 23.4
28 11.9 7.8 - 18.4 20.6 28.2 23.3 24.4
29 11.8 - 17.2 20.3 27.4 24.6 25
30 11.5 13.3 17.1 19.1 24.5 23.2 23.8
31 10.6 11.1 19.5 22.9 22
1973-1974
1 22.6 20.6 15.1 14.3 10.7 10 10.5 14.4 13.7 19.5 24.5 24.9
2 23.6 20.7 14.8 14.7 10 13.6 11.8 13.9 14.6 18.6 23.8 23.9
3 22.7 20.8 15.4 7.7 9.7 11.7 12.7 14.4 15.8 19.7 22.8 24.9
4 23.9 21.8 17 9.8 11.1 10.8 11.3 11.4 16 21.9 21 27.6
5 24.7 23.1 18.7 9.9 11.9 12.2 7.1 11 15.3 24.2 21.6 26.4
6 23.8 22.3 18.3 11.5 13.6 12.8 7.9 13.1 15.2 20.6 23.9 25.1
7 24.6 21.8 15.4 12.4 16.5 12.5 8.4 12.7 13.6 19.9 24.5 25.1
8 25.7 18.7 13.9 11 14.9 11.1 8.3 12.4 14.3 19.3 23.4 28.2
9 28 18.3 13.9 8.7 13.7 10.8 12 16.4 13.2 20.1 23.6 24.4
10 25.3 17.7 14.2 10.1 14.1 11 8.3 17.1 15.7 20.4 23.3 22.9
11 23.8 18.3 12.8 10.7 12.5 11.5 12 15.3 20.8 19.6 24.3 23.3
12 23.1 18.5 14.4 11.6 12.9 12.7 12.3 11.7 18.8 19.6 22.3 24.1
13 22.8 20.1 14.1 11.3 11.7 11.7 10.2 13.2 19.7 21.9 24.5 21.7
14 28.1 20.1 15.2 13.1 13.9 9.3 9.1 12.1 16.6 20.9 25.2 24.1
15 25 21.6 16.4 12.9 12.1 10.2 11.7 14.7 16.7 23.1 26.8 24.8
16 26.3 22.3 14.6 9.2 12.4 13 15.1 12.6 17.5 22.1 27.7 24.6
17 26.3 19.7 12.8 11.2 11.4 8.9 16.7 11.1 18.2 20.3 25.1 24.5
18 25.5 20.6 12.2 12.9 11 9.8 13.2 11.3 16.5 20.8 24.2 24.8
19 23.7 21.7 15.1 13.6 11.3 10.8 17.4 10.8 17.5 21.2 22.7 24.4
20 23.6 22.7 15.8 14.3 11.8 11.3 22.4 10.8 17.2 21.1 19.8 28.2
21 26.5 20.9 14.8 13.8 9.6 12.1 13.8 11.3 18.8 20.6 23.1 26.6
22 24.6 18 13.4 12.8 11.1 10.6 13.3 11.7 20 23.1 22.5 24.6
23 23.7 15.4 12.8 12.7 11.8 11.8 10.9 14.7 18.2 24.3 22.4 24.3
24 22.7 17.3 11.8 16.1 11.2 9.7 15.1 13.3 17.5 22.4 21.4 24.3
25 19.1 15.3 12.3 12.8 11.3 9.3 22 14 17.7 23.2 23.8 23.3
26 19.7 13.8 15.3 10.9 9.5 9.6 17 14.8 19.2 24.4 21.7 24.3
27 19.9 16.4 12.6 9.7 11.2 9.7 13.7 18.7 22.4 23.9 23 22.5
28 20.4 16 11.7 7.5 9.9 10.4 15.2 15.9 22.1 24.3 21.3 23.4
29 19.5 15.8 9.4 14.4 10.6 17.3 14.1 20.2 25.9 22.9 22.1
30 23.2 15.4 12.8 13.1 11.8 14.7 12.5 23.3 23.2 23.3 24.4
31 15 12 11.6 14.6 24 25 24.6
1974-1975
1 - 18 11.9 12.8 10.8 11.9 10.3 10.1 14.7 20.4 24.3 24.5
2 - 18.1 12.2 13.8 10.4 11.3 11.4 10.8 13.3 18.7 23 26.2
3 - 20.2 13.6 11.2 10.1 9.2 13.6 9.7 14.6 18.3 22.4 26.8
4 - 23.4 13.5 9.7 10 11.2 13.3 15.1 12.7 18.6 24.1 25.3
5 - 21.3 11.2 13.4 8.8 10.6 13.2 14.7 11.6 17.2 22.9 25.7
6 - 18.1 9.5 12.7 8.8 9.7 13.3 15.3 14.2 17.2 22.5 27.6
7 24.4 17.2 12.4 12.6 8.2 12.1 12.9 13.2 14.3 18.1 22.6 26.2
8 22.3 17.5 13.1 11.2 11.8 10.7 11.8 13 14.8 19 26.2 25.3
9 23.9 19.7 12.2 12.4 11.7 12.1 9.1 12.9 16.1 20.8 24.1 25.6
10 22.8 19.7 13.2 9.8 11.4 13 11.2 13.2 19.8 20.9 23.9 27.6
11 24.6 19.3 13 11.3 13.3 12.9 13.2 10 16.5 19.7 23.4 26.6
12 23.5 18.4 12.2 11.1 11.7 11.2 13 9.4 14.7 20.7 25.2 25.4
13 24.8 17.5 12.8 11.4 13.2 11.8 10.7 11.6 15.2 19.3 24.4 24.6
14 23.1 16.1 16.8 11.6 9.6 11.7 10.2 12.2 16.7 19.7 24.7 25.1
15 22.4 13.8 16.1 11.4 16.6 10.2 11.2 13.7 16.8 21.8 24.3 29.3
16 23 14.7 17 10.9 15 10.6 11.6 12.8 18.2 21.8 25.9 28.5
17 23.9 15.3 16.4 10.7 11.6 12 13 14.1 18.4 21.2 29.9 25.3
18 27.4 18.7 18.3 8.7 10.7 11.8 13.1 14.1 22.3 20.7 29.6 25.4
19 26.9 17.3 15.7 9.5 11.6 10.9 11.8 16.2 21.9 20.7 25.1 25.8
20 23.6 18.9 14.4 10.2 10.7 10.2 11.1 14.3 18 19.4 24.2 24.3
21 21.9 15.6 14.7 10.1 10.7 10 8.2 20.6 17.6 18.9 25.2 25.1
22 20.1 17 13.3 9.7 9.8 8.6 10 16.1 17.6 22.4 24.8 26.7
23 21.6 16.5 17 8.9 10.2 8.4 10.4 16.6 18.7 22.5 23.8 22.7
24 24.5 16.2 14.4 7.2 9.6 9.6 9.4 14.2 17.7 21.8 25.5 20.8
25 22.9 16.2 15.2 9.9 9.5 8.4 11.1 14.2 16.9 21.2 25.4 22.3
26 21.3 16.6 13.1 12.4 10.8 7.4 10.6 16.1 16.9 22.3 24.1 19.7
27 20.5 14.8 13.1 13.4 10.7 10.4 10.9 14.9 17.4 24.4 23.9 22.3
28 23.2 16.7 16.9 14.6 14.3 9.3 14.2 14.1 21.9 23.3 22.8 22.7
29 20.6 12.8 13 15 13.8 17.4 15.6 20 25.6 25.8 22.7
30 18.4 10.3 13.2 14.6 14.1 14.9 15.6 18.8 25.4 25.6 22.1
31 9.8 12.7 12.9 11.1 - 25.3 22.6 |
Partager