In [10]:
%pylab notebook
from __future__ import print_function
import numpy as np
import pandas as pd
from charistools.hypsometry import Hypsometry
from charistools.modelEnv import ModelEnv
Populating the interactive namespace from numpy and matplotlib
In [4]:
%cd /Users/brodzik/projects/CHARIS/charistools_test_data/derived_hypsometries/IN_Hunza_at_DainyorBridge
%ls
/Users/brodzik/projects/CHARIS/charistools_test_data/derived_hypsometries/IN_Hunza_at_DainyorBridge
IN_Hunza_at_DainyorBridge.0100m.modicev04_1strike_area_by_elev.txt
IN_Hunza_at_DainyorBridge.0100m.modicev04_2strike_area_by_elev.txt
IN_Hunza_at_DainyorBridge.0100m.modicev04_3strike_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2001.0100m.ALBEDO_MOD10A1.0040.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2001.0100m.ALBEDO_MOD10A1.0040.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2001.0100m.ALBEDO_MOD10A1.0045.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2001.0100m.ALBEDO_MOD10A1.0045.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2001.0100m.ALBEDO_MOD10A1.0050.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2001.0100m.ALBEDO_MOD10A1.0050.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2001.0100m.ERA_Interim_downscale_uncorrected_tsurf.v0.2_by_elev.txt
IN_Hunza_at_DainyorBridge.2001.0100m.snow_on_land_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2002.0100m.ALBEDO_MOD10A1.0040.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2002.0100m.ALBEDO_MOD10A1.0040.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2002.0100m.ALBEDO_MOD10A1.0045.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2002.0100m.ALBEDO_MOD10A1.0045.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2002.0100m.ALBEDO_MOD10A1.0050.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2002.0100m.ALBEDO_MOD10A1.0050.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2002.0100m.ERA_Interim_downscale_uncorrected_tsurf.v0.2_by_elev.txt
IN_Hunza_at_DainyorBridge.2002.0100m.snow_on_land_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2003.0100m.ALBEDO_MOD10A1.0040.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2003.0100m.ALBEDO_MOD10A1.0040.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2003.0100m.ALBEDO_MOD10A1.0045.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2003.0100m.ALBEDO_MOD10A1.0045.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2003.0100m.ALBEDO_MOD10A1.0050.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2003.0100m.ALBEDO_MOD10A1.0050.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2003.0100m.ERA_Interim_downscale_uncorrected_tsurf.v0.2_by_elev.txt
IN_Hunza_at_DainyorBridge.2003.0100m.snow_on_land_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2004.0100m.ALBEDO_MOD10A1.0040.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2004.0100m.ALBEDO_MOD10A1.0040.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2004.0100m.ALBEDO_MOD10A1.0045.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2004.0100m.ALBEDO_MOD10A1.0045.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2004.0100m.ALBEDO_MOD10A1.0050.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2004.0100m.ALBEDO_MOD10A1.0050.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2004.0100m.ERA_Interim_downscale_uncorrected_tsurf.v0.2_by_elev.txt
IN_Hunza_at_DainyorBridge.2004.0100m.snow_on_land_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2005.0100m.ALBEDO_MOD10A1.0040.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2005.0100m.ALBEDO_MOD10A1.0040.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2005.0100m.ALBEDO_MOD10A1.0045.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2005.0100m.ALBEDO_MOD10A1.0045.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2005.0100m.ALBEDO_MOD10A1.0050.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2005.0100m.ALBEDO_MOD10A1.0050.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2005.0100m.ERA_Interim_downscale_uncorrected_tsurf.v0.2_by_elev.txt
IN_Hunza_at_DainyorBridge.2005.0100m.snow_on_land_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2006.0100m.ALBEDO_MOD10A1.0040.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2006.0100m.ALBEDO_MOD10A1.0040.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2006.0100m.ALBEDO_MOD10A1.0045.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2006.0100m.ALBEDO_MOD10A1.0045.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2006.0100m.ALBEDO_MOD10A1.0050.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2006.0100m.ALBEDO_MOD10A1.0050.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2006.0100m.ERA_Interim_downscale_uncorrected_tsurf.v0.2_by_elev.txt
IN_Hunza_at_DainyorBridge.2006.0100m.snow_on_land_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2007.0100m.ALBEDO_MOD10A1.0040.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2007.0100m.ALBEDO_MOD10A1.0040.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2007.0100m.ALBEDO_MOD10A1.0045.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2007.0100m.ALBEDO_MOD10A1.0045.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2007.0100m.ALBEDO_MOD10A1.0050.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2007.0100m.ALBEDO_MOD10A1.0050.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2007.0100m.ERA_Interim_downscale_uncorrected_tsurf.v0.2_by_elev.txt
IN_Hunza_at_DainyorBridge.2007.0100m.snow_on_land_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2008.0100m.ALBEDO_MOD10A1.0040.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2008.0100m.ALBEDO_MOD10A1.0040.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2008.0100m.ALBEDO_MOD10A1.0045.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2008.0100m.ALBEDO_MOD10A1.0045.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2008.0100m.ALBEDO_MOD10A1.0050.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2008.0100m.ALBEDO_MOD10A1.0050.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2008.0100m.ERA_Interim_downscale_uncorrected_tsurf.v0.2_by_elev.txt
IN_Hunza_at_DainyorBridge.2008.0100m.snow_on_land_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2009.0100m.ALBEDO_MOD10A1.0040.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2009.0100m.ALBEDO_MOD10A1.0040.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2009.0100m.ALBEDO_MOD10A1.0045.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2009.0100m.ALBEDO_MOD10A1.0045.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2009.0100m.ALBEDO_MOD10A1.0050.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2009.0100m.ALBEDO_MOD10A1.0050.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2009.0100m.ERA_Interim_downscale_uncorrected_tsurf.v0.2_by_elev.txt
IN_Hunza_at_DainyorBridge.2009.0100m.snow_on_land_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2010.0100m.ALBEDO_MOD10A1.0040.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2010.0100m.ALBEDO_MOD10A1.0040.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2010.0100m.ALBEDO_MOD10A1.0045.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2010.0100m.ALBEDO_MOD10A1.0045.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2010.0100m.ALBEDO_MOD10A1.0050.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2010.0100m.ALBEDO_MOD10A1.0050.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2010.0100m.ERA_Interim_downscale_uncorrected_tsurf.v0.2_by_elev.txt
IN_Hunza_at_DainyorBridge.2010.0100m.snow_on_land_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2011.0100m.ALBEDO_MOD10A1.0040.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2011.0100m.ALBEDO_MOD10A1.0040.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2011.0100m.ALBEDO_MOD10A1.0045.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2011.0100m.ALBEDO_MOD10A1.0045.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2011.0100m.ALBEDO_MOD10A1.0050.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2011.0100m.ALBEDO_MOD10A1.0050.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2011.0100m.ERA_Interim_downscale_uncorrected_tsurf.v0.2_by_elev.txt
IN_Hunza_at_DainyorBridge.2011.0100m.snow_on_land_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2012.0100m.ALBEDO_MOD10A1.0040.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2012.0100m.ALBEDO_MOD10A1.0040.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2012.0100m.ALBEDO_MOD10A1.0045.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2012.0100m.ALBEDO_MOD10A1.0045.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2012.0100m.ALBEDO_MOD10A1.0050.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2012.0100m.ALBEDO_MOD10A1.0050.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2012.0100m.ERA_Interim_downscale_uncorrected_tsurf.v0.2_by_elev.txt
IN_Hunza_at_DainyorBridge.2012.0100m.snow_on_land_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2013.0100m.ALBEDO_MOD10A1.0040.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2013.0100m.ALBEDO_MOD10A1.0040.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2013.0100m.ALBEDO_MOD10A1.0045.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2013.0100m.ALBEDO_MOD10A1.0045.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2013.0100m.ALBEDO_MOD10A1.0050.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2013.0100m.ALBEDO_MOD10A1.0050.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2013.0100m.ERA_Interim_downscale_uncorrected_tsurf.v0.2_by_elev.txt
IN_Hunza_at_DainyorBridge.2013.0100m.snow_on_land_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2014.0100m.ALBEDO_MOD10A1.0040.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2014.0100m.ALBEDO_MOD10A1.0040.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2014.0100m.ALBEDO_MOD10A1.0045.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2014.0100m.ALBEDO_MOD10A1.0045.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2014.0100m.ALBEDO_MOD10A1.0050.exposed_glacier_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2014.0100m.ALBEDO_MOD10A1.0050.snow_on_ice_area_by_elev.txt
IN_Hunza_at_DainyorBridge.2014.0100m.ERA_Interim_downscale_uncorrected_tsurf.v0.2_by_elev.txt
IN_Hunza_at_DainyorBridge.2014.0100m.snow_on_land_area_by_elev.txt
In [5]:
iceHyps = Hypsometry(filename="IN_Hunza_at_DainyorBridge.0100m.modicev04_1strike_area_by_elev.txt")
In [6]:
SOIHyps = Hypsometry(filename="IN_Hunza_at_DainyorBridge.2014.0100m.ALBEDO_MOD10A1.0040.snow_on_ice_area_by_elev.txt")
In [11]:
iceHyps.print()
# Hypsometry created : 2016-06-19 16:07:04.252174
# Elevations in meters, contour at bottom of elevation band
# MODICE area in square km
# h23v05: basin_mask : /lustre/janus_scratch/brodzik/basins/IN_Hunza_at_DainyorBridge.basin_mask.h23v05.tif
# h23v05: dem : /lustre/janus_scratch/brodzik/SRTMGL3_version2_SIN/CHARIS_DEM.v2.0.h23v05.tif
# h23v05: modice : /lustre/janus_scratch/brodzik/glaciers/modicev04/min05yr_nc/MODICE.v0.4.h23v05.1strike.min05yr.mask.nc
# h24v05: basin_mask : /lustre/janus_scratch/brodzik/basins/IN_Hunza_at_DainyorBridge.basin_mask.h24v05.tif
# h24v05: dem : /lustre/janus_scratch/brodzik/SRTMGL3_version2_SIN/CHARIS_DEM.v2.0.h24v05.tif
# h24v05: modice : /lustre/janus_scratch/brodzik/glaciers/modicev04/min05yr_nc/MODICE.v0.4.h24v05.1strike.min05yr.mask.nc
1400.0 1500.0 1600.0 1700.0 1800.0 1900.0 2000.0 2100.0 \
Date
NoDate 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
2200.0 2300.0 ... 6700.0 6800.0 6900.0 7000.0 7100.0 \
Date ...
NoDate 0.0 0.0 ... 23.83 16.53 15.46 12.02 9.87
7200.0 7300.0 7400.0 7500.0 7600.0
Date
NoDate 7.51 4.72 3.01 2.36 1.93
[1 rows x 63 columns]
In [12]:
SOIHyps.print()
# Hypsometry created : 2016-06-21 17:16:21.186866
# Elevations in meters, contour at bottom of elevation band
# Snow_on_ice area in square km
# Files used to derive this hypsometry data:
# h23v05: basin_mask : /lustre/janus_scratch/brodzik/basins/IN_Hunza_at_DainyorBridge.basin_mask.h23v05.tif
# h23v05: dem : /lustre/janus_scratch/brodzik/SRTMGL3_version2_SIN/CHARIS_DEM.v2.0.h23v05.tif
# h23v05: modice : /lustre/janus_scratch/brodzik/glaciers/modicev04/min05yr_nc/MODICE.v0.4.h23v05.1strike.min05yr.mask.nc
# h23v05: fSCA : /lustre/janus_scratch/brodzik/snow_cover/MOD10A1_fractional_GF/v05/h23v05/MOD10A1_GF_Snow.v0.5.h23v05_2014.h5
# h23v05: ablation_method (threshold=0.4): /lustre/janus_scratch/brodzik/albedo/MOD10A1_005_GF/v05/h23v05/MOD10A1_GF_Albedo_shortwave.v0.5.h23v05_2014.h5
# h24v05: basin_mask : /lustre/janus_scratch/brodzik/basins/IN_Hunza_at_DainyorBridge.basin_mask.h24v05.tif
# h24v05: dem : /lustre/janus_scratch/brodzik/SRTMGL3_version2_SIN/CHARIS_DEM.v2.0.h24v05.tif
# h24v05: modice : /lustre/janus_scratch/brodzik/glaciers/modicev04/min05yr_nc/MODICE.v0.4.h24v05.1strike.min05yr.mask.nc
# h24v05: fSCA : /lustre/janus_scratch/brodzik/snow_cover/MOD10A1_fractional_GF/v05/h24v05/MOD10A1_GF_Snow.v0.5.h24v05_2014.h5
# h24v05: ablation_method (threshold=0.4): /lustre/janus_scratch/brodzik/albedo/MOD10A1_005_GF/v05/h24v05/MOD10A1_GF_Albedo_shortwave.v0.5.h24v05_2014.h5
2900.0 3000.0 3100.0 3200.0 3300.0 3400.0 3500.0 3600.0 \
Date
2014-01-01 0.0 0.10 0.41 0.83 0.99 4.07 1.88 3.91
2014-01-02 0.0 0.15 0.46 1.11 1.66 3.98 2.11 3.95
2014-01-03 0.0 0.20 0.50 1.31 1.68 4.08 2.46 4.19
2014-01-04 0.0 0.25 0.89 1.56 1.91 4.50 2.51 4.23
2014-01-05 0.0 0.29 0.93 1.79 1.93 4.57 3.05 4.28
3700.0 3800.0 ... 6700.0 6800.0 6900.0 7000.0 7100.0 \
Date ...
2014-01-01 2.32 6.02 ... 12.24 6.80 6.00 5.56 4.24
2014-01-02 2.56 5.81 ... 12.25 6.77 5.77 5.56 4.24
2014-01-03 2.81 5.61 ... 12.26 6.73 5.74 5.56 4.03
2014-01-04 2.87 5.62 ... 12.49 6.68 5.50 5.56 4.03
2014-01-05 2.93 5.66 ... 12.09 6.86 5.25 5.78 4.03
7200.0 7300.0 7400.0 7500.0 7600.0
Date
2014-01-01 2.78 2.49 0.64 1.5 0.64
2014-01-02 2.78 2.71 0.64 1.5 0.64
2014-01-03 2.78 2.71 0.64 1.5 0.64
2014-01-04 2.78 2.71 0.64 1.5 0.64
2014-01-05 2.78 2.71 0.64 1.5 0.64
[5 rows x 48 columns]
In [13]:
all = iceHyps.data.transpose()
In [15]:
SOIHyps.data.loc['2014-01-03']
Out[15]:
2900.0 0.00
3000.0 0.20
3100.0 0.50
3200.0 1.31
3300.0 1.68
3400.0 4.08
3500.0 2.46
3600.0 4.19
3700.0 2.81
3800.0 5.61
3900.0 6.22
4000.0 7.64
4100.0 9.65
4200.0 13.25
4300.0 22.05
4400.0 30.68
4500.0 47.48
4600.0 62.00
4700.0 74.30
4800.0 96.68
4900.0 130.50
5000.0 165.71
5100.0 230.24
5200.0 244.40
5300.0 250.44
5400.0 233.34
5500.0 190.15
5600.0 153.11
5700.0 103.83
5800.0 70.21
5900.0 57.67
6000.0 44.37
6100.0 31.02
6200.0 27.78
6300.0 20.59
6400.0 18.95
6500.0 15.43
6600.0 12.88
6700.0 12.26
6800.0 6.73
6900.0 5.74
7000.0 5.56
7100.0 4.03
7200.0 2.78
7300.0 2.71
7400.0 0.64
7500.0 1.50
7600.0 0.64
Name: 2014-01-03 00:00:00, dtype: float64
In [16]:
type(SOIHyps.data.loc['2014-01-03'])
Out[16]:
pandas.core.series.Series
In [17]:
all['SOI'] = SOIHyps.data.loc['2014-01-03']
In [18]:
all
Out[18]:
Date
NoDate
SOI
1400.0
0.00
NaN
1500.0
0.00
NaN
1600.0
0.00
NaN
1700.0
0.00
NaN
1800.0
0.00
NaN
1900.0
0.00
NaN
2000.0
0.00
NaN
2100.0
0.00
NaN
2200.0
0.00
NaN
2300.0
0.00
NaN
2400.0
0.00
NaN
2500.0
0.00
NaN
2600.0
0.00
NaN
2700.0
0.00
NaN
2800.0
0.00
NaN
2900.0
0.21
0.00
3000.0
0.43
0.20
3100.0
1.07
0.50
3200.0
2.36
1.31
3300.0
3.01
1.68
3400.0
5.58
4.08
3500.0
5.58
2.46
3600.0
7.51
4.19
3700.0
7.73
2.81
3800.0
11.81
5.61
3900.0
11.16
6.22
4000.0
18.68
7.64
4100.0
21.90
9.65
4200.0
24.26
13.25
4300.0
41.00
22.05
...
...
...
4700.0
138.45
74.30
4800.0
183.75
96.68
4900.0
236.55
130.50
5000.0
305.89
165.71
5100.0
395.62
230.24
5200.0
422.02
244.40
5300.0
436.62
250.44
5400.0
399.27
233.34
5500.0
336.16
190.15
5600.0
258.23
153.11
5700.0
189.33
103.83
5800.0
130.94
70.21
5900.0
112.70
57.67
6000.0
82.64
44.37
6100.0
63.75
31.02
6200.0
55.60
27.78
6300.0
49.16
20.59
6400.0
40.36
18.95
6500.0
31.98
15.43
6600.0
30.70
12.88
6700.0
23.83
12.26
6800.0
16.53
6.73
6900.0
15.46
5.74
7000.0
12.02
5.56
7100.0
9.87
4.03
7200.0
7.51
2.78
7300.0
4.72
2.71
7400.0
3.01
0.64
7500.0
2.36
1.50
7600.0
1.93
0.64
63 rows × 2 columns
In [19]:
all.columns = ['MODICE', 'SOI']
all
Out[19]:
MODICE
SOI
1400.0
0.00
NaN
1500.0
0.00
NaN
1600.0
0.00
NaN
1700.0
0.00
NaN
1800.0
0.00
NaN
1900.0
0.00
NaN
2000.0
0.00
NaN
2100.0
0.00
NaN
2200.0
0.00
NaN
2300.0
0.00
NaN
2400.0
0.00
NaN
2500.0
0.00
NaN
2600.0
0.00
NaN
2700.0
0.00
NaN
2800.0
0.00
NaN
2900.0
0.21
0.00
3000.0
0.43
0.20
3100.0
1.07
0.50
3200.0
2.36
1.31
3300.0
3.01
1.68
3400.0
5.58
4.08
3500.0
5.58
2.46
3600.0
7.51
4.19
3700.0
7.73
2.81
3800.0
11.81
5.61
3900.0
11.16
6.22
4000.0
18.68
7.64
4100.0
21.90
9.65
4200.0
24.26
13.25
4300.0
41.00
22.05
...
...
...
4700.0
138.45
74.30
4800.0
183.75
96.68
4900.0
236.55
130.50
5000.0
305.89
165.71
5100.0
395.62
230.24
5200.0
422.02
244.40
5300.0
436.62
250.44
5400.0
399.27
233.34
5500.0
336.16
190.15
5600.0
258.23
153.11
5700.0
189.33
103.83
5800.0
130.94
70.21
5900.0
112.70
57.67
6000.0
82.64
44.37
6100.0
63.75
31.02
6200.0
55.60
27.78
6300.0
49.16
20.59
6400.0
40.36
18.95
6500.0
31.98
15.43
6600.0
30.70
12.88
6700.0
23.83
12.26
6800.0
16.53
6.73
6900.0
15.46
5.74
7000.0
12.02
5.56
7100.0
9.87
4.03
7200.0
7.51
2.78
7300.0
4.72
2.71
7400.0
3.01
0.64
7500.0
2.36
1.50
7600.0
1.93
0.64
63 rows × 2 columns
In [23]:
SOIHyps.data.columns
Out[23]:
Index([u'2900.0', u'3000.0', u'3100.0', u'3200.0', u'3300.0', u'3400.0',
u'3500.0', u'3600.0', u'3700.0', u'3800.0', u'3900.0', u'4000.0',
u'4100.0', u'4200.0', u'4300.0', u'4400.0', u'4500.0', u'4600.0',
u'4700.0', u'4800.0', u'4900.0', u'5000.0', u'5100.0', u'5200.0',
u'5300.0', u'5400.0', u'5500.0', u'5600.0', u'5700.0', u'5800.0',
u'5900.0', u'6000.0', u'6100.0', u'6200.0', u'6300.0', u'6400.0',
u'6500.0', u'6600.0', u'6700.0', u'6800.0', u'6900.0', u'7000.0',
u'7100.0', u'7200.0', u'7300.0', u'7400.0', u'7500.0', u'7600.0'],
dtype='object')
In [21]:
all.index
Out[21]:
Index([u'1400.0', u'1500.0', u'1600.0', u'1700.0', u'1800.0', u'1900.0',
u'2000.0', u'2100.0', u'2200.0', u'2300.0', u'2400.0', u'2500.0',
u'2600.0', u'2700.0', u'2800.0', u'2900.0', u'3000.0', u'3100.0',
u'3200.0', u'3300.0', u'3400.0', u'3500.0', u'3600.0', u'3700.0',
u'3800.0', u'3900.0', u'4000.0', u'4100.0', u'4200.0', u'4300.0',
u'4400.0', u'4500.0', u'4600.0', u'4700.0', u'4800.0', u'4900.0',
u'5000.0', u'5100.0', u'5200.0', u'5300.0', u'5400.0', u'5500.0',
u'5600.0', u'5700.0', u'5800.0', u'5900.0', u'6000.0', u'6100.0',
u'6200.0', u'6300.0', u'6400.0', u'6500.0', u'6600.0', u'6700.0',
u'6800.0', u'6900.0', u'7000.0', u'7100.0', u'7200.0', u'7300.0',
u'7400.0', u'7500.0', u'7600.0'],
dtype='object')
In [24]:
test = [1400., 1500.]
test
Out[24]:
[1400.0, 1500.0]
In [25]:
new = ["%.1f" % i for i in test]
new
Out[25]:
['1400.0', '1500.0']
In [ ]:
Content source: mjbrodzik/ipython_notebooks
Similar notebooks: