Value w.r.t to time

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

[TAB]

Please formate your data in Rows and column to make it clear.

[Jan]

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.

Answer 1

[bym]

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

[Mohana]

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.