Hourly and yearly average

2 views (last 30 days)
Ojo Olusola
Ojo Olusola on 7 Mar 2022
Commented: Arif Hoq on 10 Mar 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 Comment
Arif Hoq
Arif Hoq on 10 Mar 2022
you have severals data with same date. can you please explain which date do you want ?

Sign in to comment.

Sign in to answer this question.

Answers (0)

Categories

Find more on Database Toolbox in Help Center and File Exchange

Tags

Products


Release

R2021a

Community Treasure Hunt

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

Start Hunting!