Value w.r.t to time
2 views (last 30 days)
Show older comments
Hi,
I have a dataset as shown below which is my input.
0 3
1 1
2 1
39 1
105 1
106 1
107 1
114 6
115 6
116 3
117 1
120 1
127 3
128 5
129 8
130 6
131 4
132 6
133 6
134 5
135 5
136 1
141 1
148 2
149 1
150 1
151 1
152 2
153 1
154 1
155 1
156 1
157 1
159 1
219 1
232 1
233 1
234 1
235 3
236 1
237 1
238 1
251 1
323 1
329 1
335 1
407 1
414 1
439 1
531 1
634 1
637 1
1039 1
1040 4
1041 1
1042 1
1047 1
1057 1
1058 1
1059 1
1101 1
1102 1
1103 3
1104 4
1105 5
1106 6
1107 3
1108 3
1109 2
1110 2
1111 1
1112 1
1113 1
1116 1
1119 1
1120 2
1121 1
1122 1
1123 1
1125 1
1130 1
1132 4
1133 3
1134 3
1135 3
1136 1
1137 1
1138 1
1139 1
1143 1
1147 1
1151 1
1154 1
1155 1
1156 1
1157 1
1158 1
1159 1
1201 1
1238 1
1439 1
1620 1
1621 7
1622 5
1623 1
1651 1
1652 1
1654 1
1655 1
1656 1
1657 1
1701 1
1708 1
1724 1
1725 1
1726 1
1728 1
1741 1
1755 1
1836 1
1959 1
2050 1
2052 1
2053 3
The output should be like this.
0000 3
0001 1
0002 1
0003 0
0004 0
0005 0
0006 0
0007 0
0008 0
0009 0
0010 0
0011 0
0012 0
0013 0
0014 0
0015 0
0016 0
0017 0
0018 0
0019 0
0020 0
0021 0
0022 0
0023 0
0024 0
0025 0
0026 0
0027 0
0028 0
0029 0
0030 0
0031 0
0032 0
0033 0
0034 0
0035 0
0036 0
0037 0
0038 0
0039 1
0040 0
0041 0
0042 0
0043 0
0044 0
0045 0
0046 0
0047 0
0048 0
0049 0
0050 0
0051 0
0052 0
0053 0
0054 0
0055 0
0056 0
0057 0
0058 0
0059 0
0100 0
0101 0
0102 0
0103 0
0104 0
0105 1
0106 1
0107 1
0108 0
0109 0
0110 0
0111 0
0112 0
0113 0
0114 6
0115 6
0116 3
0117 1
0118 0
0119 0
0120 1
0121 0
0122 0
0123 0
0124 0
0125 0
0126 0
0127 3
0128 5
0129 8
0130 6
0131 4
0132 6
0133 6
0134 5
0135 5
0136 1
0137 0
0138 0
0139 0
0140 0
0141 1
0142 0
0143 0
0144 0
0145 0
0146 0
0147 0
0148 2
0149 1
0150 1
0151 1
0152 2
0153 1
0154 1
0155 1
0156 1
0157 1
0158 0
0159 1
0200 0
0201 0
0202 0
0203 0
0204 0
0205 0
0206 0
0207 0
0208 0
0209 0
0210 0
0211 0
0212 0
0213 0
0214 0
0215 0
0216 0
0217 0
0218 0
0219 1
0220 0
0221 0
0222 0
0223 0
0224 0
0225 0
0226 0
0227 0
0228 0
0229 0
0230 0
0231 0
0232 1
0233 1
0234 1
0235 3
0236 1
0237 1
0238 1
0239 0
0240 0
0241 0
0242 0
0243 0
0244 0
0245 0
0246 0
0247 0
0248 0
0249 0
0250 0
0251 1
0252 0
0253 0
0254 0
0255 0
0256 0
0257 0
0258 0
0259 0
0300 0
0301 0
0302 0
0303 0
0304 0
0305 0
0306 0
0307 0
0308 0
0309 0
0310 0
0311 0
0312 0
0313 0
0314 0
0315 0
0316 0
0317 0
0318 0
0319 0
0320 0
0321 0
0322 0
0323 1
0324 0
0325 0
0326 0
0327 0
0328 0
0329 1
0330 0
0331 0
0332 0
0333 0
0334 0
0335 1
0336 0
0337 0
0338 0
0339 0
0340 0
0341 0
0342 0
0343 0
0344 0
0345 0
0346 0
0347 0
0348 0
0349 0
0350 0
0351 0
0352 0
0353 0
0354 0
0355 0
0356 0
0357 0
0358 0
0359 0
0400 0
0401 0
0402 0
0403 0
0404 0
0405 0
0406 0
0407 1
0408 0
0409 0
0410 0
0411 0
0412 0
0413 0
0414 1
0415 0
0416 0
0417 0
0418 0
0419 0
0420 0
0421 0
0422 0
0423 0
0424 0
0425 0
0426 0
0427 0
0428 0
0429 0
0430 0
0431 0
0432 0
0433 0
0434 0
0435 0
0436 0
0437 0
0438 0
0439 1
0440 0
0441 0
0442 0
0443 0
0444 0
0445 0
0446 0
0447 0
0448 0
0449 0
0450 0
0451 0
0452 0
0453 0
0454 0
0455 0
0456 0
0457 0
0458 0
0459 0
0500 0
0501 0
0502 0
0503 0
0504 0
0505 0
0506 0
0507 0
0508 0
0509 0
0510 0
0511 0
0512 0
0513 0
0514 0
0515 0
0516 0
0517 0
0518 0
0519 0
0520 0
0521 0
0522 0
0523 0
0524 0
0525 0
0526 0
0527 0
0528 0
0529 0
0530 0
0531 1
0532 0
0533 0
0534 0
0535 0
0536 0
0537 0
0538 0
0539 0
0540 0
0541 0
0542 0
0543 0
0544 0
0545 0
0546 0
0547 0
0548 0
0549 0
0550 0
0551 0
0552 0
0553 0
0554 0
0555 0
0556 0
0557 0
0558 0
0559 0
0600 0
0601 0
0602 0
0603 0
0604 0
0605 0
0606 0
0607 0
0608 0
0609 0
0610 0
0611 0
0612 0
0613 0
0614 0
0615 0
0616 0
0617 0
0618 0
0619 0
0620 0
0621 0
0622 0
0623 0
0624 0
0625 0
0626 0
0627 0
0628 0
0629 0
0630 0
0631 0
0632 0
0633 0
0634 1
0635 0
0636 0
0637 1
0638 0
0639 0
0640 0
0641 0
0642 0
0643 0
0644 0
0645 0
0646 0
0647 0
0648 0
0649 0
0650 0
0651 0
0652 0
0653 0
0654 0
0655 0
0656 0
0657 0
0658 0
0659 0
0700 0
0701 0
0702 0
0703 0
0704 0
0705 0
0706 0
0707 0
0708 0
0709 0
0710 0
0711 0
0712 0
0713 0
0714 0
0715 0
0716 0
0717 0
0718 0
0719 0
0720 0
0721 0
0722 0
0723 0
0724 0
0725 0
0726 0
0727 0
0728 0
0729 0
0730 0
0731 0
0732 0
0733 0
0734 0
0735 0
0736 0
0737 0
0738 0
0739 0
0740 0
0741 0
0742 0
0743 0
0744 0
0745 0
0746 0
0747 0
0748 0
0749 0
0750 0
0751 0
0752 0
0753 0
0754 0
0755 0
0756 0
0757 0
0758 0
0759 0
0800 0
0801 0
0802 0
0803 0
0804 0
0805 0
0806 0
0807 0
0808 0
0809 0
0810 0
0811 0
0812 0
0813 0
0814 0
0815 0
0816 0
0817 0
0818 0
0819 0
0820 0
0821 0
0822 0
0823 0
0824 0
0825 0
0826 0
0827 0
0828 0
0829 0
0830 0
0831 0
0832 0
0833 0
0834 0
0835 0
0836 0
0837 0
0838 0
0839 0
0840 0
0841 0
0842 0
0843 0
0844 0
0845 0
0846 0
0847 0
0848 0
0849 0
0850 0
0851 0
0852 0
0853 0
0854 0
0855 0
0856 0
0857 0
0858 0
0859 0
0900 0
0901 0
0902 0
0903 0
0904 0
0905 0
0906 0
0907 0
0908 0
0909 0
0910 0
0911 0
0912 0
0913 0
0914 0
0915 0
0916 0
0917 0
0918 0
0919 0
0920 0
0921 0
0922 0
0923 0
0924 0
0925 0
0926 0
0927 0
0928 0
0929 0
0930 0
0931 0
0932 0
0933 0
0934 0
0935 0
0936 0
0937 0
0938 0
0939 0
0940 0
0941 0
0942 0
0943 0
0944 0
0945 0
0946 0
0947 0
0948 0
0949 0
0950 0
0951 0
0952 0
0953 0
0954 0
0955 0
0956 0
0957 0
0958 0
0959 0
1000 0
1001 0
1002 0
1003 0
1004 0
1005 0
1006 0
1007 0
1008 0
1009 0
1010 0
1011 0
1012 0
1013 0
1014 0
1015 0
1016 0
1017 0
1018 0
1019 0
1020 0
1021 0
1022 0
1023 0
1024 0
1025 0
1026 0
1027 0
1028 0
1029 0
1030 0
1031 0
1032 0
1033 0
1034 0
1035 0
1036 0
1037 0
1038 0
1039 1
1040 4
1041 1
1042 1
1043 0
1044 0
1045 0
1046 0
1047 1
1048 0
1049 0
1050 0
1051 0
1052 0
1053 0
1054 0
1055 0
1056 0
1057 1
1058 1
1059 1
1100 0
1101 1
1102 1
1103 3
1104 4
1105 5
1106 6
1107 3
1108 3
1109 2
1110 2
1111 1
1112 1
1113 1
1114 0
1115 0
1116 1
1117 0
1118 0
1119 1
1120 2
1121 1
1122 1
1123 1
1124 0
1125 1
1126 0
1127 0
1128 0
1129 0
1130 1
1131 0
1132 4
1133 3
1134 3
1135 3
1136 1
1137 1
1138 1
1139 1
1140 0
1141 0
1142 0
1143 1
1144 0
1145 0
1146 0
1147 1
1148 0
1149 0
1150 0
1151 1
1152 0
1153 0
1154 1
1155 1
1156 1
1157 1
1158 1
1159 1
1200 0
1201 1
1202 0
1203 0
1204 0
1205 0
1206 0
1207 0
1208 0
1209 0
1210 0
1211 0
1212 0
1213 0
1214 0
1215 0
1216 0
1217 0
1218 0
1219 0
1220 0
1221 0
1222 0
1223 0
1224 0
1225 0
1226 0
1227 0
1228 0
1229 0
1230 0
1231 0
1232 0
1233 0
1234 0
1235 0
1236 0
1237 0
1238 1
1239 0
1240 0
1241 0
1242 0
1243 0
1244 0
1245 0
1246 0
1247 0
1248 0
1249 0
1250 0
1251 0
1252 0
1253 0
1254 0
1255 0
1256 0
1257 0
1258 0
1259 0
1300 0
1301 0
1302 0
1303 0
1304 0
1305 0
1306 0
1307 0
1308 0
1309 0
1310 0
1311 0
1312 0
1313 0
1314 0
1315 0
1316 0
1317 0
1318 0
1319 0
1320 0
1321 0
1322 0
1323 0
1324 0
1325 0
1326 0
1327 0
1328 0
1329 0
1330 0
1331 0
1332 0
1333 0
1334 0
1335 0
1336 0
1337 0
1338 0
1339 0
1340 0
1341 0
1342 0
1343 0
1344 0
1345 0
1346 0
1347 0
1348 0
1349 0
1350 0
1351 0
1352 0
1353 0
1354 0
1355 0
1356 0
1357 0
1358 0
1359 0
1400 0
1401 0
1402 0
1403 0
1404 0
1405 0
1406 0
1407 0
1408 0
1409 0
1410 0
1411 0
1412 0
1413 0
1414 0
1415 0
1416 0
1417 0
1418 0
1419 0
1420 0
1421 0
1422 0
1423 0
1424 0
1425 0
1426 0
1427 0
1428 0
1429 0
1430 0
1431 0
1432 0
1433 0
1434 0
1435 0
1436 0
1437 0
1438 0
1439 1
1440 0
1441 0
1442 0
1443 0
1444 0
1445 0
1446 0
1447 0
1448 0
1449 0
1450 0
1451 0
1452 0
1453 0
1454 0
1455 0
1456 0
1457 0
1458 0
1459 0
1500 0
1501 0
1502 0
1503 0
1504 0
1505 0
1506 0
1507 0
1508 0
1509 0
1510 0
1511 0
1512 0
1513 0
1514 0
1515 0
1516 0
1517 0
1518 0
1519 0
1520 0
1521 0
1522 0
1523 0
1524 0
1525 0
1526 0
1527 0
1528 0
1529 0
1530 0
1531 0
1532 0
1533 0
1534 0
1535 0
1536 0
1537 0
1538 0
1539 0
1540 0
1541 0
1542 0
1543 0
1544 0
1545 0
1546 0
1547 0
1548 0
1549 0
1550 0
1551 0
1552 0
1553 0
1554 0
1555 0
1556 0
1557 0
1558 0
1559 0
1600 0
1601 0
1602 0
1603 0
1604 0
1605 0
1606 0
1607 0
1608 0
1609 0
1610 0
1611 0
1612 0
1613 0
1614 0
1615 0
1616 0
1617 0
1618 0
1619 0
1620 1
1621 7
1622 5
1623 1
1624 0
1625 0
1626 0
1627 0
1628 0
1629 0
1630 0
1631 0
1632 0
1633 0
1634 0
1635 0
1636 0
1637 0
1638 0
1639 0
1640 0
1641 0
1642 0
1643 0
1644 0
1645 0
1646 0
1647 0
1648 0
1649 0
1650 0
1651 1
1652 1
1653 0
1654 1
1655 1
1656 1
1657 1
1658 0
1659 0
1700 0
1701 1
1702 0
1703 0
1704 0
1705 0
1706 0
1707 0
1708 1
1709 0
1710 0
1711 0
1712 0
1713 0
1714 0
1715 0
1716 0
1717 0
1718 0
1719 0
1720 0
1721 0
1722 0
1723 0
1724 1
1725 1
1726 1
1727 0
1728 1
1729 0
1730 0
1731 0
1732 0
1733 0
1734 0
1735 0
1736 0
1737 0
1738 0
1739 0
1740 0
1741 1
1742 0
1743 0
1744 0
1745 0
1746 0
1747 0
1748 0
1749 0
1750 0
1751 0
1752 0
1753 0
1754 0
1755 1
1756 0
1757 0
1758 0
1759 0
1800 0
1801 0
1802 0
1803 0
1804 0
1805 0
1806 0
1807 0
1808 0
1809 0
1810 0
1811 0
1812 0
1813 0
1814 0
1815 0
1816 0
1817 0
1818 0
1819 0
1820 0
1821 0
1822 0
1823 0
1824 0
1825 0
1826 0
1827 0
1828 0
1829 0
1830 0
1831 0
1832 0
1833 0
1834 0
1835 0
1836 1
1837 0
1838 0
1839 0
1840 0
1841 0
1842 0
1843 0
1844 0
1845 0
1846 0
1847 0
1848 0
1849 0
1850 0
1851 0
1852 0
1853 0
1854 0
1855 0
1856 0
1857 0
1858 0
1859 0
1900 0
1901 0
1902 0
1903 0
1904 0
1905 0
1906 0
1907 0
1908 0
1909 0
1910 0
1911 0
1912 0
1913 0
1914 0
1915 0
1916 0
1917 0
1918 0
1919 0
1920 0
1921 0
1922 0
1923 0
1924 0
1925 0
1926 0
1927 0
1928 0
1929 0
1930 0
1931 0
1932 0
1933 0
1934 0
1935 0
1936 0
1937 0
1938 0
1939 0
1940 0
1941 0
1942 0
1943 0
1944 0
1945 0
1946 0
1947 0
1948 0
1949 0
1950 0
1951 0
1952 0
1953 0
1954 0
1955 0
1956 0
1957 0
1958 0
1959 1
2000 0
2001 0
2002 0
2003 0
2004 0
2005 0
2006 0
2007 0
2008 0
2009 0
2010 0
2011 0
2012 0
2013 0
2014 0
2015 0
2016 0
2017 0
2018 0
2019 0
2020 0
2021 0
2022 0
2023 0
2024 0
2025 0
2026 0
2027 0
2028 0
2029 0
2030 0
2031 0
2032 0
2033 0
2034 0
2035 0
2036 0
2037 0
2038 0
2039 0
2040 0
2041 0
2042 0
2043 0
2044 0
2045 0
2046 0
2047 0
2048 0
2049 0
2050 1
2051 0
2052 1
2053 3
2054 0
2055 0
2056 0
2057 0
2058 0
2059 0
2100 0
2101 0
2102 0
2103 0
2104 0
2105 0
2106 0
2107 0
2108 0
2109 0
2110 0
2111 0
2112 0
2113 0
2114 0
2115 0
2116 0
2117 0
2118 0
2119 0
2120 0
2121 0
2122 0
2123 0
2124 0
2125 0
2126 0
2127 0
2128 0
2129 0
2130 0
2131 0
2132 0
2133 0
2134 0
2135 0
2136 0
2137 0
2138 0
2139 0
2140 0
2141 0
2142 0
2143 0
2144 0
2145 0
2146 0
2147 0
2148 0
2149 0
2150 0
2151 0
2152 0
2153 0
2154 0
2155 0
2156 0
2157 0
2158 0
2159 0
2200 0
2201 0
2202 0
2203 0
2204 0
2205 0
2206 0
2207 0
2208 0
2209 0
2210 0
2211 0
2212 0
2213 0
2214 0
2215 0
2216 0
2217 0
2218 0
2219 0
2220 0
2221 0
2222 0
2223 0
2224 0
2225 0
2226 0
2227 0
2228 0
2229 0
2230 0
2231 0
2232 0
2233 0
2234 0
2235 0
2236 0
2237 0
2238 0
2239 0
2240 0
2241 0
2242 0
2243 0
2244 0
2245 0
2246 0
2247 0
2248 0
2249 0
2250 0
2251 0
2252 0
2253 0
2254 0
2255 0
2256 0
2257 0
2258 0
2259 0
2300 0
2301 0
2302 0
2303 0
2304 0
2305 0
2306 0
2307 0
2308 0
2309 0
2310 0
2311 0
2312 0
2313 0
2314 0
2315 0
2316 0
2317 0
2318 0
2319 0
2320 0
2321 0
2322 0
2323 0
2324 0
2325 0
2326 0
2327 0
2328 0
2329 0
2330 0
2331 0
2332 0
2333 0
2334 0
2335 0
2336 0
2337 0
2338 0
2339 0
2340 0
2341 0
2342 0
2343 0
2344 0
2345 0
2346 0
2347 0
2348 0
2349 0
2350 0
2351 0
2352 0
2353 0
2354 0
2355 0
2356 0
2357 0
2358 0
2359 0
0000 0
In the input the first column represents time and the second column represents the value w.r.t. Actually i want this to be written over a period of 24 hours time (as shown in the output), if there are no values then with time the corresponding value would be zero otherwise the value of the time. I have tried, but not succeeded could anyone suggest a code.
Thanks
Mohan
2 Comments
Jan
on 27 Dec 2011
Please use a more abstract representation of the displayed array. A contributor, who reads your question, is bored by the pile of numbers. This floods the question with irrelvant information - the actual values do not matter for the creation of the answer. It would be better, if you explain the structure of the data and create is e.g. using ZEROS or RAND.
Accepted Answer
bym
on 27 Dec 2011
in,out %starting values
in =
1 1
3 2
5 3
7 4
9 5
out =
1 0
2 0
3 0
4 0
5 0
6 0
7 0
8 0
9 0
10 0
mask = ismember(out(:,1),in(:,1));
out(mask,2)=in(:,2)
out =
1 1
2 0
3 2
4 0
5 3
6 0
7 4
8 0
9 5
10 0
More Answers (0)
See Also
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!