-
Notifications
You must be signed in to change notification settings - Fork 0
/
test_read_OIB_ALL.py
184 lines (158 loc) · 8.04 KB
/
test_read_OIB_ALL.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
# -*- coding: utf-8 -*-
# %load_ext autoreload
# %autoreload 2
import os
import numpy as np
import matplotlib.pyplot as plt
import matplotlib.cm as cm
import pandas as pd
import seaborn as sns
from my_OIB_functions import importOIBgrav,importOIBatm,importOIBrad,mapplotOIBlocal
#from datetime import datetime, date, time
pd.set_option("display.max_rows",20)
pd.set_option("precision",13)
pd.set_option('expand_frame_repr', False)
#########################################################
### Read in data sets
# point to data directories
basedir = '/Users/dporter/Documents/data_local/Antarctica/OIB/'
# if os.path.isdir('/Volumes/C/'):
# basedir = '/Volumes/C/data/Antarctic/OIB/ATM/2009_AN_NASA_ATM'
# else:
# basedir = '/Volumes/BOOTCAMP/data/Antarctic/OIB/ATM/2009_AN_NASA_ATM'
# Get date of gravity flight TODO make this user specified or for all flights
# infile = 'IGGRV1B_20091104_13100500_V016'
# subframe = 2009110401047
timedir = '2009.10.31'
# subframe = 2009103102018
subframe = 2009103102021
#infile = 'IGGRV1B_20091116_15124500_V016'
#subframe = 2009111601039
#########################################################
### Run functions to read in each data set
infile = 'IGGRV1B_20091031_11020500_V016'
grv = {}
grv = importOIBgrav(basedir,timedir,infile)
infile = 'IRMCR2_20091031_01'
rad = {}
rad = importOIBrad(basedir,timedir,infile)
#
# infile = 'IGGRV1B_20091031_11020500_V016'
# atm = {}
# atm = importOIBatm(basedir)
# #########################################################
# ### Subsample all to 2 Hz
# #########################################################
# rad2hz = {}
# rad2hz = rad.resample('500L').mean().bfill() #mean,median,mode???
# # atm2hz = atm.resample('500L').mean()
# rad2hz.rename(columns={'SURFACE': 'SURFACE_radar'}, inplace=True)
# print "******************"
# print "Original Radar Data"
# print "******************"
# print(rad[['TIME','UNIX','ELEVATION']].head(15))
# # print rad.DATE.dt.strftime('%Y-%m-%d %H:%M:%S.%f').head(5)
# print "******************"
# print "2 Hz Radar Data"
# print "******************"
# print(rad2hz[['TIME','UNIX','ELEVATION']].head(5))
# # print rad2hz.DATE.dt.strftime('%Y-%m-%d %H:%M:%S.%f').head(5)
#########################################################
### concat?
#########################################################
# df = {}
# df = pd.concat([grv, rad2hz[['THICK','ELEVATION','FRAME','SURFACE_radar','BOTTOM','QUALITY']], atm2hz[['SURFACE_atm']]], axis=1,join_axes=[grv.index])
# df['DAY'] = df.index.day
# df['HOUR'] = df.index.hour
# df['ICEBASE'] = df['ELEVATION']-df['BOTTOM']
# df['TOPOGRAPHY'] = df['ELEVATION']-df['SURFACE_radar']
#df.drop['TIME2']
### Some plots
#df['FAG070'].plot
#fig, axes = plt.subplots(nrows=2, ncols=1,figsize=(16, 12))
#df['FAG070'].plot(ax=axes[0],legend=True);#axes[0,0].set_title('A');
#df['ICEBASE'].plot(ax=axes[1],legend=True);#axes[0,0].set_title('A');
#########################################################
### append!
#########################################################
rad.rename(columns={'LON': 'LON_radar'}, inplace=True)
rad.rename(columns={'LAT': 'LAT_radar'}, inplace=True)
rad.rename(columns={'TIME': 'TIME_radar'}, inplace=True)
df=grv.append(rad).sort_index()
df['ICEBASE'] = df['ELEVATION']-df['BOTTOM']
df['TOPOGRAPHY'] = df['ELEVATION']-df['SURFACE_radar']
df2hz = df.resample('500L').mean().bfill() #mean,median,mode???
#########################################################
### Make some plots
### mapplotOIBlocal(x,y,z,title,units,range,colormap)
#mapplotOIBlocal(df['LON'], df['LAT'], df['FAG070'], 'FAG070','mGal',[-80,100],cm.jet)
#mapplotOIBlocal(atm2hz['LON'], atm2hz['LAT'], atm2hz['SURFACE'], 'SURFACE_2hz','meters',[0,2000],cm.terrain)
#mapplotOIBlocal(rad2hz['LON'], rad2hz['LAT'], rad2hz['THICK'], 'THICK_2hz','meters',[100,1200],cm.jet)
#mapplotOIBlocal(grv['LON'], grv['LAT'], grv['FX'], 'FAG070_2hz_20091104','mGal',[-50,150],cm.RdBu)
#mapplotOIBlocal(df10s['LON'], df10s['LAT'], df10s['HOUR'], 'TIME','Hour',[13,24],cm.jet)
#plt.figure(); df.ix['2009-10-31 15:30:00':'2009-10-31 15:50:00'].plot(subplots=True,layout=(5,6),figsize=(11, 8));
#########################################################
### subset one glacier profile by hand
df_sub = df['2009-10-31 14:10:00':'2009-10-31 14:50:00']
#
# Larsen C
#df_sub = df['2009-11-04 23:00:00':'2009-11-04 23:15:00']
#df_sub = df.loc[df['FRAME'] == 2009110401046]
#df_sub = df.loc[df['FRAME'].isin(['2009110401047','2009110401048'])]
#
# THE ONE BELOW WORKS
# df_sub = df.query('(FRAME <= @subframe+2) & (FRAME >= @subframe-2)')
### using FX moving average
# window = 240 for plane maneuvers > 2 minutes
grv['FX_MA'] = grv['FX'].rolling(window=240, center=True).mean()
grv_sub = grv.query('(WGSHGT < 3000) & (FX_MA < 70000)')
# plots
grv['FAG070'].where((grv['WGSHGT'] < 3000) & (grv['FX_MA'] > 100000)).plot()
# overplot
plt.figure(facecolor='w')
grv['FX'].where((grv['WGSHGT'] < 3000)).plot()
grv['FX_MA'].where((grv['WGSHGT'] < 3000)).plot(color='red')
# mapplot
mapplotOIBlocal(grv['LON'], grv['LAT'], grv['FAG070'].where((grv['WGSHGT'] < 3000)), 'test','mGal',[-50,150],cm.RdBu)
mapplotOIBlocal(grv['LON'], grv['LAT'], grv['FX_MA'].where((grv['WGSHGT'] < 3000)), 'test','mGal',[-100000,100000],cm.RdBu)
mapplotOIBlocal(grv_sub['LON'], grv_sub['LAT'], grv_sub['FAG070'], 'test','mGal',[-50,150],cm.RdBu)
#########################################################
### LINE plots
#plt.figure(); df_sub.plot(subplots=True,layout=(4,8),figsize=(16, 12));
# more control
fig, axes = plt.subplots(nrows=2, ncols=1,figsize=(12, 8))
df_sub['FAG070'].where((df_sub['FLTENVIRO'] == 1)).plot(ax=axes[0],legend='Good',style ='k-');#axes[0,0].set_title('A');
df_sub['FAG070'].where((df_sub['FLTENVIRO'] == 0)).plot(ax=axes[0],legend='Maybe',style ='r-');#axes[0,0].set_title('A');
df_sub['FAG070'].where((df_sub['FLTENVIRO'] == -1)).plot(ax=axes[0],legend='Maybe',style ='g-');#axes[0,0].set_title('A');
# df_sub['FAG140'].plot(ax=axes[0],legend=True,style ='r-');#axes[0,0].set_title('A');
df_sub['ELEVATION'].plot(ax=axes[1],legend=True,style ='g');#axes[0,0].set_title('A');
df_sub['ICEBASE'].plot(ax=axes[1],legend=True,style ='k');#axes[0,0].set_title('A');
df_sub['TOPOGRAPHY'].plot(ax=axes[1],legend=True,style ='b');#axes[0,0].set_title('A');
plt.suptitle(str(subframe), y=1.02)
plt.savefig('profile_'+str(subframe)+'_sub.pdf',bbox_inches='tight') # save the figure to file
fig, axes = plt.subplots(nrows=2, ncols=1,figsize=(12, 8))
df2hz['FAG070'].where((df2hz['FLTENVIRO'] == 1)).plot(ax=axes[0],legend='Good',style ='k-');#axes[0,0].set_title('A');
df2hz['FAG070'].where((df2hz['FLTENVIRO'] == 0)).plot(ax=axes[0],legend='Maybe',style ='r-');#axes[0,0].set_title('A');
df2hz['FAG070'].where((df2hz['FLTENVIRO'] == -1)).plot(ax=axes[0],legend='Maybe',style ='g-');#axes[0,0].set_title('A');
# df2hz['FAG140'].plot(ax=axes[0],legend=True,style ='r-');#axes[0,0].set_title('A');
df2hz['ELEVATION'].plot(ax=axes[1],legend=True,style ='g');#axes[0,0].set_title('A');
df2hz['ICEBASE'].plot(ax=axes[1],legend=True,style ='k');#axes[0,0].set_title('A');
df2hz['TOPOGRAPHY'].plot(ax=axes[1],legend=True,style ='b');#axes[0,0].set_title('A');
plt.suptitle(str(subframe), y=1.02)
plt.savefig('profile_'+str(subframe)+'_2hz.pdf',bbox_inches='tight') # save the figure to file
#########################################################
### Mapplots
mapplotOIBlocal(dfsub['LON'], dfsub['LAT'], dfsub['FAG070'], 'FAG070_2hz_'+str(subframe),'mGal',[-50,150],cm.jet)
mapplotOIBlocal(dfsub['LON'], dfsub['LAT'], dfsub['TOPOGRAPHY'], 'SURFACE_'+str(subframe),'meters',[0,2000],cm.terrain)
mapplotOIBlocal(dfsub['LON'], dfsub['LAT'], dfsub['ICEBASE'], 'ICEBASE_'+str(subframe),'meters',[0,2000],cm.terrain)
#########################################################
### Add Line Channel
df['LINE'] = int(str(dfsub['LAT'][-3:]))
#########################################################
### Save to CSV
#dfout = df[]
dfsub.to_csv('OIB_'+str(subframe)+'.csv')
df.to_csv('OIB_'+str(subframe)[:8]+'.csv')
#df10s = df.resample('10s').mean()
#df10s.to_csv('OIB_2009-11-04_10sec.csv')
#mapplotOIBlocal(df10s['LON'], df10s['LAT'], df10s['FAG070'], 'FAG070','mGal',[-80,100],cm.jet)