Vectorizing operation involving multiple DataFrames

[Viswanath Potluri]

On Wednesday, July 4, 2018 at 7:51:19 PM UTC-7, Viswanath Potluri wrote:
> I've a dataframe all_paths with say 9000 rows, and i've another dataframe Legs with 4000 rows. I need to filter all_paths dataframe based on a column called 'itineraries' which contains a list of strings, for each row in Legs. So, basically its like getting a dataframe that is subset of all_paths for each row in Legs. Then I need to perform a math operation on the columns of each subset and assign the values back to another column in all_paths. Following is my implementation
> 
> def step1_vec(iti_list, idx):
>   mask= all_paths.loc[all_paths['Path'].isin(iti_list)]
>   Legs.loc[idx,'r']=np.dot(mask['demand'].values, mask['u'].values.T)
>   Legs.loc[idx, 't']= Legs.loc[idx, 'k']/Legs.loc[idx, 'r']
> 
> def step2():
>   not_full_legs=Legs.loc[(~Legs['Leg ID'].isin(full_legs))&(Legs['t']<1)]
>   np.vectorize(step1_vec (not_full_legs['itineraries'].values,not_full_legs.index.values)

does someone has a solution for my question??