taxi_data['flag'] = 1 taxi_data_pivot = taxi_data.pivot(index='taxi_id', columns='geohash', values='flag').fillna(0.0)