Value w.r.t to time

3 ビュー (過去 30 日間)
Mohana
Mohana 2011 年 12 月 27 日
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 件のコメント
TAB
TAB 2011 年 12 月 27 日
Please formate your data in Rows and column to make it clear.
Jan
Jan 2011 年 12 月 27 日
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.

サインインしてコメントする。

採用された回答

bym
bym 2011 年 12 月 27 日
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
  1 件のコメント
Mohana
Mohana 2011 年 12 月 27 日
Hi,
Thanks for the perfect answer. Actually i did'nt get the idea of inputting the blank output as input. Really a perfect answer. Actually i was doing it manually in excel after failing to write a matlab code. Thanks once again.
Kind regards.
Mohan.

サインインしてコメントする。

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeImages についてさらに検索

タグ

製品

Community Treasure Hunt

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

Start Hunting!

Translated by