Hourly and yearly average

1 visualización (últimos 30 días)
Ojo Olusola
Ojo Olusola el 7 de Mzo. de 2022
Comentada: Arif Hoq el 10 de Mzo. de 2022
Ran in:
X = readtable('sample1.xlsx')
X = 3751×103 table
DATE TIME Tc1 Tc2 Tc3 Tc4 Tc5 Tc6 Tc7 Tc8 Tc9 Tc10 Var13 DATE_1 TIME_1 Tc1_1 Tc2_1 Tc3_1 Tc4_1 Tc5_1 Tc6_1 Tc7_1 Tc8_1 Tc9_1 Tc10_1 Var26 DATE_2 TIME_2 Tc1_2 Tc2_2 Tc3_2 Tc4_2 Tc5_2 Tc6_2 Tc7_2 Tc8_2 Tc9_2 Tc10_2 Var39 DATE_3 TIME_3 Tc1_3 Tc2_3 Tc3_3 Tc4_3 Tc5_3 Tc6_3 Tc7_3 Tc8_3 Tc9_3 Tc10_3 Var52 DATE_4 TIME_4 Tc1_4 Tc2_4 Tc3_4 Tc4_4 Tc5_4 Tc6_4 Tc7_4 Tc8_4 Tc9_4 Tc10_4 Var65 DATE_5 TIME_5 Tc1_5 Tc2_5 Tc3_5 Tc4_5 Tc5_5 Tc6_5 Tc7_5 Tc8_5 Tc9_5 Tc10_5 Var78 DATE_6 TIME_6 Tc1_6 Tc2_6 Tc3_6 Tc4_6 Tc5_6 Tc6_6 Tc7_6 Tc8_6 Tc9_6 Tc10_6 Var91 DATE_7 TIME_7 Tc1_7 Tc2_7 Tc3_7 Tc4_7 Tc5_7 Tc6_7 Tc7_7 Tc8_7 Tc9_7 Tc10_7 ___________ _______ _____ ______ ______ ______ ______ ______ ______ ______ ______ ______ _____ ___________ _______ _____ ______ ______ ______ ______ ______ ______ ______ ______ ______ _____ ___________ _______ _____ ______ ______ ______ ______ ______ ______ ______ ______ ______ _____ ___________ _______ _____ ______ ______ ______ ______ ______ ______ ______ ______ ______ _____ ___________ _______ _____ ______ ______ ______ ______ ______ ______ ______ ______ ______ _____ ___________ _______ _____ ______ ______ ______ ______ ______ ______ ______ ______ ______ _____ ___________ _______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ _____ ___________ _______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ 01-Jan-2010 0.3125 26.98 25.298 22.845 21.319 28.685 27.263 24.28 20.875 25.338 29.577 NaN 01-Jul-2010 0.3125 41.43 39.636 38.802 36.856 43.415 41.769 39.056 35.102 39.982 49.144 NaN 01-Jan-2010 0.3125 30.61 28.906 26.827 25.273 32.37 30.904 27.984 24.463 29.014 34.517 NaN 01-Jul-2010 0.3125 37.55 35.802 34.801 32.817 39.42 37.866 36.096 32.151 36.455 45.064 NaN 01-Jan-2010 0.3125 30.86 29.254 28.297 26.376 32.375 31.105 30.838 27.145 30.308 38.2 NaN 01-Jul-2010 0.3125 33.54 32.004 31.303 30.016 34.88 33.75 31.354 28.283 32.481 39.917 NaN 01-Jan-2010 0.3125 32.885 31.33 31.182 29.111 34.273 33.105 34.564 30.701 32.949 43.09 NaN 01-Jul-2010 0.3125 29.393 28.133 28.415 27.591 30.044 29.465 28.704 26.298 29.044 37.333 01-Jan-2010 0.35417 38.05 35.926 31.973 30.248 40.86 38.554 34.166 29.43 35.078 41.098 NaN 01-Jul-2010 0.35417 48.95 46.804 45.773 42.49 51.815 49.465 46.4 41.251 47.04 57.37 NaN 01-Jan-2010 0.35417 41.46 39.318 35.937 33.985 44.315 41.973 37.399 32.61 38.451 45.486 NaN 01-Jul-2010 0.35417 44.13 42.062 40.565 37.646 46.8 44.606 42.235 37.258 42.555 51.886 NaN 01-Jan-2010 0.35417 40.14 38.11 36.37 33.415 42.715 40.597 39.491 34.435 39.181 47.964 NaN 01-Jul-2010 0.35417 38.63 36.836 35.392 33.664 40.615 38.969 35.729 31.898 36.907 44.735 NaN 01-Jan-2010 0.35417 40.4 38.472 37.842 34.563 42.72 40.806 41.334 36.314 40.364 50.58 NaN 01-Jul-2010 0.35417 30.684 29.362 29.466 28.55 31.488 30.787 29.624 27.074 30.203 38.372 01-Jan-2010 0.39583 48.11 45.628 40.333 38.727 51.815 48.793 41.602 36.096 42.822 50.131 NaN 01-Jul-2010 0.39583 54.49 52.08 51.316 46.601 58.015 55.137 52.155 46.043 52.56 63.776 NaN 01-Jan-2010 0.39583 50.89 48.394 44.578 41.779 54.63 51.58 45.896 40.033 46.703 55.504 NaN 01-Jul-2010 0.39583 49.58 47.24 45.671 41.588 52.93 50.192 47.767 41.828 47.911 57.983 NaN 01-Jan-2010 0.39583 48.81 46.442 44.65 40.477 52.23 49.436 47.342 41.251 47.331 57.149 NaN 01-Jul-2010 0.39583 42.58 40.594 38.873 36.564 45.045 43.015 39.766 35.248 40.608 49.21 NaN 01-Jan-2010 0.39583 46.592 44.373 43.693 39.194 49.639 47.143 47.121 41.164 46.539 57.068 NaN 01-Jul-2010 0.39583 32.007 30.617 30.504 29.489 32.981 32.144 30.488 27.789 31.348 39.324 01-Jan-2010 0.4375 54.53 51.828 46.88 44.209 58.785 55.323 48.263 41.929 48.946 58.01 NaN 01-Jul-2010 0.4375 57.78 55.224 54.958 49.133 61.67 58.5 55.806 49.115 56.125 67.891 NaN 01-Jan-2010 0.4375 57.01 54.294 51.158 46.919 61.3 57.81 52.461 45.734 52.889 63.191 NaN 01-Jul-2010 0.4375 53.12 50.612 49.283 44.221 56.89 53.816 51.55 44.979 51.624 62.195 NaN 01-Jan-2010 0.4375 54.32 51.726 49.9 44.871 58.305 55.059 52.096 45.354 52.247 62.671 NaN 01-Jul-2010 0.4375 44.92 42.83 41.216 38.363 47.645 45.407 42.561 37.593 43.076 52.35 NaN 01-Jan-2010 0.4375 51.012 48.581 48.096 42.462 54.589 51.669 51.485 44.799 51.139 61.926 NaN 01-Jul-2010 0.4375 33.022 31.579 31.303 30.204 34.129 33.185 31.245 28.411 32.23 40.151 01-Jan-2010 0.47917 57.48 54.71 50.892 47.004 61.905 58.307 52.224 45.448 52.654 62.781 NaN 01-Jul-2010 0.47917 59.03 56.436 56.612 50.24 63.015 59.769 57.389 50.498 57.691 69.76 NaN 01-Jan-2010 0.47917 59.59 56.806 54.737 49.292 64.05 60.424 55.943 48.798 56.25 67.337 NaN 01-Jul-2010 0.47917 53.93 51.408 50.418 45.028 57.735 54.633 52.626 45.952 52.682 63.518 NaN 01-Jan-2010 0.47917 56.77 54.098 52.439 47.013 60.95 57.548 54.216 47.258 54.437 65.254 NaN 01-Jul-2010 0.47917 45.03 42.964 41.736 38.689 47.695 45.505 43.273 38.27 43.565 53.281 NaN 01-Jan-2010 0.47917 52.756 50.258 49.986 43.886 56.502 53.447 53.217 46.295 52.975 63.941 NaN 01-Jul-2010 0.47917 33.218 31.769 31.49 30.374 34.341 33.385 31.474 28.61 32.425 40.42 01-Jan-2010 0.52083 57.69 54.98 52.34 47.744 61.965 58.487 53.475 46.7 53.898 64.518 NaN 01-Jul-2010 0.52083 58.55 56.016 56.47 50.194 62.385 59.259 57.137 50.406 57.425 69.672 NaN 01-Jan-2010 0.52083 59.03 56.336 55.246 49.405 63.265 59.819 56.298 49.283 56.625 68.043 NaN 01-Jul-2010 0.52083 52.52 50.108 49.425 44.339 56.05 53.168 51.495 45.143 51.505 62.478 NaN 01-Jan-2010 0.52083 55.68 53.122 51.843 46.722 59.575 56.401 53.225 46.635 53.522 64.481 NaN 01-Jul-2010 0.52083 43.87 41.894 41.072 38.118 46.31 44.3 42.709 37.9 42.798 52.819 NaN 01-Jan-2010 0.52083 51.591 49.194 49.118 43.401 55.084 52.232 52.149 45.553 51.807 62.992 NaN 01-Jul-2010 0.52083 32.724 31.308 31.142 30.091 33.763 32.874 31.126 28.35 32.014 40.082 01-Jan-2010 0.5625 54.44 51.972 50.391 46.06 58.11 55.116 51.236 45.097 51.77 62.456 NaN 01-Jul-2010 0.5625 55.58 53.248 53.834 48.495 58.91 56.188 54.45 48.36 54.665 66.993 NaN 01-Jan-2010 0.5625 55.7 53.24 52.873 47.563 59.35 56.372 53.869 47.486 54.156 65.711 NaN 01-Jul-2010 0.5625 49.39 47.182 46.801 42.474 52.41 49.936 48.739 43.019 48.633 59.69 NaN 01-Jan-2010 0.5625 52.68 50.332 49.473 45.055 56.05 53.296 50.57 44.636 50.916 61.871 NaN 01-Jul-2010 0.5625 41.44 39.622 39.199 36.667 43.485 41.791 40.827 36.458 40.714 50.93 NaN 01-Jan-2010 0.5625 48.648 46.451 46.578 41.718 51.641 49.189 49.477 43.518 48.886 60.328 NaN 01-Jul-2010 0.5625 31.652 30.299 30.317 29.393 32.534 31.77 30.261 27.663 31.075 39.175 01-Jan-2010 0.60417 48.59 46.492 45.687 42.48 51.335 49.081 46.225 41.202 46.85 57.335 NaN 01-Jul-2010 0.60417 50.71 48.684 49.349 45.498 53.275 51.165 50.004 44.888 50.064 62.422 NaN 01-Jan-2010 0.60417 49.89 47.79 47.876 43.946 52.64 50.382 48.925 43.619 49.017 60.619 NaN 01-Jul-2010 0.60417 44.93 42.998 42.937 39.694 47.26 45.338 44.763 39.903 44.445 55.583 NaN 01-Jan-2010 0.60417 47.39 45.372 44.988 41.78 49.935 47.841 45.857 40.951 46.181 57.019 NaN 01-Jul-2010 0.60417 38.3 36.672 36.598 34.674 39.87 38.556 38.133 34.336 37.826 48.13 NaN 01-Jan-2010 0.60417 43.627 41.747 42.121 38.644 45.827 44.009 44.986 40.019 43.905 55.725 NaN 01-Jul-2010 0.60417 30.279 29.004 29.244 28.481 30.965 30.358 29.129 26.756 29.851 37.973 01-Jan-2010 0.64583 40.6 38.96 38.872 37.196 42.2 40.862 39.183 35.565 39.729 49.87 NaN 01-Jul-2010 0.64583 44.78 43.11 43.84 41.711 46.455 45.057 44.571 40.59 44.398 56.745 NaN 01-Jan-2010 0.64583 42.12 40.466 40.888 38.812 43.755 42.389 42.094 38.152 41.758 53.381 NaN 01-Jul-2010 0.64583 39.43 37.822 38.112 36.129 40.95 39.676 39.898 36.037 39.208 50.474 NaN 01-Jan-2010 0.64583 40.53 38.914 39.133 37.317 42.07 40.78 40.126 36.396 40.027 50.997 NaN 01-Jul-2010 0.64583 34.1 32.714 33.044 31.907 35.065 34.235 34.461 31.4 33.863 44.245 NaN 01-Jan-2010 0.64583 37.921 36.406 37.009 35.182 39.209 38.121 39.641 35.862 38.079 50.255 NaN 01-Jul-2010 0.64583 28.487 27.311 27.827 27.263 28.927 28.517 27.674 25.579 28.233 36.412 01-Jan-2010 0.6875 29.28 28.094 28.706 28.082 29.745 29.315 30 27.574 29.171 39.1 NaN 01-Jul-2010 0.6875 38.4 37.086 37.92 37.41 39.185 38.499 38.831 35.961 38.261 50.606 NaN 01-Jan-2010 0.6875 32.06 30.856 31.615 31.101 32.57 32.104 33.716 31.03 32.069 43.827 NaN 01-Jul-2010 0.6875 33.49 32.206 32.842 32.063 34.2 33.574 34.64 31.773 33.435 44.81 NaN 01-Jan-2010 0.6875 32.04 30.82 31.506 30.945 32.59 32.092 33.159 30.521 31.982 43.133 NaN 01-Jul-2010 0.6875 30.14 28.966 29.654 29.163 30.575 30.169 31.043 28.615 30.061 40.542 NaN 01-Jan-2010 0.6875 32.099 30.904 31.701 31.224 32.586 32.138 34.02 31.314 32.138 44.217 NaN 01-Jul-2010 0.6875 26.658 25.577 26.354 25.968 26.861 26.641 26.236 24.396 26.553 34.836 01-Jan-2010 0.72917 22.7 21.698 22.692 22.117 22.705 22.643 23.342 21.594 22.698 30.983 NaN 01-Jul-2010 0.72917 32.27 31.22 32.177 32.626 32.395 32.237 33.405 31.327 32.257 44.382 NaN 01-Jan-2010 0.72917 25.46 24.456 25.448 25.247 25.47 25.404 27.677 25.601 25.461 36.459 NaN 01-Jul-2010 0.72917 28 26.958 27.891 27.825 28.105 27.963 29.709 27.583 27.997 39.189 NaN 01-Jan-2010 0.72917 25.96 24.95 25.93 25.767 25.985 25.907 27.469 25.504 25.957 36.348 NaN 01-Jul-2010 0.72917 26.88 25.85 26.793 26.649 26.955 26.837 28.372 26.336 26.873 37.483 NaN 01-Jan-2010 0.72917 27.937 26.925 27.908 28.006 27.966 27.885 29.885 27.814 27.938 39.524 NaN 01-Jul-2010 0.72917 25.09 24.078 25.045 24.758 25.12 25.038 24.956 23.303 25.076 33.369 02-Jan-2010 0.3125 27.52 25.796 23.203 21.583 29.33 27.824 25.19 21.571 25.922 30.49 NaN 02-Jul-2010 0.3125 40.69 38.894 37.683 35.996 42.68 41.03 37.459 33.667 38.878 47.193 NaN 02-Jan-2010 0.3125 30.39 28.66 26.468 24.805 32.215 30.697 28.146 24.468 28.87 34.487 NaN 02-Jul-2010 0.3125 32.26 30.774 30.264 28.974 33.475 32.445 30.641 27.639 31.421 39.044 NaN 02-Jan-2010 0.3125 30.7 29.116 28.317 26.378 32.16 30.934 31.051 27.362 30.284 38.502 NaN 02-Jul-2010 0.3125 28.57 27.256 27.224 26.204 29.355 28.669 27.281 24.817 28.043 35.267 NaN 02-Jan-2010 0.3125 32.542 31.007 30.575 28.888 33.879 32.751 32.446 28.991 32.058 40.812 NaN 02-Jul-2010 0.3125 31.711 30.232 29.867 28.404 32.91 31.893 31.162 27.983 31.145 39.481 02-Jan-2010 0.35417 38.97 36.792 32.959 30.846 41.915 39.501 35.929 30.846 36.375 42.978 NaN 02-Jul-2010 0.35417 47.82 45.696 44.042 41.385 50.63 48.324 44.163 39.306 45.277 54.743 NaN 02-Jan-2010 0.35417 41.55 39.374 35.912 33.803 44.49 42.08 37.835 32.866 38.654 45.8 NaN 02-Jul-2010 0.35417 37.7 35.942 34.73 32.905 39.595 38.021 35.53 31.686 36.312 44.443 NaN 02-Jan-2010 0.35417 40.05 38.044 36.635 33.513 42.565 40.495 40.039 34.943 39.464 48.659 NaN 02-Jul-2010 0.35417 33.03 31.476 30.635 29.284 34.415 33.249 30.859 27.731 31.932 39.137 NaN 02-Jan-2010 0.35417 40.08 38.166 37.031 34.315 42.365 40.479 39.42 34.753 39.214 48.496 NaN 02-Jul-2010 0.35417 36.041 34.326 33.31 31.369 37.83 36.341 34.843 30.969 35.056 43.446 02-Jan-2010 0.39583 49.95 47.396 42.252 40.223 53.835 50.669 43.808 37.978 44.741 52.662 NaN 02-Jul-2010 0.39583 53.48 51.09 49.496 45.617 56.955 54.117 49.954 44.143 50.678 61.213 NaN 02-Jan-2010 0.39583 51.29 48.742 44.753 41.801 55.16 52.006 46.445 40.378 47.089 55.932 NaN 02-Jul-2010 0.39583 42.08 40.104 38.472 36.078 44.52 42.51 39.664 35.108 40.311 49.009 NaN 02-Jan-2010 0.39583 49.68 47.266 45.865 41.084 53.215 50.329 49.018 42.614 48.822 58.964 NaN 02-Jul-2010 0.39583 37.46 35.678 34.163 32.431 39.415 37.793 34.762 30.941 35.815 43.414 NaN 02-Jan-2010 0.39583 47.271 45.002 43.405 39.545 50.444 47.848 45.925 40.15 45.913 55.702 NaN 02-Jul-2010 0.39583 40.04 38.11 36.615 34.136 42.365 40.447 38.531 33.972 38.734 47.438 02-Jan-2010 0.4375 56.08 53.304 48.429 45.358 60.52 56.91 50.019 43.388 50.502 59.96 NaN 02-Jul-2010 0.4375 56.61 54.09 52.937 48.099 60.41 57.312 53.476 47.134 54.003 65.228 NaN 02-Jan-2010 0.4375 57.43 54.66 51.196 46.947 61.855 58.257 52.739 45.856 53.084 63.323 NaN 02-Jul-2010 0.4375 44.15 42.086 40.479 37.703 46.81 44.624 41.897 37.001 42.382 51.549 NaN 02-Jan-2010 0.4375 55.57 52.912 51.639 45.761 59.715 56.341 54.199 47.072 54.253 64.961 NaN 02-Jul-2010 0.4375 40.51 38.58 36.762 34.672 42.835 40.917 37.706 33.389 38.596 46.684 NaN 02-Jan-2010 0.4375 51.823 49.331 47.564 42.874 55.553 52.511 50.054 43.584 50.12 60.286 NaN 02-Jul-2010 0.4375 42.551 40.496 38.79 35.952 45.19 43.021 40.873 35.909 41.064 50.023 02-Jan-2010 0.47917 58.74 55.898 51.98 47.839 63.345 59.603 53.455 46.436 53.765 64.09 NaN 02-Jul-2010 0.47917 57.79 55.244 54.631 49.227 61.655 58.505 55.152 48.62 55.596 67.242 NaN 02-Jan-2010 0.47917 60.14 57.302 54.829 49.468 64.735 61.001 56.137 48.876 56.405 67.416 NaN 02-Jul-2010 0.47917 44.35 42.3 41.003 38.047 46.975 44.817 42.601 37.654 42.888 52.443 NaN 02-Jan-2010 0.47917 58.29 55.538 54.379 48.077 62.67 59.108 56.422 49.056 56.582 67.648 NaN 02-Jul-2010 0.47917 41.6 39.632 37.842 35.597 44.02 42.026 38.876 34.409 39.68 48.061 NaN 02-Jan-2010 0.47917 53.889 51.31 49.534 44.508 57.836 54.62 51.837 45.117 51.958 62.348 NaN 02-Jul-2010 0.47917 43.422 41.339 39.64 36.716 46.129 43.905 41.638 36.597 41.867 50.956
The Time before conversion is 11 hours daily from 2010 - 2020 given as 7:30, 8:30, 9:30, ..., 17:30. I want the data to be hourly average (11 hours) and yearly average (11 years). I need help please.
  1 comentario
Arif Hoq
Arif Hoq el 10 de Mzo. de 2022
you have severals data with same date. can you please explain which date do you want ?

Iniciar sesión para comentar.

Iniciar sesión para responder a esta pregunta.

Respuestas (0)

Categorías

Más información sobre Database Toolbox en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2021a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by