In [1]:
from charistools.hypsometry import Hypsometry
import numpy as np

In [2]:
filename = '/vagrant/source/charistools/test/test.sca_by_elev.txt'
hyps = Hypsometry(filename=filename)
hyps


Out[2]:
<charistools.hypsometry.Hypsometry instance at 0x7f72e56c6f80>

In [3]:
hyps.data


Out[3]:
1400.0 1500.0 1600.0 1700.0 1800.0 1900.0 2000.0 2100.0 2200.0 2300.0 ... 6700.0 6800.0 6900.0 7000.0 7100.0 7200.0 7300.0 7400.0 7500.0 7600.0
Date
2001-01-01 0.000000 0.350881 0.288029 0.107759 0.723593 1.075053 1.479878 1.888137 2.819928 6.869486 ... 21.965036 14.542485 11.176612 12.601063 8.180685 5.567430 4.136129 3.105402 1.911621 0.488112
2001-01-02 0.017387 1.454463 1.212285 0.466432 1.221172 1.763915 2.692399 3.270561 3.555070 7.739756 ... 21.417894 14.294745 10.944931 12.290499 8.058737 5.433397 4.107623 3.032999 1.839174 0.458876
2001-01-03 0.020757 1.599701 1.187170 0.655138 1.669336 2.509553 3.646214 4.546192 4.701798 9.258268 ... 21.198601 14.212723 10.806521 12.132765 7.995263 5.347770 4.098392 2.968965 1.791176 0.437174
2001-01-04 0.019212 0.860910 0.631290 0.825856 2.663206 3.998790 5.017432 6.698186 6.733673 11.279051 ... 21.364264 14.318376 10.829168 12.183534 8.031734 5.349766 4.118656 2.949475 1.787441 0.430820
2001-01-05 0.054888 0.791811 0.652713 1.007844 3.341506 5.047784 6.015337 8.236839 8.641469 12.814977 ... 21.732061 14.512557 10.965686 12.370435 8.126849 5.408155 4.148344 2.963020 1.826037 0.439600
2001-01-06 0.000000 0.902082 0.922109 0.913373 3.206936 4.895827 5.711488 8.179827 8.643897 12.207982 ... 22.181021 14.745033 11.157868 12.619118 8.239072 5.485559 4.176592 2.990195 1.886056 0.455806
2001-01-07 0.000000 0.533921 0.598704 0.522308 2.240006 3.343351 3.793340 5.654303 6.270244 9.048230 ... 22.535919 14.924230 11.323182 12.825211 8.330709 5.561720 4.191511 3.024283 1.948843 0.472507
2001-01-08 0.000000 0.136201 0.184327 0.182696 1.397814 1.373493 1.285376 2.351887 3.155181 5.348240 ... 22.606756 14.932497 11.377660 12.887055 8.363058 5.608452 4.183011 3.051394 1.998150 0.483046
2001-01-09 0.000000 0.000000 0.000000 0.029494 0.955253 0.706635 0.578012 1.223469 1.782289 3.872722 ... 22.399870 14.785818 11.325197 12.806149 8.338674 5.605553 4.158711 3.061891 2.024575 0.485901
2001-01-10 0.000000 0.000000 0.000000 0.084554 0.901395 0.832167 1.353487 2.038978 2.098031 4.536038 ... 22.055664 14.592560 11.244079 12.665183 8.301152 5.583508 4.137074 3.079128 2.012962 0.479140
2001-01-11 0.000000 0.000000 0.431593 0.466518 1.240427 1.521801 2.978840 4.177472 3.924112 6.898399 ... 21.725534 14.392135 11.180174 12.509900 8.270628 5.573613 4.120094 3.105167 1.976083 0.469072
2001-01-12 0.000000 0.000000 0.404031 0.406113 1.096820 1.188501 2.665481 3.660166 3.397468 6.285161 ... 21.739666 14.358455 11.246137 12.481992 8.298361 5.620366 4.133660 3.137172 1.954725 0.471476
2001-01-13 0.000000 0.000000 0.000000 0.016743 0.633780 0.316729 0.560431 0.733124 0.768779 2.953489 ... 22.106775 14.559265 11.444358 12.625062 8.385169 5.697427 4.184148 3.173256 1.957752 0.489035
2001-01-14 0.018783 0.053686 0.000000 0.000000 0.624056 0.362709 0.361850 0.407143 0.658637 2.506505 ... 22.535912 14.836538 11.640275 12.828431 8.470560 5.757576 4.229206 3.202579 1.962495 0.510737
2001-01-15 0.146977 1.166412 0.326410 0.242586 2.427725 2.063986 1.956979 1.978337 2.158500 4.547886 ... 22.734568 14.987793 11.716822 12.928181 8.507782 5.781187 4.243287 3.216832 1.966445 0.522951
2001-01-16 0.300629 2.985344 1.767306 2.009505 6.353167 6.416318 6.780251 8.155763 7.817698 10.940251 ... 22.750282 15.034738 11.715256 12.941792 8.505357 5.781874 4.241140 3.220009 1.978938 0.529284
2001-01-17 0.355024 4.569010 3.292092 3.579884 9.324302 10.061910 10.979341 13.358638 12.479096 16.355768 ... 22.712729 15.051585 11.690119 12.936144 8.486403 5.772815 4.234980 3.222349 1.997034 0.534758
2001-01-18 0.300801 5.206096 4.541276 4.667624 10.803686 11.979652 13.166734 16.282204 15.182937 19.454161 ... 22.660210 15.060386 11.655899 12.929258 8.457873 5.757124 4.227573 3.227973 2.017255 0.539952
2001-01-19 0.252052 5.334569 5.094772 4.951918 10.757232 12.255269 13.748846 17.142982 16.098749 20.707951 ... 22.598513 15.063909 11.613914 12.916613 8.422713 5.736173 4.218687 3.234885 2.037519 0.544632
2001-01-20 0.195812 4.440666 4.579722 4.326553 9.299594 11.151431 12.863160 16.183228 15.312285 20.138926 ... 22.533813 15.063109 11.565855 12.897702 8.383988 5.711401 4.209221 3.241303 2.055550 0.548410
2001-01-21 0.094428 2.948466 3.242162 3.131119 7.016675 9.099209 10.935057 13.957924 13.357951 18.122562 ... 22.474396 15.059505 11.514634 12.875997 8.345265 5.683969 4.199753 3.245897 2.069245 0.551007
2001-01-22 0.021101 1.555223 1.644135 1.693463 4.291757 6.311673 8.326736 10.730275 10.546012 15.108086 ... 22.434258 15.059808 11.458502 12.858614 8.308964 5.651169 4.188828 3.244823 2.069653 0.549762
2001-01-23 0.000000 0.695516 0.554163 0.474954 1.658453 3.203137 5.442091 7.198922 7.396386 11.694586 ... 22.412302 15.069467 11.381204 12.846784 8.270263 5.603664 4.173008 3.230077 2.039215 0.538557
2001-01-24 0.000000 0.326539 0.180034 0.056820 0.461452 1.713814 3.929886 5.296896 5.834187 9.676577 ... 22.312054 15.055689 11.274776 12.790994 8.221127 5.549034 4.164872 3.207494 1.999181 0.523810
2001-01-25 0.000000 0.000000 0.000000 0.016207 0.197980 0.860953 2.779937 3.954657 4.708196 8.149174 ... 22.101967 14.995797 11.172790 12.683216 8.183433 5.504943 4.176141 3.185985 1.982437 0.517091
2001-01-26 0.000000 0.000000 0.000000 0.000000 0.023784 0.317652 1.726607 2.647192 3.268693 6.201445 ... 21.948189 14.905747 11.137223 12.602481 8.188885 5.490345 4.197243 3.177335 1.980076 0.516340
2001-01-27 0.000000 0.000000 0.000000 0.042417 0.050316 0.232776 1.104763 1.618526 1.966681 3.906037 ... 21.892431 14.810866 11.145208 12.550835 8.216211 5.498332 4.220833 3.176949 1.982287 0.517692
2001-01-28 0.000000 0.000000 0.018890 0.125597 0.258750 0.917580 1.361966 2.199436 2.216029 3.535192 ... 21.932671 14.759437 11.177213 12.525569 8.247658 5.518617 4.244102 3.179052 1.986387 0.519817
2001-01-29 0.000000 0.000000 0.049329 0.174131 0.467269 1.540992 2.218326 2.933633 3.202300 4.511761 ... 22.091837 14.786915 11.239916 12.537761 8.278053 5.545579 4.265096 3.183388 1.991109 0.522243
2001-01-30 0.000000 0.036707 0.070258 0.188170 0.683903 1.803906 2.951406 3.470709 3.824918 5.492236 ... 22.345339 14.874686 11.321827 12.584967 8.312979 5.573076 4.283084 3.188325 1.995682 0.524776
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
2001-12-02 0.000000 1.213466 1.668993 2.109257 5.474655 5.341865 5.688647 8.797614 10.057768 14.299012 ... 21.547720 14.560512 10.857952 12.455056 7.899999 5.369279 3.970541 3.010502 1.829879 0.474396
2001-12-03 0.000000 1.249872 1.714887 1.652485 4.491648 4.350379 5.318361 7.885293 9.066968 12.879198 ... 21.573984 14.506288 10.778442 12.417488 7.861810 5.337273 3.922221 2.997665 1.826101 0.475083
2001-12-04 0.000000 0.664605 1.224284 1.038819 3.242162 3.052854 4.255479 5.963647 7.065919 10.630264 ... 21.526470 14.406599 10.691849 12.345600 7.820595 5.308337 3.885730 2.988414 1.823740 0.475791
2001-12-05 0.000000 0.234171 0.625129 0.765215 2.452583 2.342935 3.508338 5.018118 5.689785 9.383652 ... 21.348986 14.266192 10.611931 12.275556 7.796876 5.290992 3.873773 2.984464 1.822216 0.476006
2001-12-06 0.000000 0.198237 0.242586 0.661020 2.138923 2.013563 3.182186 4.609129 5.025911 8.850207 ... 21.240648 14.256361 10.633588 12.333087 7.835879 5.300631 3.892385 2.986267 1.824749 0.476349
2001-12-07 0.000000 0.078350 0.108381 0.653764 1.571902 1.464702 2.414846 3.458559 4.004994 7.991162 ... 21.309935 14.381012 10.751333 12.505283 7.918931 5.331779 3.922093 2.989959 1.826982 0.474761
2001-12-08 0.000000 0.000000 0.088826 0.566012 1.470454 1.542043 1.911579 2.718824 3.537489 7.680315 ... 21.393892 14.450631 10.836616 12.598316 7.978949 5.356205 3.936712 2.997730 1.821143 0.468664
2001-12-09 0.000000 0.000000 0.153052 0.513313 2.133171 2.348194 2.043315 3.208761 4.095259 8.823245 ... 21.569586 14.489310 10.896804 12.623862 8.022954 5.374065 3.931817 3.015997 1.809337 0.458833
2001-12-10 0.000000 0.016228 0.517413 0.454025 2.298093 2.518483 2.033869 3.342257 4.523374 9.643904 ... 21.871996 14.560407 10.959678 12.649087 8.060024 5.391776 3.918101 3.039459 1.799205 0.448422
2001-12-11 0.000000 0.018525 0.763498 0.354230 1.584761 1.794675 1.650403 3.017050 4.204648 9.541321 ... 22.106562 14.618901 11.009329 12.664371 8.077412 5.397334 3.908999 3.055838 1.793666 0.441574
2001-12-12 0.000000 0.080776 0.898905 0.348692 1.070245 1.314634 1.523690 2.960057 4.218194 9.802410 ... 22.075304 14.589665 11.021027 12.646570 8.057019 5.384112 3.911875 3.061033 1.795792 0.443356
2001-12-13 0.000000 0.137210 1.041889 0.404503 0.960963 1.701148 2.645518 4.200548 6.264492 12.245185 ... 21.771349 14.446162 10.989194 12.587027 7.994962 5.352385 3.920633 3.062749 1.805816 0.456429
2001-12-14 0.000000 0.238250 1.322662 0.672762 1.086581 2.661360 4.515602 6.161842 8.806631 15.130262 ... 21.424431 14.296525 10.948192 12.517069 7.939281 5.320186 3.934865 3.061419 1.819576 0.472721
2001-12-15 0.000000 0.573053 2.400442 1.853277 1.955068 4.364484 6.905999 8.622001 11.215100 17.267212 ... 21.257801 14.261472 10.937934 12.471883 7.947266 5.312932 3.961011 3.061162 1.837779 0.484571
2001-12-16 0.000000 0.751864 3.049956 2.436419 3.043087 5.865979 8.269361 10.000067 12.283692 17.611950 ... 21.392431 14.381270 10.999561 12.480921 8.026217 5.349874 3.998962 3.078656 1.869462 0.494058
2001-12-17 0.000000 0.573933 2.205961 1.997549 3.290203 5.747958 7.670397 9.251790 11.241890 15.972449 ... 21.819370 14.651016 11.140398 12.565454 8.140801 5.428804 4.042989 3.110790 1.909496 0.502387
2001-12-18 0.000000 0.074315 0.815403 0.999107 2.800502 4.489349 5.867136 7.492576 9.402781 13.591355 ... 22.275839 14.920300 11.274989 12.647391 8.240896 5.495112 4.082808 3.128178 1.935556 0.506594
2001-12-19 0.000000 0.016207 0.142190 0.566012 2.428240 3.777843 4.811101 6.785682 8.243344 12.388426 ... 22.360048 14.921592 11.258376 12.572451 8.268780 5.460830 4.093304 3.088316 1.915936 0.502108
2001-12-20 0.000000 0.016421 0.065686 0.506594 2.813939 4.221391 5.022176 7.235565 8.396117 12.474185 ... 22.088720 14.656654 11.075014 12.339311 8.218142 5.323192 4.067997 3.011210 1.864010 0.497128
2001-12-21 0.000000 0.327440 0.747184 0.858291 4.235752 6.098858 6.338398 8.884979 9.978298 14.153028 ... 21.873310 14.513306 10.953216 12.219144 8.186353 5.251625 4.052284 2.979463 1.846644 0.499275
2001-12-22 0.024772 1.314741 2.047629 1.567909 6.388392 8.712094 8.271055 10.790462 12.236597 16.647978 ... 21.815794 14.572664 10.956823 12.267509 8.204082 5.275838 4.065163 2.989508 1.866328 0.505414
2001-12-23 0.047933 2.055335 2.903903 2.070082 7.580993 10.296100 9.341215 11.426177 13.300097 17.951817 ... 21.823620 14.682654 11.018191 12.385120 8.239179 5.337402 4.090708 3.012369 1.898205 0.513206
2001-12-24 0.066394 2.607630 3.403113 2.443009 7.661854 10.332959 9.271192 10.964163 12.933507 17.868210 ... 21.860088 14.797603 11.100281 12.522050 8.277882 5.410838 4.119042 3.039567 1.929781 0.521256
2001-12-25 0.075088 2.773304 3.351230 2.436762 6.606379 8.996432 8.095016 9.563326 11.389574 16.294975 ... 21.938808 14.913495 11.190413 12.654987 8.315813 5.493974 4.145638 3.074470 1.954424 0.528039
2001-12-26 0.058494 1.934569 2.362340 1.809294 4.393913 6.082033 5.588167 6.565207 8.300465 12.830923 ... 22.076462 15.018318 11.282975 12.759269 8.350074 5.576104 4.168349 3.119806 1.966338 0.531302
2001-12-27 0.023097 0.663102 0.686800 0.666665 1.716175 2.216694 2.006006 2.620531 3.917177 7.569938 ... 22.213270 15.076743 11.351237 12.767426 8.372976 5.590206 4.186359 3.150287 1.954231 0.524862
2001-12-28 0.000000 0.024042 0.016937 0.026446 0.322031 0.168056 0.155842 0.390915 1.114787 4.032578 ... 22.176405 14.993608 11.296713 12.602739 8.339275 5.502732 4.185930 3.129938 1.912308 0.500455
2001-12-29 0.000000 0.000000 0.000000 0.000000 0.052269 0.052892 0.039884 0.136480 0.486953 2.928588 ... 21.958204 14.785345 11.140594 12.401515 8.251071 5.416462 4.160901 3.067494 1.870901 0.470167
2001-12-30 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.069592 0.287922 2.312690 ... 21.780500 14.706564 11.117259 12.426074 8.213721 5.468194 4.164249 3.049999 1.889705 0.468922
2001-12-31 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.038145 0.249519 1.982695 ... 21.687202 14.725435 11.190435 12.578674 8.222307 5.570456 4.187476 3.078120 1.942318 0.492556

365 rows × 63 columns


In [14]:
"%.0f" % float(hyps.data.columns[0])


Out[14]:
'1400'

In [ ]:
print str(float(hyps.data.columns[0]) - 100.)

In [ ]:
hyps.data.shape[0]

In [ ]:
new = np.zeros(hyps.data.shape[0])
new

In [ ]:
hyps.data[str(float(hyps.data.columns[0]) - 100.)] = new

In [ ]:
hyps.data

In [ ]:
df = hyps.data
df

In [ ]:
df.columns[(df == 0).all()]

In [ ]:
noz = df.drop(df.columns[(df == 0).all()], axis=1)
noz

In [ ]:
np.round(noz.as_matrix())

In [ ]:
np.ceil([0.4,0.5, 0.6])

In [ ]: