The input tables for this example are the output tables from the DWT function example:
- DWT Example Output Table dwt_coef_table
- DWT Example Meta Table dwt_meta_table
This example reconstructs the input to the DWT function example.
city | waveletid | waveletcomponent | temp_f | pressure_mbar | dewpoint_f |
---|---|---|---|---|---|
Asheville | 1 | A2 | 69.4540094027039 | 2040.77288421713 | 57.6536778800559 |
Asheville | 2 | A2 | 69.3002350407891 | 2040.65034008677 | 57.5918028045736 |
Asheville | 3 | A2 | 65.9380138856981 | 2040.05868411008 | 56.0059210207892 |
Asheville | 4 | A2 | 65.3687921302244 | 2042.91209425196 | 55.7742876107938 |
Asheville | 5 | A2 | 84.1422926636037 | 2041.64689638287 | 58.2670431589452 |
Asheville | 6 | A2 | 90.1564867623684 | 2038.66915729816 | 57.0999120742162 |
Asheville | 7 | A2 | 76.6292062444649 | 2041.64172802492 | 57.8025718338419 |
Asheville | 8 | A2 | 71.1744954076401 | 2041.9750345768 | 58.0529007176853 |
Asheville | 9 | D2 | 0.166265877365284 | 0.13357902559369 | 0.0802319348951208 |
Asheville | 10 | D2 | -0.0236532579869611 | -0.0152743495649474 | 0.0345987263105307 |
Asheville | 11 | D2 | -1.08576122940834 | -0.392631330035556 | -0.529214267460297 |
Asheville | 12 | D2 | -0.73178478327581 | 1.58931398112088 | 0.691473086723903 |
Asheville | 13 | D2 | 3.26344510251065 | -1.20694916477225 | -0.201106157323093 |
Asheville | 14 | D2 | -0.748381926835563 | 0.14607141087663 | -0.125329090319905 |
Asheville | 15 | D2 | -1.40116169247464 | 0.055816120120312 | 0.0529007176852296 |
Asheville | 16 | D2 | -0.841593172362995 | 0.466498721551716 | 0.197428166158137 |
Asheville | 17 | D1 | 0.306186217847898 | 0.183704255459304 | 0.122473786334524 |
Asheville | 18 | D1 | 0 | -0.206134749187356 | -0.08365170265035 |
Asheville | 19 | D1 | 0.0224122024304982 | 0.12248196238869 | -0.070710273508908 |
Asheville | 20 | D1 | -0.0258815095837281 | -0.161303239447761 | -0.0353547995796646 |
Asheville | 21 | D1 | -0.917630271917533 | 0.0482845002277372 | -0.470022832702245 |
Asheville | 22 | D1 | -0.309652827602825 | 0.241459877385864 | 0.15782975392192 |
Asheville | 23 | D1 | 0.328598420278396 | 0.200102937320878 | 0.064705435625207 |
Asheville | 24 | D1 | 0.476955377862531 | -0.244956026246825 | 0.109533031542659 |
Asheville | 25 | D1 | 0.757261434825846 | -0.161273761730968 | -0.10006023520487 |
Asheville | 26 | D1 | -0.472558544124134 | -0.0129456913733748 | -0.167302977780198 |
Asheville | 27 | D1 | -0.219066556743464 | 0.0742190413474191 | 0.109533705892233 |
Asheville | 28 | D1 | -0.0612381515206977 | 0.0388133785289142 | 0 |
Asheville | 29 | D1 | -0.489897481353545 | -0.0612222930706707 | 0 |
Brownsville | 1 | A2 | 69.8494278769203 | 2040.77746121021 | 57.7241015517973 |
Brownsville | 2 | A2 | 69.7081531839714 | 2040.64241250221 | 57.6839970736215 |
Brownsville | 3 | A2 | 66.3771886064812 | 2040.03445096574 | 56.3260179778376 |
Brownsville | 4 | A2 | 65.7888893814753 | 2042.77748885299 | 56.2960582953676 |
Brownsville | 5 | A2 | 84.8067964112814 | 2041.43991970379 | 59.0415953806383 |
Brownsville | 6 | A2 | 90.648563090627 | 2038.63824306649 | 57.7977881374318 |
Brownsville | 7 | A2 | 77.1037579029709 | 2041.37803566704 | 58.4437490787264 |
Brownsville | 8 | A2 | 71.5761715904181 | 2041.75457522267 | 58.5050244475344 |
Brownsville | 9 | D2 | 0.174190741199549 | 0.125651441035643 | 0.0448557763120334 |
Brownsville | 10 | D2 | 0.0492226945782548 | -0.0881776255051818 | -0.00122619573711802 |
... | ... | ... | ... | ... | ... |
city | meta | content |
---|---|---|
Asheville | blocklength | 8, 8, 13 |
Asheville | length | 24 |
Asheville | waveletname | db2 |
Asheville | lowpassfilter | -0.1294095225512604, 0.2241438680420134, 0.836516303737808, 0.4829629131445342 |
Asheville | highpassfilter | -0.4829629131445342, 0.836516303737808, -0.2241438680420134, -0.1294095225512604 |
Asheville | ilowpassfilter | 0.4829629131445342, 0.836516303737808, 0.2241438680420134, -0.1294095225512604 |
Asheville | ihighpassfilter | -0.1294095225512604, -0.2241438680420134, 0.836516303737808, -0.4829629131445342 |
Asheville | level | 2 |
Asheville | extensionmode | sym |
Brownsville | blocklength | 8, 8, 13 |
Brownsville | length | 24 |
Brownsville | waveletname | db2 |
Brownsville | lowpassfilter | -0.1294095225512604, 0.2241438680420134, 0.836516303737808, 0.4829629131445342 |
Brownsville | highpassfilter | -0.4829629131445342, 0.836516303737808, -0.2241438680420134, -0.1294095225512604 |
Brownsville | ilowpassfilter | 0.4829629131445342, 0.836516303737808, 0.2241438680420134, -0.1294095225512604 |
Brownsville | ihighpassfilter | -0.1294095225512604, -0.2241438680420134, 0.836516303737808, -0.4829629131445342 |
Brownsville | level | 2 |
... | ... | ... |