import pandas as pd

if __name__ == "__main__":
    fname='HWM_Harvey2017.csv'
    data=pd.read_csv(fname)
    hwm_df = data[['latitude_dd', 'longitude_dd', 'elev_ft', 'verticalDatumName', 'height_above_gnd']]
    df_filtered=hwm_df[hwm_df['verticalDatumName'] == 'NAVD88']
    df_filtered['elev_m']=df_filtered['elev_ft']*0.3048
    #df_filtered.rename(columns={'elev_ft': 'elev_m'})
    df_filtered.to_csv('HWM_Harvey2017_filtered.csv')