I am trying to merge two dataframes in Python, pandas, df1 and df2.

I am trying to merge two dataframes in Python, pandas, df1 and df2.

I am trying to merge two dataframes in Python, pandas, df1 and df2.

I’m currently working with some phones numbers DataFrames and I need to merge them in a substring criteria way and has to be an left merge (meaning to have all combinations in case there is more than 1 coincidence).

I have two dataframes and I need to perform a smear (if that is what it’s generally called). Basically the first one is smaller (5 million rows) and the other is 40 million rows. I want to add the first value of dataframe 1 to the first 8 values of dataset 2, the second from dataframe 1 to the second set of 8 in dataframe 2 and so on.
For example: