def rename_columns_all(df):
    """
    takes in selected dataframe and renames columns to intuitive non-capitalized titles
    """
    return df.rename(index=str, columns={'inspkey':'inspection_key',
                                         'servno':'service_number',
                                         'reportdate':'report_date',
                                         'spill_st_name':'spill_street_name',
                                         'total_gal':'total_gallons',
                                         'galsret':'gallons_returned',
                                         'gal':'gallons_1',
                                         'spill_start':'spill_start_1',
                                         'spill_stop':'spill_stop_1',
                                         'hrs':'hours_1',
                                         'unitid':'unit_id_1',
                                         'unitid2':'unit_id_2',
                                         'earz_zone':'edwards_zone',
                                         'expr1029':'expr_1029',
                                         'pipediam':'pipe_diameter',
                                         'pipelen':'pipe_length',
                                         'pipetype':'pipe_type',
                                         'instyear':'installation_year',
                                         'dwndpth':'downstream_depth',
                                         'upsdpth':'upstream_depth',
                                         'rainfall_less3':'rainfall_less_3',
                                         'spill address': 'spill_address_full',
                                         'sewerassetexp':'sewer_asset_exp',
                                         'prevspill_24mos':'previous_spill_24mos',
                                         'unittype':'unit_type',
                                         'assettype':'asset_type',
                                         'lastclnd':'last_cleaned',
                                         'responsetime':'response_time',
                                         'responsedttm':'response_datetime',
                                         'public notice':'public_notice',
                                         'timeint':'time_int',
                                         'hrs_2':'hours_2',
                                         'gal_2':'gallons_2',
                                         'hrs_3':'hours_3',
                                         'gal_3':'gallons_3'
                                          })