Python Forum

Hi Everyone,

I`m struggling to find a solution to resolve my issue regarding assign some data from one series of a dataset to a specific column. You can see the excel file at the below link, I have illustrated what I have and what I want.
My DataSample

Please excuse amateur coding literacy.

I have two General Data Columns: 1) General data&time 2)General Attraction
Also, I have two other Individual Customer Columns (User Data): 1) Customer data&time 2) Profit of Customer

I want to assign data from General Data to User Data with equal or the closest timing that matched and create a new 4 columns 1)matched data & time 2) general attraction, timing wised associated to the user 3)user data & time. 4)profit

Would you please help me how can I resolve this problem with python?

Thanks in advance

What have you tried? Show us and we will be able to help you