Get Value from List to Show in DataFrame Column

[ahmedwaqas92]

I have a dataframe with a little more than 15000 rows. I also have three lists (c_iddf, p_iddf, cr_iddf) that I converted from a .csv file, so all the lists have equal number of elements.

The dataframe df looks something like this
,

    Login      Caller ID   Called number    Call Start         Call end     Duration (s) block  Effective Duration (s)    blocks 
0  6072132500  6072132500    0320585339  01/05/2020 16:25  01/05/2020 16:25   19           60          60                    1.0    
1  6072132500  6072132500           100  01/05/2020 21:04  01/05/2020 21:05   16           60          60                    1.0  
2  6072132500  6072132500    1300883000  01/05/2020 21:08  01/05/2020 21:08    9           60          60                    1.0
3  6072132500  6072132500         15454  01/05/2020 21:13  01/05/2020 21:14    4           60          60                    1.0   
4  6072132500  6072132500    1300883000  01/05/2020 21:14  01/05/2020 21:14   16           60          60                    1.0

I want to check if the column 'Called number' has any values from p_iddf. If it has, then record the index of the element in the list p_iddf that matches the Called number value, and use that to get elements (with the same index number) from c_iddf and cr_iddf. I don't know if my logic is correct or not and would like suggestions on how I can do this some other way but if I add:

df['Check'] = df['Called number'].str.startswith(tuple(p_iddf))

It does give me the correct boolean result (another column called Check with True and False)however I don't know how to get index numbers of p_iddf that matches with 'Called number' & the corresponding values from c_iddf and cr_iddf as per the index.

[ahmedwaqas92]

I have successfully solved this set by introducing a function which searches stings in the df using a list, that initially joins all the elements I would want to pass through the data frame and then returns the value on a new column of the element that matched in the df. The code is as below:

iddf = pd.read_csv('idd.csv', names=['country', 'prefix', 'rate', '1'])
iddf = iddf.drop(['1'], axis=1)
iddf = iddf.astype(str)
iddf['prefix'] = '00' + iddf['prefix']
prefix = iddf['prefix'].values.tolist()

#Developing Pattern for IDD Regex Search
pattern = '|'.join(prefix)
def pattern_searcher(search_str:str, search_list:str):

    search_obj = re.match(search_list, search_str)
    if search_obj :
        return_str = search_str[search_obj.start(): search_obj.end()]
    else:
        return_str = 'NaN'
    return return_str

df['prefix'] = df['Called number'].apply(lambda x: pattern_searcher(search_str=x, search_list=pattern))

The above code returns a new column called prefix which first matches prefix to the column 'Called number' and then returns the prefix which was matched. Using this prefix I could then map a dictionary and get more values if I want.