Python Forum
Assigning Data from one column to another with different associated timing interval - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Assigning Data from one column to another with different associated timing interval (/thread-26405.html)



Assigning Data from one column to another with different associated timing interval - alexafshari - Apr-30-2020

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


RE: Assigning Data from one column to another with different associated timing interval - pyzyx3qwerty - Apr-30-2020

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